The Actual Access Exam

1) Start Access

2) Create a New blank database and name it Exam4.mdb

3) Create a table named StudentInfo in design view with the following fields:
a) SSN, Text, As a Primary Key, with a field Size of 9, and an Input mask for Social Security Numbers.
b) FirstName, LastName as Text
c) Gender as Text, with field size of 1, a validation rule that it must be M or F, and a Validation Text to explain this rule in case someone violates it.
d) Major

Create a second table named Roster in design view with the following fields:
a) ID as a primary key. An autonumber.
b) SSN as a foreign key.
c) CourseName as Text
d) DidHomeWork as a Yes/No field.
e) Grade as Number.

Create a relationship between the two tables based on the SSN field.

4) Enter DataSheet View for Students and enter Data for 3 students. Close the table.
Enter DataSheet View for Roster and enter Data for 3 students. Close the table.

5) Create a form for the Students table using the Wizard. Move all the fields to appear on the form. Clicking Finish should bring you to the created form.

6) Enter into design mode for the form. Add a button which closes the form.

7) Create a report for the Students table using the wizard. Add a text box in the top-right corner showing the current date in Short Date Format.

8) Create a simple query, showing info from the StudentInfo table. Make "FirstName Lastname" into a single calculated field. Only show students whose Major is undecided.

9) Create a more complicated query, showing info from both tables. From StudentInfo, select FirstName and LastName. From Roster, select CourseName, DidHomeWork and Grade.

10) Call me over to get your test, or email it to me.