Summary Of The Steps To Create A Database

Submitted By ivytaxau
Words: 1011
Pages: 5
Open Document
Table of Contents

Access Summary of the steps to create a database

1. Design the database
a. What OUTPUT do you require
i. What input will be require to give you the output
2. Create the database
3. Design the tables
4. Create the tables
a. Use the Design View
b. Remember to name the table and the fields appropriately
5. Create the relationships between the tables – do this BEFORE you add any data to the tables.
a. Remember to enforce the referential integrity
6. Create the forms
a. Use the Wizard
7. Input the data
8. Create Queries
a. Use the Design View
9. Create Reports
a. Use the Wizard

Executive Summary

2.0 Introduction

Microsoft Access is an example of a relational database management system for desktop computers. The relational data model was created by Dr. E. F. Codd in 1970. Prior to this, querying a database had involved complex and lengthy programming. Codd’s model was a marvellous breakthrough allowing much greater ease and flexibility of use. It proposed a reliance on relationships between data values organised in tables of columns and rows, rather than a need to know how data is organised inside the computer (IBM News, 2003). In 1985, Codd published twelve rules defining the ideal relational database, two of which are: that all data should be presented in table form, and that all data should be accessible without ambiguity (Accela Communications, 2001). We can see the operation of these two rules in the system presented here.
Brunswick Specialty Foods is a new wholesale business supplying exclusive food and drinks to retailers in regional Victoria. The business provided details of its customers and products. Sales data from its first month’s trading were also available to be entered into the database and used to update tables and produce reports.

3.0 Progress of the Project

3.1 Database design in Microsoft Access

The first step was to create a new database (in the Task Pane – New – Blank database). In the subsequent development of the database a prime concern was data normalization: avoiding redundancy and duplication, so that the database would be as efficient and easily maintained as possible (Brady & Monk, 2005).

3.2 Create tables and enter the reference file data

In this step, we created two tables. The first table was saved as “tbl Cards” which included the following fields: CardID, CardName, CardSupplier, CardFaceValue, CardPurchasePrice and CardSalePrice. CardID was identified as the primary key because it’s a unique allocation to identify the card.

In this step, two tables were created. The first was the “Customers” table, with the fields Cust_ID, Cust_Name, Credit, Discount and Head_Office. The field Cust_ID was the primary key field. The format of Cust_Name was set as “@_@@” so that the code format would be automatically applied as the letters and number were entered; “Yes/No” was selected as the format of the Credit field as it would be most convenient for users. The length of text fields was changed to accommodate different text lengths. The table was saved as “Customers”, opened in datasheet view and the reference file data was entered into it, as shown in Figure 1.0.

3.5 Query Database
a. Sales by Customer
To obtain monthly sales by customer required establishing a relationship between the Customers Table and the Order Details Query. However, these have no field in common, so the Orders Table was also included in this query because it could link them, having the Cust_ID field in common with the Customers Table and the Order_ID field in common with the Order Details Query. Cust_Name was selected from the Customers Table and a field “Total Sales” was calculated from the Order Details Query using the expression “Total Sales: Total_Price”. The Totals button “Σ” was clicked and “Sum” selected for the Total
Show More

Related Documents: Summary Of The Steps To Create A Database

ACCESS Class Assignment Report

This year, the ACCESS 2.0 will be administered to all of our English language learners ELLs) starting Tuesday, 1/16. The testing window is open until Friday, 2/9, however, the goal is to complete testing by Friday, 1/26. Since Bekah, Kathy Jasperse and I will be administering the test this year, we feel this is a realistic goal. For those who are not familiar with this assessment, the ACCESS test is a secure large-scale English language proficiency assessment given annually to students in kindergarten…

Words 264 - Pages 2

Technology Changes In America

“Many Americans still lack access to advanced, high-quality voice, data, graphics and video offerings, especially in rural areas and on Tribal lands”, according to the 2016 Broadband Progress Report adopted by the Federal Communications Commission. According to the report “10 percent of all Americans (34 million people) lack access to basic service (25Mbps/3Mbps)”. Accordingly of the 34 million people lacking access “39 percent of rural Americans (23 million people) lack access to 25 Mbps/3 Mbps, and…

