Microsoft Access Queries 1/2 day Workshop

11/07/2019

Date/Time
Date(s) - 11/07/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

£150.00