Microsoft Office Tutorials and References
In Depth Information
In the Lab continued
Instructions: Perform the following tasks:
1. Create a new database in which to store all the objects related to the technical services data. Call
the database JMS TechWizards.
2. Create a table in which to store the data related to clients. Use the name Client for the table. The
fi elds for the Client table are: Client Number, Client Name, Street, City, State, Postal Code,
Telephone Number, Billed, Paid, and Technician Number. Client Number is the primary key. The
Billed and Paid fi elds are currency data type.
3. Create a table in which to store the data related to technicians. Use the name Technician for the
table. The fi elds for the Technician table are: Technician Number, Last Name, First Name, Street,
City, State, Postal Code, Hourly Rate, and YTD Earnings. The primary key for the Technician
table is Technician Number. Hourly rate and YTD Earnings are currency data type.
4. Add the data from the Client workbook in Figure 1–103a to the Client table.
5. Add the data from the Technician workbook in Figure 1–103b to the Technician table.
6. Create and save the reports shown in Figure 1–104a for the Client table and Figure 1–104b for the
Technician table.
7. Change the database properties, as specifi ed by your instructor. Submit the revised database in the
format specifi ed by your instructor.
(a) Billing Summary Report
(b) Salary Report
Figure 1–104
In the Lab
Lab 2: Creating the Hockey Fan Zone Database
Problem: Your town has a minor league hockey team. The team store sells a variety of items with the
team logo. The store purchases the items from suppliers that deal in specialty items for sports teams.
Currently, the information about the items and suppliers is stored in the Excel workbook shown in
Figure 1–105. You work part-time at the store, and your boss has asked you to create a database that
will store the item and supplier information. You have already determined that you need two tables: an
Item table and a Supplier table in which to store the information.
Instructions: Perform the following tasks:
1. Design a new database in which to store all the objects related to the items for sale. Call the
database Hockey Fan Zone.
Search JabSto ::




Custom Search