the Essentials of Microsoft® Access - Tips, Tricks & Shortcuts
this versatile database management program into
your #1 resource to make your work and life easier!
just one day youll dramatically improve your mastery of Access!
In a world that seemingly moves faster than the
speed of light, your ability to organize critical business data,
filter out pertinent information, and get immediate answers to
your most pressing business questions is the difference between
success or fighting to keep your company alive in the marketplace!
As a new or fairly new user of Microsoft
Access, you know youre probably only using a fraction
of this powerful programs capabilities. Youre looking
for a quick and easy way to learn how to tap into everything that
will make your job easier. And you definitely dont have time
to grind through a two thousand-page manual to learn how.
Thats why were bringing this unique
and refreshing one-day Access workshop to your area. Attend, and
youll learn shortcuts that dramatically cut the time it takes
you to do your most common tasks ... proven and practical strategies
that virtually eliminate frustrating errors that drive you crazy
... and productivity-enhancing tips that will allow you to take
advantage of everything Access can offer!
Whether youre the person making critical business
decisions or the caretaker of the vital data your company
or department uses its never been easier to keep all
your information organized and immediately accessible.
When you attend our seminar, youll gain only
the techniques and strategies that make the biggest impact on your
daily responsibilities ... your productivity ... and your efficiency.
In just one day of intensive training, youll ...
- Understand the components of a database
- Discover common uses of databases for business
that you may not have ever thought about
- Gain a step-by-step guide to creating an Access
- Give users you want full access to your database
and keep the people you dont want in there out!
- Find and manipulate your data easier
- Add memo fields with a couple of mouse clicks
- And more!
CompEd Solutions will make you a Power User
At CompEd Solutions, weve been helping thousands
of success-minded business pros just like you learn
how to take full advantage of the latest business technology each
and every year. Dont be a slave to cumbersome software manuals
that slow you down and rob you of your efficiency. And dont
put yourself at the mercy of your I.T. departments overwhelming
schedule. Come learn simple but powerfully effective
strategies and shortcuts that let you control MS Access and not
the other way around!
Learn to create user-friendly databases and get
the foundation of skills that will help you create a data management
system that meets all your needs.
What can YOU do with the amazing techniques youll
Access tames even the most overwhelming volume of
data into usable bits that are easy to identify and analyze. Attend
this session and youll 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
- Facilitate billings and payments to simplify
the accounting process
- Monitor expenses to the penny!
- Improve your customer service by tracking outgoing
- Maintain critical employee information at your
- Keep accurate time logs to eliminate costly
- Manage your customer lists more effectively
by creating customizable filters and queries
- Enhance your project management skills
- Store all your inventory information in one
- 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 wont find a faster and easier way to learn
how to use this powerful program to your best advantage! Enroll
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.
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
for Using Your Access Database
- How to enter, add, delete and change data in
- 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
and Manipulating Data
- When its 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
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
- 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
Your Data: The Basics
- Columnar, tabular, mail merge and mailing labels
whats the difference
- Creating simple reports with Report Wizard
- Choosing a grouping level and sort order
- Formatting your report for clarity and ease
- Columnar reports at a click with AutoReport
- Getting Access to do the calculations for you
Guarantee of Complete Satisfaction
We stand behind our seminars
with a 100 percent , iron-clad, money-back guarantee
of satisfaction. If for any reason youre not completely satisfied
with the solid skills, the tips, tools and shortcuts, and the crucial
information you receive during this workshop, well refund your money
in full. Every penny. Guaranteed!