The External Data Ribbon

 

1. Readings
Read Lesson 4 in the Beginning Access guide, page 75-99.
 

Project

Import an Excel spreadsheet into Microsoft Access. Create and modify a product table.

 

Downloads

FrontRowVideo Begin4.accdb.

tblMovies.xlsx.

Brown Bag Lunch ver4.accdb

Brown Bag Products.xlsx

 

2. Practice

Complete Practice Activity on page 100.

 

3. Assessment

Review the Test questions on page 100.

 
 

Lesson 4 : More Data, More Tables

 

   
The Home Ribbon (continued)

Menu Maps

From the External Data Ribbon.

1. External Data ->Import & Link->Excel, page 85

 

From the Home Ribbon.

2. Home ->Find ->Find, page 93

3. Home ->Sort & Filter-> Descending, page 94

4. Home ->Sort & Filter-> Filter, page 95

5. Home ->Sort & Filter-> Selection, page 96

6. Home ->Views->View->Design View, page 97