Training at Blue Novation

 

 

Since 1988, Blue Novation has designed and delivered exceptionally high standard training solutions to businesses in both the private and public sector. The quality of training we deliver is of paramount importance to us.

Our approach ensures that delegates enjoy their training whilst gaining the additional skills and knowledge to become more productive in the workplace.

Access Intermediate

This course will help delegates to build on their basic understanding of Microsoft Access, covering the theory and application of creating a database; creating more complex queries; and enhancing data entry and reporting with forms and reports.

Course Topics

Querying Information in a Database

Select, crosstab, parameter queries • specifying criteria • adding calculated fields • calculating totals in queries • make table query • delete/update/append query

Creating Multiple Table Queries

creating relationships • outer & inner joins • query properties

Creating Grouped Reports

sorting and grouping data • creating/modifying a grouped report • group headers & footers • range and interval grouping • printing properties • calculating totals

Working with Sub-Reports

combining two or more reports • linking a main and subreport

Form Design

editing controls •calculated controls • properties of controls • sizing and aligning controls • setting form properties

Customising Forms

adding combo and list boxes • options for displaying yes or no values • creating option groups • adding command buttons

Main and Sub-Forms

creating a menu & sub-form • linking the main & sub-form together

Creating Dialog Box Forms

creating a menu form • using a form as a dialog box

General Topics

compacting & repairing a database • creating an auto-lookup query

 

Follow on Courses

Access Advanced

Course Dates

Course Dates

On Request

Course Duration

1 day

Course Timings

9:30-16:30

Location

Ipswich

Prerequisites

Delegates should have attended the Introductory course or gained similar knowledge in the workplace.

Training Formats

Private course · tailored · 1 to 1 (all instructor led)

Manuals

A comprehensive course manual provides support throughout the course and upon your return to the office.

Not found the course you are looking for?

 

We can create a tailored workshop to suit your
specific business requirements. Get in touch to find out more.

BlueNovation_logo_WA

 

 

Address: Contact us on:
NG7 Columba House, Adastral Park, 0345 11 88 150Call now
Martlesham Heath, Ipswich, IP5 3RE Email us[email protected]