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
- The types of queries
- Query Wizard
- Query Design View
- query Properties
- Grouping in Queries
- Create a simple select query
- Crosstab queries
- Query the search duplicates
- Not matching the search query data
- Parameter queries
- Queries (forming a table, delete, append, updating)
- Create a table with a query
- Archiving data using an append query
- Troubleshoot queries
Expressions in Queries
- Examples of the use of expressions
- Calculations in queries
- Functions
SQL in Access
- Download the data
- Restrict results
- Sorting Data
- SQL Functions
- Aggregating data using the grouping
- Retrieving data from multiple tables
- subqueries
- Operators collective
Requirements
- Basic knowledge of Windows operating system
- Familiarity with database concepts is beneficial but not required
Audience
- Business analysts
- Data entry specialists
- IT professionals managing databases
- Anyone looking to extract and manipulate data using Microsoft Access
14 Hours
Testimonials (5)
Adam was very knowledgeable and had a great layout.
Corey Reis - Lockheed Martin
Course - Advanced Slide Design in PowerPoint
Practical Exercises
Magdalena Wilczynska - Uniwersytet Artystyczny w Poznaniu
Course - Delivering Impressive Presentation Decks - Social Skills Workshop
Machine Translated
Troubleshooting on Specific Tasks
Przemyslaw Jaworski - FLSmidth MAAG Gear Sp. z o.o.
Course - Microsoft Office Excel - poziom zaawansowany + elementy VBA
Machine Translated
You learned a lot
Barbara Kozlowska - NBP
Course - MS PowerPoint - poziom zaawansowany
Machine Translated
Course Delivery Method
Bogdan Kwiatkowski - NBP
Course - Word dla zaawansowanych
Machine Translated