In this workshop, you will learn to create more advanced queries by building calculations, creating total queries, defining crosstab queries, and creating different action queries.
- Course Outline
Learn to create more advanced queries by building calculations, creating total queries, defining crosstab queries, and creating different action queries.
Do you want to learn more advanced methods for filtering your data? Do you want to learn how total, crosstab, and action queries can help you view, select, and analyze your data at a higher level?
Attend this course if you want to:
Understand advanced queries.
Build calculations in a query.
Use total queries to apply calculations to selected data.
Create a crosstab query to summarize data in a compact format.
Create an action query to change selected data within a table.
Use values in form controls as query criteria.
Work with joins in queries.
- Prerequisites & Certificates
Comfortable creating Access databases and tables. Comfortable working with forms in Access. Comfortable creating simple queries in Access.
Certificate of Completion
- Cancellation Policy
If necessary, you can cancel your registration up until 24 hours prior to the class. The confirmation message and the 7-day-prior reminder message both contain a cancellation link. (If a link doesn't display, the 24-hour cancellation period has already passed.)
If you cancel, we encourage you to follow the instructions on Page 1 to reschedule for a future session of the class. The cancellation confirmation message you receive also contains a link to our "reschedule" page.
- Map & Reviews
Elert & Associates Technology Training
[ View Provider's Profile ]
ReviewsHere are some reviews of the training vendor.
This course has not yet been rated by one of our members.
If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.
This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.
This page has been viewed 909 times.