Practice Activities

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 Short 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.