Microsoft Certified Trainer with over 20 Years of Training Experience, and over 35 years in IT overall
About this course
CPA Alberta
CPA British Columbia
CPA Manitoba
CPA New Brunswick
CPA Nova Scotia
CPA Ontario
CPA Prince Edward Island
CPA Saskatchewan
CPA Newfoundland & Labrador
CPA Quebec Order
Microsoft Access is the database management system that is included with the Microsoft Office Suite or Office 365. It is a program that helps you manage a large amount of data even better than Microsoft Excel can. Many People don’t know how to use Access, and may even be afraid of it. This webinar will really show you the ins and outs of using Microsoft Access Queries.
Even though Excel gives you some great ways to handle your data, with Access you will be able to handle large amounts of data. If you handle large amounts of data, this webinar will help you tremendously.
Topics:
Basic Queries
Prompting the user for the criteria
Calculated field queries
Totals query
Using Multiple tables in a query
Viewing the SQL code
Query wizards
Subqueries
Append, Make Table, Update, and Delete queries
Showing a certain number of records in a query