Access Intermediate

Read below to see a rough guide to what is covered in the course or print a more detailed guide from the links below for the different Access versions.

Print Access Intermediate Course Content 2007
Print Access Intermediate Course Content 2010

Basics

Understanding database objects
Open Access; Create a new database
Open an existing database; Task Pane
The database window explained
Close a database
Toolbars display and hide toolbars and Task Pane
Tables

Create a new database and table structure
Setting a primary key’ Set the field properties
Save a table design
Lookup field
Open an existing table
Change between views
Enter data into a table
Navigation tips
Create an indexed field
Validation rules and messages
Add or delete a field in design view
Delete or rename a table; Preview and print a table
Print specific number of pages
Print selection of records
Create/delete a relationship
Set and delete referential Integrity
Editing Sorting And Filtering

Adjust column widths; Move columns
Search for data in a table; Replace data in a table
Use wild cards in a search or replace
Navigate
Undo an action
Insert/delete records
Enter the same value in a field from previous record
Sorting data
Filtering records by selection; Filter by form’ Filter by excluding selection
Queries

Create a single table query
Add fields to the query design grid
Sort a query
Show/hide fields
View (run) and save a query
Search expressions
Hash symbols and quotation marks
Use 'And' or ‘Or’ in the criteria
Create and run a parameter query
Edit a query design view; Delete a query
Rearrange fields in design view
Create a query using related tables
Print preview/print selected records
Forms

Create a data entry form using the wizard
Enlarge a section in a form design
Rearrange fields and labels in a form
Move and widen fields and labels in a form design
Headers and footers using toolbox and text frames
Format font and edit text
Design a form
Navigating through records
Finding a record
Print Preview; Print all or individual records
Delete a form
Reports

Create a report using the wizard
Enlarge a section in a report design
Rearrange fields and labels in a report design
Move and widen fields and labels in a report design
Align text boxes
Headers and footers using toolbox and text frames
Format font in headers; footers or field labels
Edit text in headers; footers or field labels
Set grouping; Set sorting
Adding calculations
Print and print preview
Deleting a report