|
|
Microsoft Access 2007 Intermediate Level Training Courseware
 Access
2007 | WHAT’S NEW
- New features in Access 2007
- Database Templates
- Local templates
- Downloading templates
- Enhanced Datasheet View
- New Layout View
- Improved Interface
Access 2007 | TABLE DESIGN
- 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.
 Access 2007 | IMPORTING, EXPORTING AND LINKING DATA
- Importing files into a database.
- Exporting data as different formats.
- Linking external data to a database.
|
