MS-Access / Getting Started

Access Tables

Upon opening Access, you notice that the Database window, contains a task pane on the left. Using the topmost drop-down box, change the navigation category to All Access Objects. You will get six sections. Each section represents one of the six database objects: Tables, Queries, Forms, Reports, Macros, and Modules. The Tables selection is appropriately at the top of the list, because it is the precise location where your data will be stored. All other database objects will refer to the tables in your database for data, whether asking questions of the data or creating reports based on the data. This section covers the basics to get you working with Access tables.

[Contents] [Next]

In this tutorial:

  1. MS-Access Basics
  2. Access Tables
  3. Table Basics
  4. Exploring Data Types
  5. Creating a Table with Design View
  6. Access Field Properties and Primary Key
  7. Getting Data into Access
  8. Understanding the Relational Database Concept
  9. Splitting Data into Separate Tables
  10. Relationship Types
  11. Query Basics
  12. Creating Your First Select Query