Microsoft Access Queries for Data Analysis

Click to Enquire

Categories: Microsoft Access

£390 per delegate. This may be less for special offers on specific course dates and in-company training courses

Duration: 1 day

Trainer: WC315P

Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...

Course Overview
Course Dates

Who Should Attend:

People who need to do creative and in-depth queries of databases.

Course Outline:

Tables:

-Referential Integrity
-Table Relationships

Queries:

-Queries
-Wildcards
-Totals Queries
-Expression queries
-Action queries:
-Make Table,
-Inserting records
-Append, Update and Delete Queries

Data:

-Importing Data
-Exporting Data
-Linking Data

Creating Forms:

-Creating forms, Form wizards
-Creating a Navigation Form

Creating reports, On-screen and Paper / Pdf based. On screen queries via preprepared forms