Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORT
NOTE
Have your design approved before beginning Assignment 2; otherwise, you may need to redo Assignment 2.
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORT
In this assignment, you will first create database tables in Access and populate them with data. Next, you will
create a form, queries, and a report.
Assignment 2A: Creating Tables in Access
In this part of the assignment, you will create your tables in Access. Use the following guidelines:
￿
Create at least 10 members of the jet leasing service, including yourself as a member, and record
the three types of airplanes. You can make up fictional names, addresses, and phone numbers
for members, but use the types of airplanes listed in Figure 2-1.
￿
Create records for four pilots, using your friends
names as fictional pilots.
￿
Each member should reserve an airplane flight, and at least four members should reserve more
than one.
￿
Appropriately limit the size of the text fields; for example, a telephone number does not need
the default length of 255 characters.
￿
Print all tables if your instructor requires it.
Assignment 2B: Creating Forms, Queries, and a Report
You will generate one form with a subform, five queries, and one report, as outlined in the Background
section of this case.
Form
Create a form and subform based on your Members table and Reservations table (or whatever you named
these tables). Save the form as Members and Reservations. Your form should resemble that in Figure 2-3.
FIGURE 2-3
Members and Reservations form and subform
 
Search JabSto ::




Custom Search