Microsoft Access 2003

For the lessons on this page, you will be working through information on creating or revising databases. For some of the lessons you will be required to download databases from this Web page. These files can be located by clicking on this link. The files are in a compressed (zipped) folder. The folder contains all the files that are needed to complete all the exercises. In order to use the files you will have to download them to a folder on your computer. To download the files, click on the link above and then choose Save. While you are in the Save As dialog box, determine the location where the files are to be stored and then click Save. After the files are downloaded, they will have to be extracted before they can be used. For information on how to do this, click here. Scroll down the page until you locate the information on Extracting Files.
Create a Database		Input Information- Format Datasheets
What is Access?		Input Information Into the New Table
Open Access and Create the Database		Enter Records Using a Form
Database Objects		Adding and Deleting Records in Datasheet View
		Format Datasheets
Create Tables		Preview-Print the Datasheet
Ways to Create a Table
Create a Table in Design View		Import-Export Information
Create a Table Using a Wizard		Import Information from Excel
Types of Data Fields		Import Information from a Delimited Text File
Change the Table Design		Import Information from an Access Database
Create an Input Mask		Import Data into New Table
Create Validation Rules		Import Data into Existing Table
Assign Captions to Fields		Export Information to Other Applications
		Other Ways to Share Access Data
Table Relationships
Establish/Build Table Relationships		Queries
Define One-to-Many Table Relationships		Query Description/Types of Queries
Establish Referential Integrity		Query Design View Toolbar
Delete Table Relationships		Create a Select Query in Design View
Define Many-to-Many Table Relationships		Create Multiple-Table Query
Work with Join Types		Create Multiple-Table Query with Sort Precedent
		Add Calculated Fields to Select Queries
Sorting/Filtering Records
Sorting Records		Form Controls
Filtering Records		Working with Form Controls
		Use Control Wizards
Forms		Create Bound Text Box Controls
Explanation of Forms		Add Command Buttons
Create Instant Forms		Create Label Controls
Create Forms Using Auto Form Wizard		Create List Box
Create Forms Using a Form Wizard		Create Lookup List
Create Forms Using Design View		Option Groups
Modify Forms in Design View
Part of Design View Window		Subforms
Form View Toolbar		Explanation of Subforms
Navigation Buttons in Form View		Types of Subforms
Change Tab Order in Forms		Create Subforms Using Design View
Inserting Graphics into Forms		Create Subforms Using Forms Wizard

Reports		Report Controls
Explanation of Reports		Working with Controls
Sections of a Report		Textbox Control Buttons
Create Instant Reports		Explanation of Report Controls
Create Auto Reports		Creating a Bound Text Box Control
Use the Report Wizard		Selecting Controls
Change Report Design		Resize-Align Labels
Create Custom Reports in Design View		Resize-Move Controls
Add Domain Aggregate Function
Change the Caption Property		Subreports
Add-Remove Report Header-Footer Sections		Add a Subreport to Report's Detail Section
Additional Formatting Features		Modify the Subreport
Create Mailing Labels Report		Use Calculations in Subreport
Change Page Layout		Apply Conditional Formatting
Publish Access Report in Word
Print a Report