Microsoft Access 2010: Advanced

Course Overview

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.

Not sure whether this is the right Microsoft training course for you? Use our quick search bar to find the right Microsoft training course for you.

Related Courses

• Microsoft Access 2010: Introduction for Beginners
• Microsoft Access 2010: Advanced Level 3
• Microsoft Access 2010: Intermediate
• Microsoft Access 2010: Fundamentals
• Microsoft Access 2007/2010: Advanced
• Microsoft Access 2010: Specialised
• Microsoft Access 2010: Intermediate
• Microsoft Access 2007/2010: Advanced Skills
• Microsoft Access 2007/2010: Introduction for Beginners
• Microsoft Access 2007 2010: VBA Programming

Skills Gained

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

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.

Course Outline

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