**ALL PROJECTS are to be COMPLETED IN CLASS and DUE on the day assigned.

Accessing Student Data Files (On Campus)

1. ON-CAMPUS - CS151 / Access / Access 1 folder / Module folder
• Files do not exist, they need to be created (Riverview1, Vendor1, Beauty1).
• The 3 files (Kimberly, BeautyToGo, Company only contain information to copy from one database to another database).

ACCESS PROJECTS- (To be graded in class)

1. IN-CLASS DEMONSTRATION: Access1 Folder / Module Folder - (Page AC8 ~ 30)
• Create a new blank database named Riverview1 (followed your initials)
• Inside the database Create a Table Object saved as Visit
2. Page AC45 - Review Assignment (#1 - 7)
   • Create a new blank database named Vendor1 (followed your initials)
   • Inside the database Create a Table Object saved as Supplier
3. Page AC46 - Case Problem 1 (#1 - 7)
• Create a new blank database named Beauty1 (followed by your initials)
• Inside the database Create a Table Object saved as Option

Accessing Student Data Files (Off-Campus)

1. OFF-CAMPUS - Click on this Link to Google Drive for files.
   • Files do not exist, they need to be created (Riverview1, Vendor1, Beauty1).
   • The 3 files (Kimberly, BeautyToGo, Company only contain information to copy from one database to another database).

*Bring your book.

LESSON OBJECTIVES

1. SLO - Microsoft Access: Module 1
   • Create a Table Object using the Table button.

*Bring your book.

LESSON OBJECTIVES

1. SLO - Microsoft Access: Module 2
   • Create a Table Object using the Table Design button.

LESSON OBJECTIVES

1. SLO - Microsoft Access: Module 3a
   • Create a Simple Query Object using the Query Design button.

LESSON OBJECTIVES

1. SLO - Microsoft Access: Module 3b
   • Create a Complex Query Object using the Query Design button.

LESSON OBJECTIVES

1. SLO - Microsoft Access: Module 4a
2. Create a Form Object.

LESSON OBJECTIVES

1. SLO - Microsoft Access: Module 3a
2. Create a Report Object.