WWP key in developing people
About WWP
Professional Development
Project Management
Apprenticeships
Customer Portal
Duration: 2 day(s)
Course Code: AC10AD
Add to Favourites
Dates
London Centre 2nd Aug 2012 book
London Centre 4th Oct 2012 book
London Centre 13th Dec 2012 book
Dedicated Course Request
Price:
£480.00+VAT
print this page
email this page

Microsoft Access 2010 Advanced

Aims

This course is aimed at people who want to learn how to customise a Microsoft Access database, ensure it is of robust design, or to widen the applicability of their databases.

Prerequisites

Students who wish to attend this course need to be familiar with the design of basic Tables, Queries, Forms & Reports, and have an understanding of relational databases.

Objectives

On completion of this course delegates will be able to:

  • Design and create well structured databases
  • Enhance existing database performance
  • Perform advanced queries
  • Manipulate properties within forms and reports to control formatting, content
  • Use table relationships
  • Create graphical elements in forms
  • Create sub forms and sub reports
  • Automate a complete database using macros, switchboards

Course Content

Table Design Factors and Tools
  • Concepts of Normalisation
  • Using the Table Analyser
  • The Performance Analyser
  • Adding Security Encryption
  • Compacting a Database
  • Using Name AutoCorrect
  • Backing Up a Database

Transferring Data
  • Importing & Exporting Access Objects
  • Linking Table Data
  • Using the Linked Table Manager

Advanced Queries
  • Joining Tables in a Query
  • Join Types
  • Crosstab Queries
  • Finding Duplicates
  • Unmatched Record Queries

Creating Relationships
  • Creating Relationships between Tables
  • Setting Referential Integrity
  • Cascade Options
  • Viewing Subdatasheets
  • Deleting a Join Line

Using Advanced Form Design
  • Using Forms in Design View
  • Moving, Aligning & Spacing Controls
  • Adding Images & Graphical Elements
  • Setting the Tab Order Manually & Automatically
  • Adding a Form Header & Footer
  • Creating PivotTable and Pivot Charts
  • Control Wizards
  • Adding a Command Button to a Form
  • Creating a Combo Box, List Box & an Option Group
  • Adding an ActiveX Control to a form

 

 Using Sub-Forms
  • Creating & Using Sub-Forms

Advanced Report Design
  • Adding Report Sections in Design View
  • Creating a Calculated Control
  • Grouping Data in a report
  • Creating Group Headers & Footers
  • Creating a Running Summary
  • Inserting a Date/Time Control & Page Breaks
  • Changing the Report Margins
  • Using the Label Wizard
  • Creating a Report without using the Wizard

Using Charts
  • Creating a Chart in a Form
  • Modifying and Formatting Charts

Creating Macros
  • Creating Macros in the Design Window
  • Stepping a Macro
  • Macro Actions & Arguments
  • Assigning a Macro to a Command Button

Using Macros
  • Creating Conditional & Group Macros

Event Properties
  • Using Event Properties
  • Validating Data with Macros

Using Switchboards
  • Creating & Using a Switchboard
  • Using Navigation Control forms

Customising the Toolbar
  • Creating Custom Toolbars, Menus & Shortcut Menu

Appendices: Time Permitting
  • Create a Hyperlink Field
  • Saving Access Objects as HTML
  • Advanced Security

Click to expand...

Perfect Partners

Other courses which naturally complement this course include:

 

Next Learning Step

The next course in this series is:

  • Please contact WWP Training Ltd

Relevant accreditations include:

  • Microsoft® Certified Application Specialist:
    Using Microsoft® Office Access 2010