TABLE MODIFICATION AND NAVIGATION
Adding Fields – Design View
Data Type – Overview
Data Type – Descriptions

Using the Attachment data type

Adjusting column width
Moving a column to rearrange the column order
Adding records to a table
Navigating through records within a table
Closing a database
Navigation Pane

FIELD PROPERTIES, VALIDATION & INPUT MASKS
Field Properties
Input Mask
Validation Rules
Field Properties – Guides Tables

MANIPULATING RECORDS & TABLES
Closing an Object – Table
Renaming an Object – Table

Editing data within a record
Deleting data within a record
Using the Undo command
Deleting a single record
Deleting multiple records
Save As – Database Object
Deleting a table

PRIMARY KEYS AND INDEXING
Defining a Primary Key
Indexing
Creating a single-field Index
Creating a multiple-field Index
Deleting multi-field indexes

FILTERING & SORTING
Text Filters
Applying a single filter
Clearing a single filter
Creating multiple filters
Clearing multiple filters
Sorting

RELATIONSHIPS
Table relationships
One-to-many relationship
Many-to-many relationship

One-to-one relationships

Creating relationships between tables
Referential integrity
Cascade options
Cascade update related fields
Cascade delete related records
Enabling cascade options
Deleting relationships

ACCESS 2007 FORMS
Forms overview
Creating forms
Modifying forms
Modifying a form title
Modifying a form logo
Modifying a form label
Saving a form
Form View
Adding and formatting attachments
Modifying records
Deleting records
Adding records
Closing forms
Opening forms
Deleting a form

ACCESS 2007 QUERIES
What are queries?
Creating a simple query
Adding criteria to a query
Running a query
Editing criteria in a query
Saving a query
Creating a two table query and sorting the results
Deleting a query

ACCESS 2007 REPORTS
What are reports?
Creating a simple report
Using the Report Wizard
Modifying the layout of a report
Widening a report column
Modifying the report title
Adding logos to a report
Autoformating a report
Modifying field names within a report
Inserting and formatting the date & time
Adding available fields to a report
Resizing reports for printing
Closing a report
Deleting a report

ACCESS 2007 PRINTING ISSUES
Considerations before printing
Print previewing
Which orientation, portrait or landscape?
Adjusting layout in Print Preview
Setting margins
Printing a complete table
Printing selected records
Printing a query or reports
Printing forms

Level 2 Course Outline
WHAT’S NEW
New features in Access 2007
Database templates
Using local templates
Downloading templates
Enhanced Datasheet View
New Layout View
Improved Interface

SECURITY ISSUES & THE TRUST CENTER
Security warnings
Trusted Locations – Trust Centre
Setting the default folder location within Access

TABLES
 

MODIFYING FIELDS
Applying and modifying data types
Modifying column data types
Formatting Text data type
Formatting Memo data type
Examples of formatting a text box or memo
Formatting Hyperlink data type
Formatting Currency data type
Formatting Date/Time data type
Database object naming conventions
Data types
Converting between data types
Changing a field to a different data type

LOOKUP FIELDS
Creating and editing a lookup in a field or column
Creating a lookup from values in a table or query
Creating a lookup from values you type in

VALIDATION RULES
Creating a validation rule within a field

INPUT MASKS
Creating an input mask in a field

DEFAULT VALUES
Applying a default value to a field

MANDATORY FIELDS
Setting a required field

CREATING A TABLE
Creating a new table

RELATIONSHIPS
 

BASICS OF RELATIONSHIPS
Issues relating to creating valid relationships
Identifying a related table
Creating a relationship

Deleting a relationship
Creating a primary key and a composite key

TYPES OF JOINS IN A RELATIONSHIP
One-to-one
One-to-many
Many-to-many

CREATING RELATIONSHIPS
Creating a one-to-one relationship
Modifying one-to-one relationship
Creating a one-to-many relationship
Modifying one-to-many relationship
Creating many-to-many relationships

APPLYING INNER AND OUTER JOINS
Applying an inner join
Applying an outer join

APPLYING AND USING REFERENTIAL INTEGRITY
Setting referential integrity

APPLYING AUTOMATIC DELETION OF RELATED RECORDS
Setting cascading options

QUERIES
 

QUERY TYPES
Enabling the content
Creating and using a query to update data in a table
Populating data in the tables
Creating an Update Query
Creating and using a query to delete data within a table
Creating a Delete Query
Creating and using a query to save the selected information as a table
Creating a Make-Table Query
Appending records to a table using query
Creating an Append Query

