Call us at +1-(510)-868-1040

Login Register


    Getting the most from your data with Access Queries

    Speaker: Tom Fragale
    Date: 2019-11-18
    Time: 12:00 PM PST | 03:00 PM EST

    Duration: 90 Minutes
    Product Code: 601039
    Thanksgiving Sale! Apply promocode THANKS10 and get flat 10% off on all webinars. Hurry! Limited Period Offer!!

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

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.


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.


  • 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 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.

Tom 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.

View all trainings by this speaker
 
Live Webinar

Live + Recorded Session

Get unlimited access to the link for one participant, from the date of webinar completion.

$269

Live + Transcript

Get unlimited access to the link for one participant, from the date of webinar completion.

$249

Live + Training CD

Free shipment within 3 to 5 Days from the date of webinar completion.

$450

On Demand

Transcript

PDF Transcript of the Training which are available once the webinar is completed.(Transcript for single user only)

$179

Downloadable recorded session

Get unlimited access to the link for six months.

$239

Training CD

Free shipment within 72 Hours, from the date of webinar completion

$350

Group Session

Group Session unlimited participants + Recorded

Live session for unlimited participants

$799

  

Upcoming Webinars