Home / MS-Access / Getting Started

MS-Access Basics

When working with Access for the first time, it is tempting to start filling tables right away and querying data to get fast results, but it's important to understand the basics of the relational database concept before pounding away at data. A good understanding of how a relational database works will help you take full advantage of Access as a powerful data analysis solution. This tutorial covers the fundamentals of Access and methods to bring data into the program.

In this tutorial:

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