Access Basics

• 1

  Introduction to Databases ✓

  Learn all about an Access database and how it works.

• 2

  Database Terms ✓

  Familiarize yourself with some of the most common Access database terms.

• 3

  Starting Access ✓

  Learn how to start Access 2000 so you can start navigating your way through this database program.

• 4

  Database Tables ✓

  Learn how to read, manipulate, and create Access database tables.

Working with Tables and Forms

• 5

  Adding Table Records ✓

  Learn how to add, populate, resize, and save table records in your Access database.

• 6

  Editing Table Records ✓

  Learn all about editing, moving, and checking the spelling on your table records in Access.

• 7

  Deleting Table Records ✓

  Learn how to delete table records in your Access database.

• 8

  Adding Form Records ✓

  Learn all about adding form records to your Access database, as well as opening and navigating existing forms.

• 9

  Editing Form Records ✓

  Learn all about editing form records in your Access database.

• 10

  Deleting Form Records ✓

  Learn how to delete form records from your Access database.

Finding Records and Creating Reports

• 11

  Sorting Records ✓

  Learn how to review table records and form records concepts, perform a simple sort, and save a sort in Access.

• 12

  Sorting Multiple Records ✓

  Learn how to perform a multi-field sort, as well as remove a sort, in your Access database.

• 13

  Finding Records ✓

  Learn how to perform a simple find and use a wild card in your Access database search.

• 14

  Filtering Records ✓

  Learn all about performing a filter by selection and by form to find the data you need in Access.

• 15

  Queries ✓

  Learn all about defining a query, running an existing query, and creating a simple select query in Access.

• 16

  Creating a Report ✓

  Learn how to create reports using the AutoReport and Report Wizard features in Access.

• 17

  Printing a Report ✓

  Learn how to open an existing report, as well as preview and print it, from your Access database.