Microsoft Access – Advanced (1 day)

£195.00 exc. VAT

Course Enquiry
SKU: MS-AccessAdv Categories: , Tags: , ,

Description

With our Access (Level 2) course learn how to use forms and reports to control and organize the display of your data.
Our BRD expert trainer will explain how to create real-world queries to filter and sort data and perform calculations, as well as refine query results with built-in functions, all while offering techniques that help you master the application.
This course can be successfully completed by anyone who has prior experience of Access or who has completed BRD Access (Level 1).

Outline

1. Access Queries
2. Using Select Queries
3. Using Parameter Queries
4. The Built-In Functions
5. Accumulating Records with a Totals Query
6. Using Dates with Queries
7. Access Flow Functions
8. Other Query Types
9. Using Structured Query Language
10. Helful Query Tricks
11.Summary

New Skills

You will have the ability to*:
-Define your query criteria
-Use comparison and wildcards in criteria
-Work with media
-Create parameter queries
-Use the built-in functions in Access
-Aggregate records with totals
-Work with dates
-Create alternative queries: unmatched, crosstab, and more
-Write queries with SQL
*These are some examples of skills demonstrated. For a full list, take a look at our PDF (Outline Section).

You may also like…