This guide shows you what you might use an Access database for and how to setup and use one. This is useful for businesses or personal use.

In This Guide:

01 - Database Basics

Introduction to databases how they work.

02 - Introduction to MS Access

Having learned how useful databases could be, Michael was eager to know more about the system that would let him manage his employee’s data. George then introduces him to Microsoft Access (MS Access).

03 - Exploring MS Access

Here we briefly cover how to open MS Access and show you the main screen.

04 - Working with Databases

Michael is now familiar with the step-by-step procedure involved in designing databases. He is ready to create a database that would help him manage employee data.

05 - Tables

This chapter covers the large structures that make up a database, tables.

06 - Fields

In this chapter we cover adding a field to a table in design view, insert/delete fields, enter a caption and default value for field and setting field properties.

07 - Viewing Tables

This chapter explains how to view tables and how to enter and edit data in it.

08 - Data Validation

Michael knows that data validation is a must to have a perfect working environment. The data being entered in the tables has to be correct and valid. Data validation is the process to ensure this.

09 - Forms and Queries

Part of retrieving information from your database is setting up forms and queries.

10 - Reports and Data Access Pages

Reports and data access pages are what you use to retrieve and display information in your database. In this chapter we show you how to set them up.

11 - Miscellaneous

In this chapter we cover the rest of the smaller miscellaneous features.