GROUPING INFORMATION IN A QUERY
Using Aggregate Functions
Counting column values using the COUNT function
Summing column values using the SUM function
Averaging column values using the AVG function
Finding minimum column values using the MIN function
Finding maximum column values using the MAX function
Using a crosstab query

Creating a crosstab query
Creating a crosstab query using Crosstab Wizard

Using wildcards as parameters

USING ARITHMETIC OR LOGICAL EXPRESSIONS IN A QUERY
Creating an arithmetic calculation within a query
Creating a logical (condition based) expression within a query

REFINING A QUERY
Finding duplicates using the Find Duplicates Query Wizard
Finding unmatched values using the Find Unmatched Query Wizard
Finding the lowest range of values within a query
Finding the highest range of values within a query
Creating a parameter query
Finding Null values
Finding NOT values

FORMS
 

CREATING BOUND AND UNBOUND CONTROLS
Creating an unbound control
Creating a bound control

CREATING A COMBO BOX, LIST BOX, CHECK BOX & OPTION GROUPS
Creating a combo box
Creating a list box
Creating a check box
Creating an option button
Creating an option groupError! Bookmark not defined

CREATING ARITHMETIC / LOGICAL EXPRESSION CONTROLS
Creating an expression control
Creating an arithmetic expression control
Creating a logical expression control

CREATING A FORM USING THE FORM WIZARD
Creating a form with Form Wizard

SETTING SEQUENTIAL ORDER OF CONTROLS ON A FORM
Setting tab index for controls on a form

CREATING FORM HEADERS OR FOOTERS
Creating a form header and footer area
Numbering a form page

CREATING A SUBFORM AND LINKING TO THE MAIN FORM
Using a subform
Adding a subform to a form

MODIFYING THE SUBFORM TO CHANGE RECORDS DISPLAYED
Bringing a subtotal from a subform to a main form

REPORTS
 

CREATING ARITHMETIC / LOGICAL CALCULATION CONTROLS
Placing a control on a report
Creating an arithmetic expression control
Creating a logical expression control

USING FORMULAS AND EXPRESSIONS
Using common functions in a report
Using count and sum calculations within a report
Using sum min, max and average calculations within a report
Concatenating (combining) values within an expression

CREATING RUNNING SUMMARIES
Creating a report with running summaries

PRESENTATION
Creating page headers and footers
Creating report headers and footers
Grouping records on a report

FORCING PAGE BREAKS FOR GROUPS ON REPORTS
Forcing page breaks after each group of records

MACROS
Creating a new macro
Running a macro
Using the single step method to run a macro
Attaching a macro to a form control
Attaching a macro to a report control

IMPORTING, EXPORTING AND LINKING DATA
 

IMPORTING DATA
Importing from a text file

Importing from an Excel spreadsheet

Importing from a dBase file
Importing from a Paradox file

EXPORTING DATAERROR! BOOKMARK NOT DEFINED
Exporting data to a text file
Exporting data as an Excel spreadsheet file
Exporting data to a dBase file
Exporting data to a Paradox file
Linking external data to a database
Linking to an external text file Error! Bookmark not defined.
Linking to an Excel worksheet

Level 3 Course Outline
 

FORMS
 

FORM CUSTOMISATION
Linking a form to a table
Placing controls on the form
Aligning controls on a form
Sizing to fit controls on a form
Special effects
Setting tab order
Placing a bound control on the form
Placing a check box on the form
Placing a command button on the form
Placing a group box on the form
Placing a combo box on the form
Placing a list box on the form

TYPES OF FORMS
Popup forms
Modal forms
Split forms

LIMITING USER ACCESS
Limiting users from adding new records
Limiting users from deleting existing records
Limiting users from editing a records
EXPORTING FORM TO XML
Exporting to XML

REPORTS
Creating a report
Creating an AutoFormat template
Applying an AutoFormat to a report using the Report Wizard
Applying an AutoFormat to an existing report
Conditional formatting
Subreports
Formatting reports

ACCESS SWITCHBOARDS
What is a switchboard?
Creating a Switchboard
Adding a switchboard
Deleting a switchboard
Adding items to a Switchboard
Editing a Switchboard
Deleting items within a Switchboard
Editing items within a Switchboard
Making a Switchboard the default Switchboard
Displaying Switchboards automatically when opening a database

CUSTOMISING ACCESS
Access customization options
Current Database options
Datasheet options
Object Designers options
Proofing options
Customize options
Add-ins options