Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
Testimonials (5)
scope of material
Marcin - Instytut Energetyki- Panstwowy Instytut Badawczy
Course - Word dla zaawansowanych
scope of material
Marcin - Instytut Energetyki- Panstwowy Instytut Badawczy
Course - MS Word - poziom podstawowy
Adam was very knowledgeable and had a great layout.
Corey Reis - Lockheed Martin
Course - Advanced Slide Design in PowerPoint
some small tricks regarding image formating and templates - very useful :)
Natalia Wawrzyniak - Akademia Morska w Szczecinie
Course - Advanced MS PowerPoint
Working on and using our own data/spreadsheets, where we could see how it would benefit us most.