Using Access to Complement Excel

Access and Excel do a good job of filling in each other’s rough spots. If you need to work with long lists of data, for example, you’ll appreciate the built-in Access tools that help make sure your information is entered without mistakes.

The following sections cover how to decide when to stay with Excel and when to use Access. You’ll also learn how to move your Excel data over to Access painlessly, and how to create Access forms and reports that work with Excel data.