giving people the skills to succeed  
search our website
Courses > IT Courses > Microsoft Access 2010 Advanced
 
   
 
Microsoft Access 2010 Advanced
 
Target Audience:  

Users who need to develop databases which have complex structures or require an easy to use interface for a team or organisation to use.

 
   
Objectives:  

By the end of the course the user will be able to develop databases which include automated features such as customised menus, macros and command buttons and utilise complex queries, forms and reports using grouping tools and including calculations.

 
   
Prerequisites:  

Users must be able to confidently design and develop multiple table Access databases.  Users will require a good understanding of relationships and the four core elements of Microsoft Access, i.e. tables, queries, forms and reports.

 
   
 
       
     
  Duration: 2 Days
  Cost: £250 + VAT
     
 
  Course Date Location
  12/03/2012 Liverpool
  26/03/2012 Bradford
  14/06/2012 Bradford
  13/09/2012 Bradford
  13/09/2012 Liverpool
  17/12/2012 Bradford
     
 
Normalisation & Relationships
  • Understanding Normalisation
  • Relationship Join Types
 
Advanced Query Features
  • Changing the Join Type in a Query

  • Find Unmatched Queries

  • Find Duplicates Query

  • Crosstab Queries

 
Advanced Report Features
  • Multiple Table Reporting

  • Sorting & Grouping Report Data

  • Performing Calculations on Reports

  • Creating Custom Report Pages

 
Advanced Form Features
  • Bound & Unbound Controls

  • Creating a Calculated Control

  • Toggle Buttons, Options & Check Boxes

  • Option Groups

  • List Boxes and Combo Boxes

  • Page Tabs

 
   
 
Creating & Modifying Charts
  • Forms & Reports using the Chart Wizard

  • Creating a Global Chart

  • Creating a Record Bound Chart

  • Formatting Charts

  • Using PivotChart View

 
Macros & Database Automation
  • Creating a Macro

  • Running a Macro

  • Macro Examples

  • AutoExec Macros

  • Designing & Creating Navigation Forms

  • Designing Application Menus

  • Startup Options & Defaults

 
Multi User Databases
  • Storing Databases on a Network

  • Shared Databases

  • Setting Database Passwords

 
Database Management Tools
  • Backing Up a Database

  • Compacting & Repairing A Database

  • Front End & Back End Databases

  • Database Documenter