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.
Microsoft Access
Instructor: Tom Fragale
Product ID: 501758
Objectives of the Presentation
  • 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
Why Should you Attend
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
Topic Background
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.
$300
Recorded Session for one participant
Get life time access with download option!
Book this course
Pay Now
  $450.00 Training CD
Free shipment within 4 Working Days of placing the order. Get life time access for unlimited participants.
  $550.00 Training USB Flash Drive
Free shipment within 4 Working Days of placing the order. Get life time access for unlimited participants.
For multiple location please contact our customer care team +1-510-857-5896.
How it works
Live Session - How it works
  • Login to onlinecompliancepanel with your registered username and password https://www.onlinecompliancepanel.com/login
  • The webinar joining link, username and password for joining the webinar will be updated on your OCP Account 24 hours prior to the webinar
  • Presentation handouts in Downloadable PDF format will be updated on your OCP Account 24 hours prior to the live session
  • Login to the audio conference on the scheduled date and time
  • Get answers to your queries through interactive Q&A sessions via chat at the end of the session
  • Download the Certificate of Attendance and Purchase Invoice from your OCP Account 24 hours after the completion of the session
  • Please let us know your thoughts and views at the end of the webinar, your valuable feedback will help us improve
Recorded Session - How it works
  • Login to onlinecompliancepanel with your registered username and password https://www.onlinecompliancepanel.com/login
  • Upon purchase of the recorded session a link will be updated on your OCP Account within 24 hours
  • Please click on the link to access the Recorded Session
  • Presentation handouts in downloadable PDF format will be updated on your OCP Account within 24 hours of the purchase of the product
  • Download the Certificate of Attendance and Purchase Invoice from your OCP Account after 48 hours of the product Purchase
  • Please share your valuable Feedback at the end of the session
Instructor Profile:
Tom Fragale is a computer professional with over 30 years experience. He has trained over 30,000 business people with 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 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. His passion is training people and helping them get most out of their computers. He has written and published a book on Microsoft Access. He graduated in 1988 from LaSalle University in Philadelphia, PA with a BA in Computer Science.
View More