Lesson 2: Hello, Microsoft Access
Try This: Do the following steps
1. Open a new blank database. Name the database Brown Bag Lunch EAN
database, where EAN is your initials.
2. Add the following Text Fields. Do NOT include spaces.
Company
FirstName
LastName
Address
City
State
Zip
Phone
3. Add a new Record with the following information:
Computer Zone, Jennifer Whittly, 987 Pontiac Trail, Wixom, MI, 48939,
248-555-9854
4. Add these additional records:
Company |
FirstName |
LastName |
Address |
City |
State |
Zip |
Phone |
Bright Futures Academy |
Consuelo |
Justice |
123 Grand River Ave |
Novi |
MI |
48734 |
248-555-3913 |
Rhino Paper Printing |
Dwain |
Coffey |
5575 Michigan Ave |
Novi |
MI |
48734 |
313-555-6589 |
Travel Pal |
Stefan |
Alonzo |
1237 Main Street |
Milford |
MI |
48380 |
810-555-9172 |
Pixel Butter Web Design |
Valerie |
Carter |
3211 Eight Mile Road |
Novi |
MI |
48734 |
248-555-6878 |
5. Use Data Validation to mark the Phone
Number field as Required
6. Add the following record
to test the Data Validation: Pest People, Andrew, June,
1258 Grand River Ave, Milford, MI, 48380
7. Add the following phone
number for Pest People: 248-555-6882
8. Delete the Record for
Travel Pal.
9. Save the Table
as tblCustomers.
Close the Brown Bag Lunch
EAN database, where EAN is your initials.