Words 1536 - Pages 7

Unit 3 Assignment 1 Access Security And Security Requirements

Requirements The other requirements are required by EPOMS in maintaining the right integrity of document access and use. Moreover, it should be able to keep up an auditable track of activities engaged for a document without putting aside system ability to manage document regardless of the format and size. 4.0 Access Management 4.1 Access Security and Document Level Access control restriction is to limit the access based on the security level of documents created. Regardless of document format or type, each…

Words 906 - Pages 4

Week 5 Controls II Essay

purchasing v.p., and Ted, the controller. • Maria feels that Ted may have engaged in “creative accounting.” Introduction •Jason ponders the following issues: Should he describe the unusual transactions in his •report? Is a violation of proper control procedures acceptable if •it has been authorized by management? Regarding Jason’s assignment, does he have a •professional or ethical responsibility to get involved? Introduction…

Words 2410 - Pages 10

Essay on Try to demonstrate the access

deonstarte the access Try to deonstarte the access Try to deonstarte the access Try to deonstarte the access Try to deonstarte the access Try to deonstarte the access Try to deonstarte the access Try to deonstarte the access Try to deonstarte the access Try to deonstarte the access Try to deonstarte the access Try to deonstarte the access Try to deonstarte the access Try to deonstarte the access Try to deonstarte the access Try to deonstarte the access Try to deonstarte the access Try to…

Words 1515 - Pages 7

Efficiency & Collaboration Proposal Essay

essential to the company. With Microsoft® Access®, the ability to quote, schedule, track, ship and manage with ease can be realized. Microsoft® Access® will allow the company to organize any type of information. For example; customers, employees, staff evaluation, presentation of new product, stocks with interactive design capability. Microsoft® Access® also provides reports and forms that the company can present data in a uniform layout. Microsoft® Access® is a database program that combines data…

Words 682 - Pages 3

Importance Of Digitization

how well these functions are performed. The simplest example would be to take an item, consider the costs and benefits of digitizing it, and then compare this with not digitizing it. The easiest quantifiable method to use would be how this affects access. The libraries, museums and archives of the world are filled with materials recorded in many ‘analogue’ formats. These include paper and all its variants, for example vellum, papyrus, birch bark, wood and other substrates. Images can be represented…

Words 4137 - Pages 17

Essay Entity Relation Diagram

Contents ERD (Entity Relation Diagram) 2 2.1 History of ERD 2 2.2 Building Blocks 2 2.2.2 Relationship 2 2.3. Diagramming Conventions 3 MS ACESS TABLE 5 3.1 Parts of Table 6 3.2 Creating Tables in Access 6 Chapter No 2 ERD (Entity Relation Diagram) 2.1 History of ERD An entity-relationship model (ERM) is an abstract and conceptual representation of data. Entity-relationship modeling is a database modeling method, used to produce a type of conceptual schema or semantic data…

Words 3556 - Pages 15

Database and Access Essay

Access 2010 Handout 1: Microsoft Access 2010 Environment and Things You Should Know and Follow Table of Contents: Section Topic Page 1.1 You cannot unzip a zipped file directly on the Blackboard 2 1.2 mdb files vs. accdb files 2 1.3 Naming Database and Database Objects 2 1.4 Security Alert screen in Access 2007 or 2010: Important 2 & 3 1.5 Compacting and Repairing the database: Important 4 1.6 Access 2010/2007 Environment 5 1.6.1 The Access Main Menu Bar:…

Words 1899 - Pages 8

Essay on Barriers and Disparities in Health Care

Holsen R.N. – C.W.H.N.P. Barriers and Disparities in Health Care Everyone should have the opportunity to achieve a healthy life and have comprehensive health care services available to them. To achieve this healthy life, people need to have access to the health care system and to a health care provider with whom they can develop a trusting relationship. However, existing barriers to attaining health care services often lead to disparities which in turn lead to differences in life expectancy…

Words 916 - Pages 4