Course Outline

Queries for Government

  • Types of queries
  • Query Wizard
  • Query Design View
  • Query Properties
  • Grouping in Queries
  • Create a simple select query
  • Crosstab queries
  • Query to search for duplicates
  • Query to find non-matching data
  • Parameter queries
  • Action queries (creating a table, delete, append, update)
  • Create a table using a query
  • Archive data using an append query
  • Troubleshoot queries

Expressions in Queries for Government

  • Examples of using expressions
  • Calculations in queries
  • Functions

SQL in Access for Government

  • Download data
  • Restrict results
  • Sort data
  • SQL functions
  • Aggregate data using grouping
  • Retrieve data from multiple tables
  • Subqueries
  • Collective operators

Requirements

  • Basic knowledge of the Windows operating system
  • Familiarity with database concepts is beneficial but not required

Audience

  • Business analysts for government
  • Data entry specialists
  • IT professionals managing databases
  • Anyone looking to extract and manipulate data using Microsoft Access
 14 Hours

Number of participants


Price per participant

Testimonials (5)

Upcoming Courses

Related Categories