External Data Ribbon

 

1. Readings
 Read Lesson 10 in the Advanced Access guide, page 275-307.
 

Project

Several Action Queries that Append, Update and move the data in the Tables.

 

Downloads

FrontRowVideo Adv10.accdb

tblMoviesNEW.xlsx

BBL Adv ver10.accdb

 

2. Practice

Do the Practice Activity on page 308.

 

3. Assessment

Review the Test questions on page 308.
 
 

Lesson 10 : Strategies for Archiving

 
   
Query Design Tools->Design

Menu Maps

From the External Data Ribbon.

1. Microsoft Access->External Data ->Import & Link-> Excel, page 282

 

From the Create Ribbon.

Create->Queries->Query Design-> Find Duplicates Query Wizard, page 286

 

From the Report Design Ribbons.

2. Query Tools ->Design->Query Type-> Update, page 300

3. Query Tools ->Design->Query Type-> Make Table, page 302

4. Query Tools ->Design->Query Type->Delete, page 305