Getting the most from your data with Access Queries

Microsoft Access is a very powerful database management tool, but it is not very intuitive. In this webinar, you will learn how to take your raw data and create meaningful reports that will help you get the most of your data using this software. As a business owner or manager, you have mounds and mounds of raw data transactions, and it is a monumental task to make any sense out of that data. After this webinar, you will be able to take virtually any kind of data and quickly and easily show the exact records that you want using an Access query.

• Importing data from Excel
• Creating a simple query
• Adding criteria to your query to find the exact records you are looking for
• Sorting a query
• Prompting the user for the criteria to make a dynamic query
• Adding your formulas into a query
• Getting subtotals with a totals query
• Getting monthly and annual totals with a Crosstab Query
• Building a report in seconds with the powerful report wizard

A little bit of knowledge of Microsoft Access or Excel would help, but is not necessary. Anybody who has a lot of data, or who may have to use Microsoft Access, will benefit from this webinar.

This webinar will start off with the basics, then, add sorts, filters, subtotals, grand totals, and formulas to create great reports that summarize your data into meaningful information that will allow you to run and manage your business better. You and your staff will be instantly more productive in Microsoft Access. These techniques will work cross-industry, with any type of data. You will find it to be clear and concise and right to the point and you will be able to apply these techniques to your own data immediately after the session.

• Business owners
• CEO's / CFO's / CTO's
• Managers of all levels
• Anybody with large amounts of data
• Anybody who uses Microsoft Access/Excel on a regular basis, and wants to be more efficient and productive

Tom Fragale is a computer professional with over 30 years of professional experience. He has trained over 30,000 business people in on-line 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 manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as a consultant and project manager on many successful projects. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is training people and helping people get the most out of their computers, and he is a published author having written a book on Microsoft Access. He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.