Category

ICT

Course type

Microsoft

Cost per individual

£395 +VAT
Public course

Cost per course

£1,100 +VAT
Client site, max 10 individuals

Duration

2 Days

Full/Part time

Part Time

Provider

ITS SmartStyle Training

Dates and Locations

04/06/2018 Bradford
24/09/2018 Bradford
18/10/2018 Liverpool
06/12/2018 Liverpool
13/12/2018 Bradford

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

Book a course

Fill in your information to book this course. The information you provide on this booking 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.

Booking Form

Please select a date and location from the dropdown to add attendees

There are not enough spaces at this location for this many attendees. Please remove 0 attendees before continuing.

spaces remaining

If you just wish to enquire about this course click here