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. Lesson 4 : More Data, More Tables The Home Ribbon 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
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.
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