Access 2000

Access Basics

• 1

  Introduction to Databases arrow_forward_ios ✓ Learn all about an Access database and how it works.
• 2

  Database Terms arrow_forward_ios ✓ Familiarize yourself with some of the most common Access database terms.
• 3

  Starting Access arrow_forward_ios ✓ Learn how to start Access 2000 so you can start navigating your way through this database program.
• 4

  Database Tables arrow_forward_ios ✓ Learn how to read, manipulate, and create Access database tables.

Working with Tables and Forms

• 5

  Adding Table Records arrow_forward_ios ✓ Learn how to add, populate, resize, and save table records in your Access database.
• 6

  Editing Table Records arrow_forward_ios ✓ Learn all about editing, moving, and checking the spelling on your table records in Access.
• 7

  Deleting Table Records arrow_forward_ios ✓ Learn how to delete table records in your Access database.
• 8

  Adding Form Records arrow_forward_ios ✓ Learn all about adding form records to your Access database, as well as opening and navigating existing forms.
• 9

  Editing Form Records arrow_forward_ios ✓ Learn all about editing form records in your Access database.
• 10

  Deleting Form Records arrow_forward_ios ✓ Learn how to delete form records from your Access database.

Finding Records and Creating Reports

• 11

  Sorting Records arrow_forward_ios ✓ Learn how to review table records and form records concepts, perform a simple sort, and save a sort in Access.
• 12

  Sorting Multiple Records arrow_forward_ios ✓ Learn how to perform a multi-field sort, as well as remove a sort, in your Access database.
• 13

  Finding Records arrow_forward_ios ✓ Learn how to perform a simple find and use a wild card in your Access database search.
• 14

  Filtering Records arrow_forward_ios ✓ Learn all about performing a filter by selection and by form to find the data you need in Access.
• 15

  Queries arrow_forward_ios ✓ Learn all about defining a query, running an existing query, and creating a simple select query in Access.
• 16

  Creating a Report arrow_forward_ios ✓ Learn how to create reports using the AutoReport and Report Wizard features in Access.
• 17

  Printing a Report arrow_forward_ios ✓ Learn how to open an existing report, as well as preview and print it, from your Access database.