Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 2: CREATING THE DATABASE, QUERIES, AND REPORT
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 with a subform, several 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 six sports teams with at least three different sports.
￿
Create records for at least 10 students and have them join multiple teams.
￿
Make up at least 10 games, and vary the beginning time and ending time of each.
￿
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.
Assignment 2B: Creating Forms, Queries, and a Report
You will generate one form, six queries, and one report, as outlined in the Background section of this case.
Form
Create a form and subform based on your Students table and Team Members table (or whatever you
named these tables). Save the form as Students and Team Members. Your form should resemble that in
Figure 3-2.
FIGURE 3-2
Students and Team Members form and subform
Query 1
Create a query called Students without Physical Exam. Include headings that list the Name, Local Address,
and Cell Phone of students who have not had medical exams. Your output should resemble that in Figure 3-3,
although your data will differ.
 
Search JabSto ::




Custom Search