Building Access  «Prev  Next»
Lesson 1

Introduction to Microsoft Access Databases and Building an Access Database

Microsoft Access 2007 I: Building a Database

This course is the first of a two-course series that introduces you to Access's basic features. The two courses together give a hands-on overview of Access 2000, Microsoft’s popular database program.
This course is designed to provide an understanding of how to begin creating an Access database. You will learn about organizing data into tables and relating those tables so that the data in your database can be used for analysis.
This course assumes no first-hand knowledge of Access, so if you are new to the application you will be able to tackle the modules without frustration. The next lesson covers the prerequisites for this course.

Course objectives

After completing the course, you will be able to use Access to:
  1. View and use the database windows
  2. Organize related data into multiple tables
  3. Create a blank database
  4. Create a table
  5. Enter and modify data
  6. Import data from Microsoft Excel®
  7. Import an Access table from another database
  8. Edit field properties
  9. Open and close Access database objects
  10. Get online help in Access
  11. Define relationships between tables
In the next lesson, we will examine the course prerequisites.

Microsoft Access is a unique platform that enables rapid development of database applications. It has been a long-time favorite of both developers and end users for creating single-user and small-scale office automation solutions. Recent improvements have made it a viable choice for enterprise-class applications as well. In this course, I will show you how to take advantage of all the great features that Access 2010 has to offer. I think you will find it surprisingly easy to build full-featured applications.