Getting Started

Access 2003 Overview
Create a database file and learn about some of the basic Access screen elements.

Save Your Database
Access automatically saves your database and all the associated elements when you close the database.

Creating a Table

Create a Table Using the Table Wizard
The Table Wizard assists you in creating a table by providing a sample table templates that you can customize.

Create a Table Using the Design View
The Table Design View allows you to create a table without starting with a table template.

Create a Table by Importing Data from an Excel Spreadsheet
Automatically create a table based on data that has already been entered into an Excel spreadsheet.  As part of the process, the data in the spreadsheet is imported into Access to populate the table.

Establishing Relationships

Create a One-to-Many Relationship
Relate two tables to each other using a one-to-many relationship.  Learn why Referential Integrity is important.

Open a Relationships Window and Adding Tables
The Relationships Window gives you a graphical representation of your database and allows you to build or modify the relationships between the tables in your database.  Includes an explanation of the three types of relationships.

 

Adding Data to a Database

Insert Records Using the Datasheet View
The Datasheet view provides an easy way to enter data into an existing Access Table.

Add Records Using a Lookup List
One of the ways that data can be added to your database is by using a Lookup List.

 

Updating Data in an Existing Database

Change Existing Data
Changing data in an existing record.

Updating Records
Updating a record in a table is as easy as opening the table and then typing in the change.

Update Multiple Records
Update multiple records in an existing table using the "Replace" or "Replace All" commands.  This allows you to update information for records in a table that meet certain conditions.

Delete a Record from a Table
It is easy to delete a record from a table in your database.

 

Modifying the Database

Add a Row to an Existing Table
Update a table by adding a new row of information to the table.

Add a Field to an Existing Table
Add a field to an existing table using the Design View.

View and Update a Table Using an AutoForm
AutoForms provide a way that you can view the data in an existing table or can adding additional rows to the table.

 Using the Lookup Wizard to Access and then Modify a the Table Properties
If you need to modify the properties of an existing table in your database, the Lookup Wizard provides a great way to do that.

Add an Input Mask to an Existing Table
An input mask is the format for a particular field.  It consists of literal display characters such as hyphens, periods, and parentheses.  

 

Validation Rules

Setting Validation Rules
Set a validation rule and establish the text properties for the rule.  Validation rules on a field ensure that only valid data gets entered into the field.

Validation Rule Testing
Setting validation rules for fields in your database ensures that only valid data can be entered into each field.  Validation rules can be tested by adding records to a table.

 

Navigating the Database and Finding Specific Records

Search a Table to Find a Specific Record
Open a table and then run a search on any field in the table to find the record(s) that match what you are searching for.

Using the Lookup Field Wizard
The Lookup Wizard provides an easy way to lookup specific values in a field in a table.

Navigating Among Table Records Using the Data Sheet View
Use the record selector and tab keys to move around in a table in the datasheet view.

 

Working with Queries

Create a Select Query
Use the Table Design View to create a query to select data from a single table. 

View the Results of a Query
Queries can be developed to display information from the database.  Learn how to run a query.

Add Fields to a Query Design Grid
Queries are used to view, change, or analyze data.  They can be used as the basis for reports.

Create a Query Based Upon Multiple Tables
Select data from several tables by creating a query in the Design View.

 

Printing from Access

Printing a Table
There are a couple of ways to print existing tables - you can click on the Print button on the tool bar or access the printer via the File menu.   Learn how to use the "Print Preview" option.

Printing the Results of a Query
After a query is run, it is easy to print the results of the query.