Microsoft Access 2007 Intermediate Training Materials
Intermediate Level Training Course
Training Course Outline
WHAT’S NEW in ACCESS 2007
- New features in Access 2007
- Database Templates
- Local templates
- Downloading templates
- Enhanced Datasheet View
- New Layout View
- Improved Interface
TABLE DESIGN IN ACCESS 2007
- Modifying Fields
- Lookup Fields
- Validation Rules
- Input Masks
- Default Values
- Mandatory Fields
ACCESS 2007 & RELATIONSHIPS
- Basics of Relationships
- What are relationships?
- Understanding the basis for creating relationships
- Types of joins in a relationship
- Creating and modifying one-to-one, or one-to-many relationships
- Applying inner, outer, and self joins
- Applying and using referential integrity
- Applying automatic deletion of related records
ACCESS 2007 QUERY TYPES
- Creating and using a query to update data in a table
- Creating and using a query to delete data in a table
- Creating and using a query to save the selected information as a table
- Appending records to a table using query
ACCESS 2007 QUERY FORMULAS
- Grouping information in a query
- Using functions in a query
- Using Aggregate Functions
- COUNT function
- SUM function
- AVG function
- MIN function
- MAX function
- Using a crosstab query
ACCESS 2007 FORMS
- What are bound and unbound controls?
- Creating bound and unbound controls.
- Creating and editing a combo box, list box, check box and option groups.
- Creating arithmetic and logical expression controls on a form.
- Setting sequential order of controls on a form.
- Inserting data fields to appear within form header or footers
- What are sub forms?
- Creating a sub form and linking to parent.
- Modifying the sub form to change records.
ACCESS 2007 REPORTS
- Creating arithmetic and logical calculation controls within a report.
- Calculating percentage calculation control within a report.
- Using formulas and expressions within a report.
- Creating running summaries within a report.
- Inserting a data field to appear within report header or footers
- Forcing page breaks for groups on reports.
ACCESS 2007 MACROS
- Recording & assigning macros
- Running macros.
- Assigning macros to a form, report or control.
IMPORTING, EXPORTING AND LINKING DATA WITH ACCESS 2007
- Importing files into a database.
- Exporting data as different formats.
- Linking external data to a database.