Microsoft Office Tutorials and References
In Depth Information
2. Use the information shown in
Figure 1–105 to determine the primary
keys and determine additional fi elds.
Then, determine the relationships
among tables and the data types.
3. Create the Item table using the
information shown in Figure 1–105.
4. Create the Supplier table using the
information shown in Figure 1–105.
5. Add the appropriate data to the
Item table.
6. Add the appropriate data to the Supplier table.
7. Create a split form for the Item table. Use the name Item for the form.
8. Create the report shown in Figure 1–106 for the Item table.
9. Change the database properties, as specifi ed by your instructor. Submit the database in the format
specifi ed by your instructor.
Figure 1–105
Figure 1–106
In the Lab
Lab 3: Creating the Ada Beauty Supply Database
Problem: A distribution company supplies local beauty salons with items needed in the beauty
industry. The distributor employs sales representatives who receive a base salary as well as a
commission on sales. Currently, the distributor keeps data on customers and sales reps in two Word
documents and two Excel workbooks.
Instructions: Using the data shown in Figure 1–107, design the Ada Beauty Supply database. Use the
database design guidelines in this chapter to help you in the design process.
Continued >
Search JabSto ::




Custom Search