Assignment 19

Volume I

ACCESS CHAPTER 2

Tables and Forms: Design, Properties, Views, and Wizard

(Volume I, second chapter on the section with orange page number flags)

Warning: Be sure to save your work frequently and back up your work.

·       Do Knowledge Test K19 at the beginning of the class. Do Skill Test S19 “Access Chapter 2” toward the end of the class. Be sure to use S02 as the ID in the skill test.

1.   Read pages 50 to 55

2.   Do Hands-on Exercise 1: Creating a Table, steps 1 to 12

a.   Step 1: Make sure you save the database as My First Database

b.   Step 12: Print the table, and hand in the printout as part of your assignment 19.

3.   Read pages 65 to 70

4.   Do Hands-on Exercise 2: Creating a Form, steps 1 to 9

a.   Step 9: Do not print at this time.

5.   Read pages 79 and 80

6.   Do Hands-on Exercise 3: A More Sophisticated Form, steps 1 to 11

a.   Step 10: Instead of the record shown in figure 2.9h, add SSN: 123-45-6789, your first and last name, you can add your information or make up information for Address, City, State, Postal Code and Phone Number, Birth Day, Gender, Credits, Quality Points major and Campus.

b.   Step 10: Print the form with the record that has your information, and hand in the printout as part of your assignment 19.

7.   Do Practices 1 and 2 on pages 92 to 94. After you are through with practice 2, find the record containing your name, Fill in data for the three field you have just created, and print the record. Turn it in as a part of your assignment 19.

8.   Staple and turn in your printouts. Use this sheet as cover adding your section number, name and computer number.

FOR NEXT CLASS  BRING VOLUME I

READ ACCESS CHAPTER 3 Information from the Database: Reports and Queries

(Volume I, third chapter of section with orange page number flags)

Read pages 102 to 107, 115 to 120, 127, and 129