The External Data Ribbon

 

Beginning Access Objectives

In this lesson, you will learn how to:

1. Import a Microsoft Excel spreadsheet into a new Table in an Access database.

2. Use the Design View to edit the Field Properties.

3. Sort and Filter Records in Access.

Menu Map
 
 

Lesson 4 : More Data, More Tables

 

   
The Home Ribbon
Menu Map

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