giving people the skills to succeed  
search our website
Courses > IT Courses > Microsoft Access 2007 Advanced
 
   
 
Microsoft Access 2007 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
  28/02/2012 Liverpool
  26/03/2012 Bradford
  14/06/2012 Bradford
  20/08/2012 Liverpool
  24/09/2012 Bradford
  13/12/2012 Bradford
     
 

Normalisation & Relationships

  • Understanding Normalisation
  • 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 and Grouping Report Data
  • Performing Calculations on Reports
  • Creating Custom Report Pages
 

Advanced Form Features

  • Bound and 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 & Startup Defaults

  • Designing Application Menus

  • Switchboards

 

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