Ball State University

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.