In this course you will learn how to create and maintain queries in Microsoft Access
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
Microsoft Certified Trainer with over 25 Years of Training Experience, and over 40 years in IT overall
Tom Fragale is a computer professional with over 40 years of professional experience. He is a Microsoft Certified Trainer, a Microsoft Certified Office Master, and a Microsoft Certified Expert in Word and Excel, and a Microsoft Certified Specialist in Access, Outlook, and PowerPoint. He has trained over 50,000 business people in online webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including insurance, manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as a consultant on many successful projects. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Copilot, ChatGPT, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is helping people get the most out of their computers, and he is a published author having written a book on Microsoft Access, and another on Excel Pivot Tables. He graduated in 1988 from LaSalle University in Philadelphia, PA with a B.A. in Computer Science.
This portal is provided as a training and development resource for City of Markham employees. Every course is delivered by a qualified subject matter expert or learning organization, is quantifiable in hours, and is verifiable — you receive a documented certificate of completion for every course you finish, stored on LearnFormula indefinitely.
If you hold a professional designation (for example in engineering, accounting, human resources, or law), courses may be counted as professionally relevant, verifiable learning activities toward your continuing professional development. Individual practitioners are responsible for confirming that an activity meets the requirements of their professional body. For questions about the City of Markham's training and development policies, please speak with your people leader or Human Resources.
