Access XP

Microsoft Access Overview

• 1

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

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

  Identifying the Basic Parts of the Access Window arrow_forward_ios ✓ Use this lesson to identify the basic parts of the Access window.
• 4

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

  Getting to Know the Contact Management Database arrow_forward_ios ✓ Understand the tables, forms, and reports in the Contact Management database.
• 6

  Using a Wizard to Create the Contact Management Database arrow_forward_ios ✓ Learn how to launch the Database Wizard and create a database using this Access tool.

Entering, Viewing and Working with Data

• 7

  Opening a Table and Learning to Navigate Records arrow_forward_ios ✓ Learn how to open a table, navigate table records and fields, and use the Record Selector field.
• 8

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

  Editing and Deleting Table Records arrow_forward_ios ✓ Learn how to edit, move, and delete table records in an Access database.
• 10

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

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

Turning Data into Meaningful Information

• 12

  Sorting Records arrow_forward_ios ✓ Learn how to perform basic and multi-field sorts, as well as how to remove and save sorts.
• 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

  Running Database Queries arrow_forward_ios ✓ Learn how to run an existing query and create single-table and multi-table queries.
• 16

  Running and Printing Database Reports arrow_forward_ios ✓ Learn how to create and print reports using the AutoReport and Report Wizard features, as well as how to run Contact Management database reports.

Extras

• 17

  Seven Steps to Good Database Design (Part 1) arrow_forward_ios ✓ Learn the seven steps that any developer, new or experienced, can follow to develop a database.
• 18

  Seven Steps to Good Database Design (Part 2) arrow_forward_ios ✓ Learn the seven steps that any developer, new or experienced, can follow to develop a database.