**Introduction to Microsoft Access**

Student Learning Outcomes:

Mar. 21

Microsoft Access: Lesson 1

Step-By-Step Exercises 1.1 ~ 1.16

Access Projects:

• Project 1-1: (Restaurants)
• Project 1-2: (Employees)
• Project 1-3: (Stores) - **PRINT THIS**
• (Print in Landscape if needed to fit on one page, OR Print Only Page 1).
• UPLOAD ALL

Mar. 26

Microsoft Excel: Lesson 6 / Lesson 7 (Supplement)

Microsoft Access: Lesson 2

Step-By-Step Exercises 2.1 ~ 2.9

Access Projects:

• Project 2-1: (Music)
• Project 2-2: (Retail Stores)
• Project 2-3: (Company) - **PRINT THIS**
• (Print in Landscape if needed to fit on one page, OR Print Only Page 1).
• UPLOAD ALL

Microsoft Access: Lesson 3

Access Projects:

• Project 3-2: (Listings)
• Project 3-3: (Realtors) --**PRINT THIS**
• (Print in Landscape if needed to fit on one page, OR Print Only Page 1).
• UPLOAD ALL

Microsoft Access: Lesson 4

Step-By-Step Exercises 4.1 ~ 4.11

Access Projects:

• DO NOT do the Projects
• Complete Step-By-Step 4.1 ~ 4.11 (Page AC 90-107)
• SKIP 4.3, 4.4, 4.5, 4.6
• UPLOAD Broker

Microsoft Access: Lesson 5

Step-By-Step Exercises 5.1 ~ 5.11

Access Projects:

• Project 5-1: (Sales)
  • Brokers
  • Listings
• Project 5-2: (Supplies)
• Project 5-3: (Agencies) - -**PRINT THIS**
• (Print in Landscape if needed to fit on one page, OR Print Only Page 1).
• UPLOAD ALL

Microsoft Access: Lesson 6

Step-By-Step Exercises 6.1 ~ 6.8

Access Projects:

• Project 6-1:
  • Import Excel to Acess
  • Products.xlsx (Excel) import to Products Table (Access)
  • Upload Inventory.accdb (Database file)
• Project 6-3:
  • Merge Access and Word
  • InfoTech - Access file
  • Abbott - Word (Mail Merge) file
  • Upload Abbott.docx (Word document)

**Wrap up Microsoft Access**

**Access Mastery TEST**

Did you do the following projects:

• Project 1-3: (Stores)
• Project 2-3: (Company)
• Project 3-3: (Realtors)
• Lesson 4: (Brokers)
• Project 5-3: (Agencies)

Integrate Excel & Word:

Simulation: (Page EX206 - EX207)

• Download Excel Unit Review folder.
• Complete Job 1.
  • Save in Excel Unit Review folder.
• Print Java Menu.docx (Word file).
  • Should only be 1 page.
• Upload Java Menu.docx (Word file) into Excel folder.