Category
ICT
Course Type
Microsoft
Price Per Course
£595 for any two half day courses +VAT
On-Site at Customer Premises, Max 10 Delegates
Duration
Half day
Full/Part Time
Part Time
Provider
Dates and Locations
Contact us for the latest course dates.
Book courseThis course is intended for existing Access users who need to interrogate and interpret data in Flat or Related tables within an existing database using a variety of criteria.
Objectives:
By the end of the course users will be able to create, run and save queries; extract accurate data that matches criteria based on text, numbers, dates and expressions. Users will also be able to summarise data using totals and simple calculations.
Prerequisites:
Delegates attending this course should be able to open and close a database and understand the purpose of Tables, Queries, Forms and Reports.
- Navigating Table Data
- Sorting & Filtering Data in a Table
- Showing & Hiding Table Columns
- Adding, Moving & Removing Fields
- Showing & Hiding Query Fields
- Sorting Queries by One or More Fields
- Entering a Simple Criteria Value
- Using Multiple Criteria in a Query
- Using AND & OR Criteria
- Entering Wild Card Criteria
- Creating a Parameter Query
- Querying Data from Related Tables
- Summarising Results in a Query
- Creating a Simple Calculated Field
- Creating a Select Query with the Wizard
- Find Unmatched Data Query Wizard
- Find Duplicate Query Wizard
- Crosstab Query Wizard
Enquire about a course
Fill in your information to apply for this course. The information you provide on this application 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.
