Getting the most from your data with Access Queries
Duration: 90 Minutes
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.
Objectives of the Presentation
Why Should you Attend
- 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
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.
Who will Benefit
- 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
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.