Access database basics
Northwinds sample database
A database consists of multiple
tables that are related to each other.
Northwinds consists of eight related tables.
An Access database consists of six types of objects.
Each tab in the database window displays these objects
and enables you to open existing objects or create new ones.
Each table is similar to an Excel list (often called an Excel database).
Queries in Access will build on your experience with using Excel’s
Data menu Filter commands AutoFilter and Advanced Filter subcommands.