Date/Time
Date(s) - 16/05/2019
1:30 pm - 4:30 pm
Location
Glasgow Training Centre
Categories
Microsoft Access Query Workshop
Audience: This short half day session is ideal for those who wish to interrogate existing Access databases, create queries and manipulate database data through action queries.
Course Duration: 1/2 day (0.5)
Select Queries
- Select queries explained
- Creating select queries
- Working with query views
- Adding and deleting fields
- Sorting records in the Design View
- Understanding Join Types between data sets
- Using query criteria
- Adding calculated fields
Designing Advanced Queries
- Setting join types between tables and queries
- Setting top values in a query
- Creating Calculated fields
- Creating Summary queries
- Grouping queries
- Creating Parameter queries
Action Queries
- Update Query
- Make Table Query
- Delete Query
- Append Query
- Union Query
Bookings
Bookings are now closed for this event.