The Essentials of Microsoft^® Access^TM

Find out how Access can keep you on top of the mountain of information you need to run your business and manage your time Covers All Versions for the PC and Mac!

1-Day Seminar - US $179.00; For groups of 5 or more, 169.00

You won't find a faster, easier way to learn Access ...

Microsoft Access is one powerful business tool. It's become the software of choice for anyone who needs to organize, manage, store, and share all the different kinds of information that go into running any business — large, small, and in-between.

The applications of Access are virtually limitless ...

Just think of all the information that comes across your desk or through your department every day: sales stats ... inventory requests ... customer service reports ... vendor correspondence. There's a never-ending stream of details to keep an eye on and remember, trends to spot-check, and numbers to have at your fingertips — you could drown in all the data if you had to manage it manually. Fortunately, this course is packed with valuable Microsoft Access tips and tricks!

Access can be your best friend when it comes to ...

• Creating a customer mailing list
• Billing and refunds
• Monitoring expenses
• Tracking incoming orders and outgoing shipments
• Cataloging photographs, clip art, and multimedia resources
• Maintaining employee files
• Keeping time logs
• Monitoring sales performance and histories
• Storing subscriber or donor records
• Managing investment portfolios
• Maintaining vendor profiles
• Planning events or trade shows

As with any tool, Access is effective only if you use it correctly. That's where this Microsoft Access seminar comes in.

Through a lively mix of demonstrations, examples, and instructor-led exercises, you'll learn the Microsoft Access basics for creating databases that will help you manage and use all the information you deal with daily. This training gives you the foundation for building your skill level as you develop a data management system that truly meets your needs. Plus, save $80 when you attend both The Essentials of Microsoft Access and Advanced Queries, Forms, Reports, and Macros!

Microsoft Access Basics — Seminar Overiew

• Information Management and Its Role in Business
• The Planning Stage of a Data Management System
• Step By Step, How to Create an Access Database
• What You Should Know About Access Tables
• The User-Friendly Database
• How to Find and Manipulate Data to Your Advantage
• Data Retrieval With Filters, Sorts, and Queries
• Reports for Summarizing and Analyzing Data

Information Management and Its Role in Business

• What a database is — and what it isn't
• The many roles databases can play in helping you manage and improve your business
• "Flat file" vs. "relational databases" — how they differ and when to use one or the other

The Planning Stage of a Data Management System

• How to decide which data you need to manage
• Why it's critical to determine what information you want your database to provide  — before you create it
• How to be sure the complexity of your database doesn't exceed the skill level of those who will be using it

Step By Step, How to Create an Access Database

• The all-important distinctions between tables, queries, forms, and reports
• How to leverage the power of Wizards and other Access features to automate the creation of your database

What You Should Know About Access Tables

• How to avoid the common pitfalls in defining fields
• A look at importing data from other databases
• What a "primary key" is — and how to pick the right one

The User-Friendly Database

• How to generate automatic Access forms that will make data entry and retrieval easy for anyone
• Insider tips on modifying and customizing forms
• "Validation rules" that prevent data entry errors from wreaking havoc on your business

How to Find and Manipulate Data to Your Advantage

• Find, Filter, and Sort — their differences and when to use each
• How to link tables so that finding and manipulating data is easier
• The correct way to apply memo and keyword fields

Data Retrieval With Filters, Sorts, and Queries

• Simple, effective steps to creating the perfect query
• Query Wizards and other automatic features

Reports for Summarizing and Analyzing Data

• How to format reports for optimum clarity and user-friendliness
• Advanced analysis tools to consider in your data management system

* NOTE: This is not a hands-on workshop. Instead, you'll learn via "computerless" training that makes every moment count.

Find a Seminar Near You
USA	State AK AL AR AZ CA CO CT DC DE FL GA HI IA ID IL IN KS KY LA MA MD ME MI MN MO MS MT NC ND NE NH NJ NM NV NY OH OK OR PA PR RI SC SD TN TX UT VA VT WA WI WV WY
CANADA	Prov AB BC PE MB NB NS ON QC SK NF NT NU YK
POSTAL CODE (US, UK, or Canada)   + Miles
Back to top

To find out more about The Essentials of Microsoft Access, contact our customer service department at customerservice@pryor.com or by phone at 1-800-780-8476.