Instructions:

Create Access database.

Table Structure consistent with the information needs and database design issues. Tables and fields defined as suggested below and populated with limited data. Use simple attributes and use only static derivable attributes. All employees information is maintained in one table. Field definitions should give evidence of appropriate choices for data types, length, formats, etc.

Helpful Hints:

1-All table names should begin with tbl followed by the name (i.e. tblcash)

2-All attribute names and table names should contain no spaces

3-Choose appropriate data types for each attribute. Only numbers used in calculations should be given a number data type.

4-If you choose a data type of text , you need to change the field size to an appropriate length

5-Every table needs a primary key

6-All foreign keys need to have the same data type as the primary key, with one exception. If a primary key has an a auto_number data type, the foreign key should have a data type of a number

7-Create the tables (and enter data into your tables) with no foreign keys first (data reduction tables, followed by resource and agent tables, followed by event tables and then relationship tables)

8-After you create your tables, draw the relationship lines and enforce referential integrity.

9-Finally, each table needs to have a minimum of 3 rows of data entered into each attribute. Make up appropriate information.

Resource: Table name and attributes

1.Warehouse,location table table- *Warehouse area number, product quantity on hand at warehouse area, warehouse description

2.Inventory Table *Product code, Product standard selling price, product unit measurement, Product standard selling price, product standard cost, Product name

3. Cash Cash account name

4.Order *order number, Order date, order selling price of product code, Date order needed

5.Sale/Shipment *sale number, actual selling price of product code, Actual quantity of product code sold, sales date

6.Cash Receipts date of cash receipt, *Remittance number, cash account number, Cash receipt amount, Customer check number, Customer Account Receivable Balance

7.Customer Table Customer number, Customer name customer street, Customer fax Customer telephone,

8.Employee *employee code ID, Employee social security number, Employee first name Employee last name

9.Warehouse-inventory *Warehouse area number, *Product code,

10.Inventory -order *Product, code, *order number

11.inventory-sale *Product code, *sale number

12.order-employee *Order number, *employee code ID

13.sale-employee *Sale number, *employee code ID

*Primary Key

Other Instructions:

et can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing the end of this session you should be able to: Perform simple Queries 1. Download the file "Access File 2 Database" from WebCT Click on Database Tools, the relationship button, and the Show Table Button. Add the tables and draw the relationships and enforce referential Integrity. a. b. Examine the data in each table so you understand the contents of each table c. Practice on the following queries. To show your Tables in the Navigation Pane: Naigate To Catepary Click the drop down arrow in the upper left hand pane and click on Tables uste Qbjet typt Tables and Relsted Views Created Dste Modfind Date ritei By Group Tables Queries Eeems To show your Queries in Navigation Pane: Click Queries Click the Create Tab Click on Query Design A new Query and the Show Tables Dialog Box should appear ort Query Query Macio ign |Wizaid Design Other Now add the tables you need by double clicking on them or click on the table and then click on the Add Button After adding all the tables you want for your query, click on the Close Button 1 Create a query that sorts the customer Put the table tblCustomer in your query include: Ltable hv zincode last nome first nome nccunntion and zincode in the nuerv orid hv dauble