What can YOU do with the amazing techniques you’ll learn?

Access tames even the most overwhelming volume of data into usable bits that are easy to identify and analyze. Attend this session and you’ll be able to use it for more things than you could ever imagine. Use what we teach you to:

• Turn that pile of vendor business cards you have in your desk into a manageable calling list of business contacts
• Improve your sales efficiency by creating sortable customer lists
• Facilitate billings and payments to simplify the accounting process Monitor expenses — to the penny!
• Improve your customer service by tracking outgoing shipments closer Maintain critical employee information at your fingertips
• Keep accurate time logs to eliminate costly payroll mistakes
• Manage your customer lists more effectively by creating customizable filters and queries
• Enhance your project management skills
• Store all your inventory information in one convenient place
• Organize subscriber records
• Capture data and user information off the Internet and automatically sort it and store it

And this is just a small fraction of the daily responsibilities that you can “automate” when you learn the ins and outs of Access. You won’t find a faster and easier way to learn how to use this powerful program to your best advantage! Enroll today!

Anyone who is responsible for organizing, analyzing and interpreting critical data and wants to learn how to do it easier and faster, including:

• Finance and accounting pros
• Supervisors and managers
• Business owners
• Office managers
• Administrative assistants
• HR staff
• Project managers
• Sales staff professionals
• And YOU!

This program is for Windows and Mac users and will cover all versions of Access.

Creating Database Tables: A Step-By-Step Guide

• How will you structure your table?
• Figuring out what you need
• Creating your database design
• Will the Table Wizard have the answer?
• Understanding and using a primary key

How-To’s for Using Your Access Database

• How to enter, add, delete and change data in your tables
• Selecting field properties for every data type
• What you need to know about “relationships” among and within tables
• Referential Integrity, Table Analyzer and other tools for data quality control
• Special considerations for multi-users

Finding and Manipulating Data

• When it’s time to remodel: What to do when the table no longer meets your needs
• Adding and using memo fields
• Using the Find button to search for data
• Reasons why you may want to link tables
• Shortcuts for effective searches: Understanding find, filter and sort

Understanding and Using Queries

• Query criteria — telling Access how to filter your information
• Comparison operators — what they are and how to make them work for you
• Creating multiple condition queries
• Timesaving functions of Query by Example
• Extracting data from multiple tables

Forms With Function

• Pick the form layout that works for you
• Displaying the right information on your form
• Changing form default control properties
• Label controls and text box controls — moving, modifying and more
• Integrate information from more than one table

Reporting Your Data: The Basics

• Columnar, tabular, mail merge and mailing labels — what’s the difference
• Creating simple reports with Report Wizard
• Choosing a grouping level and sort order
• Formatting your report for clarity and ease of use
• Columnar reports at a click with AutoReport
• Getting Access to do the calculations for you

“Short and to the point, covering all bases, knowledgeable to all questions.”
L. Ledesma
Payroll & Compensation Coordinator
West Coast Arborists

"I've attended many events through National Seminars Group and have not once been disappointed with the skills I've learned. Today may have even been the best seminar yet, I learned many new things and was refreshed on things I'd learned in the past. Thank you!"
O. Unell
VP of Sales
Brighton Express

“The day went by quickly and was packed with valuable information. Presented with clear ‘how-to’s,’ ‘whys,’ etc., without a lot of wasted words.”
P. Lympany
Fiscal Services Supervisor
Burbank School District