Call Me Back

Page 1

Looking for more information?

Complete your details below and we'll call you back



Course Type


Price Per Delegate

£495 +VAT
Public Scheduled Course

Price Per Course

£1,395 +VAT
On-Site at Customer Premises, Max 10 Delegates


2 Days

Full/Part Time

Part Time


SmartStyle Training

Book course

This course is intended for 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 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.

Download Outline (PDF)

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

Enquire about a course

Fill in your information to apply for this course. The information you provide on this application form may be passed to funding bodies, in line with the Data Protection Act 1998, and may be shared with other training providers and possible employers for the purpose of administration, statistical and research purposes.