Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 1: CREATING TABLES
box type contains three vegetables and three fruits. The owners realize that they priced these
boxes too cheaply, so they want to notify all customers who ordered the
The
C
boxes that the price will be
increased by 20 percent next year. The owners want a listing of these customers so they can prepare a mass
e-mail that explains the price increase. Finally, the owners want to be able to produce a list of bills for a
particular month. Ideally, this information should be stored in a nicely formatted report.
C
ASSIGNMENT 1: CREATING TABLES
Use Microsoft Access to create the tables with the fields shown in Figures 1-1 through 1-3; these tables
were discussed in the Background section. Populate the database tables as shown. Add your name to the
Customers table with an appropriate customer ID; complete the entry by adding your address, phone
number, e-mail address, and a fictional credit card number.
FIGURE 1-1
The Customers table
FIGURE 1-2
The Boxes table
FIGURE 1-3
The Orders table
Search JabSto ::




Custom Search