Access 2007

For the lessons on this page, you will be working through information on creating or revising databases. For most 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.
Miscellaneous		Input Information- Format Datasheets
What is Access?		Input Information Into the New Table
Open Access and Create the Database		Enter Records in Datasheet View
Database Objects		Enter Records Using a Form
Office Button		Deleting Records in Datasheet View
Quick Access Toolbar		Format Datasheets
Access Window		Preview-Print the Datasheet
Access Object Views		Print Preview Contextual Tab
Access Ribbon-Create
Access Ribbon-External Data		Import, Export, Publish Information
Access Ribbon-Home		Import Information from an Access Database
		Import Information from a Delimited Text File
Create Tables		Import Information from Excel
Ways to Create a Table		Import Data From Excel Into an Existing Table
Create and Format a Table in Design View		Export Access Object to Word
Create a Table Using Datasheet View		Publish Access Report to RTF File
Create a Table Using Table Templates
Table Tools Datasheet Tab		Queries
Types of Data Fields		Types of Queries
Change the Table Design		Create a Select Query in Design View
Create an Input Mask		Query Tools Design Tab
Specify Specific Data Using Lookup Wizard		Create Simple Query Using a Wizard
Create Validation Rules		Modify a Query
Assign Captions to Fields		Create Multiple-Table Query
		Create Multiple-Table Query with Sort Precedent
Table Relationships		Add Calculated Fields to Select Queries
Establish/Build Table Relationships		Create Parameter Query
Define One-to-Many Table Relationships		Create Query with Totals Option
Establish Referential Integrity		Create Query with Totals and Build Options
Delete Table Relationships		Create Calculated Field-Input Expressions Manually
Define Many-to-Many Table Relationships
Work with Join Types		Forms
		Explanation of Forms
Sorting/Filtering Records		Create Simple Forms
Sorting Records		Create a Quick Form
Filtering Records		Create Split Form
		Create Forms in Layout View
Reports		Form Layout Tools-Arrange Tab
Explanation of Reports		Form Layout Tools-Format Tab
Sections of a Report		Create Forms Using Form Wizard
Create Simple-Instant Reports		Create Forms Using Design View
Create Report in Layout View		Modify Forms in Design View
Report Layout Tools -Arrange Tab		Navigation Buttons in Form View
Report Layout Tools-Format Tab		Change Tab Order in Forms
Report Layout Tools -Page Setup Tab		Inserting Graphics into Forms
Create Report Using the Report Wizard
Change Report Design		Form Controls
Create Custom Reports in Design View		Working with Form Controls
Add Domain Aggregate Function		Control Buttons
Change the Caption Property		Create Bound Text Box Controls
Additional Formatting Features		Add Command Buttons
Create Mailing Labels Report		Create Label Controls
Change Page Layout		Create List Box
Print a Report		Create Lookup List
		Option Groups
Report Controls
Working with Report Controls		Subforms
Control Buttons		Explanation of Subforms
Creating a Bound Text Box Control		Types of Subforms-Navigation Keys
		Create Subforms Using Design View
Subreports		Create Subforms Using Forms Wizard
Add a Subreport to Report's Detail Section
Modify the Subreport
Use Calculations in Subreport
Apply Conditional Formatting