Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 More

The Indie Scene

Rave Reviews

 

Click Here to Get Started

Sample Files

 

Administrator Objectives:

Lesson Objectives: Learn strategies for archiving data and options for importing and exporting your data. This lesson will show how to copy table structure and data, filter the data with a query, create action queries, and how to export and import data. In this lesson you will:

Review strategies for archiving data Page 4

Identify the steps needed to copy a Table Page 5

Learn how to create Memo and Multi-value fields Page 6

Practice the steps to create an Update Query Page 10

Practice the steps to create a Make Table Query Page 12

Practice the steps to Find Unmatched records Page 13

Practice the steps to Find Duplicates Page 15

Practice the steps to create a Delete Query Page 19

Learn how to Export to Excel Page 21

Investigate Office Integration Page 23

Learn how to Import from Excel Page 30