Microsoft Access 2007 Level 2
Action Queries
- Types of Query
- The Crosstab Query
- The Make Table Query
- The Append Query
- The Delete Query
- The Update Query
Reports
- The Report Wizard
- Creating a Report with Calculated Totals
- Using the Chart Wizard
- Altering the Chart
- Using the Label Wizard
- Modifying and Redesigning the Report.
- Publishing Access Data on the Web
Customising Forms
- Manipulating Data in the Form
- Creating a New Form
- Using the Form Wizard
- Creating a Form With a Subform
- Modifying and Re-designing the Form
Database Replication
- What Is Database Replication?
- Creating and Maintaining a Replicated Database
- To Use Briefcase to Create a Replica
- Changes Made to a Replicated Database
- Synchronization
- Resolving Synchronization Conflicts
- Convert a Replica Set to Access 2007
Course Benefits
To build on some existing database design and/or user experience that may have been gained from Access 2007 Level 1 course.
Target Audience
Those who intend to design databases at intermediate level or improve existing Access databases. Also those wanting to convert databases made in other applications and spreadsheet (flat file) databases.
Pre Requisites
This course assumes some experience of database design. However, delegates with some experience in database design will find this course beneficial if they do not know Access.
Location of Course
Camberley
Course Trainer
Sue Parsons
Click here to view trainer's portfolio.
