Microsoft Access Intermediate

Microsoft Access Intermediate

Cost

£135+VAT

Next Date

Enquire

Duration

One to Two Days

Microsoft Access Intermediate

Course Description

This course improves upon Access database usage and design

Course Content

Relationships

Pre-defined | Referential integrity | Normalisation

Queries

Relational queries | Grouping queries | Text processing functions | Conditional functions (optional)

Forms

Modifying forms | Combo boxes and list boxes | Option groups | Putting totals onto forms | Using tabs on forms | Setting tab order | Adding fields onto forms | Subforms

Reports

Grouping reports | Totals and subtotals | Graphs | Sub reports

Extending form usage

Custom data entry forms | Subforms and graphs in forms | Using unbound forms and controls | Using aggregate functions in forms and reports | Using advanced functions in forms, reports and queries | Using controls and control properties

Action queries

Update queries | Append queries | Delete queries | Make table queries

Imports, exports and attachments

Mail merge to Word

Related courses

Microsoft Access Introduction

Microsoft Access Advanced

Microsoft Excel Advanced

BOOK THIS COURSE

Simply complete the form below and we'll come back to you as soon as possible