Mastering
the Essentials of Microsoft® Access - Tips, Tricks & Shortcuts
Turn
this versatile database management program into
your #1 resource to make your work – and life – easier!
Program
Description
In
just one day you’ll 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 you’re probably only using a fraction
of this powerful program’s capabilities. You’re looking
for a quick and easy way to learn how to tap into everything that
will make your job easier. And you definitely don’t have time
to grind through a two thousand-page manual to learn how.
That’s why we’re bringing this unique
and refreshing one-day Access workshop to your area. Attend, and
you’ll 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 you’re the person making critical business
decisions – or the caretaker of the vital data your company
or department uses – it’s never been easier to keep all
your information organized and immediately accessible.
When you attend our seminar, you’ll 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, you’ll ...
- 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
database
- Give users you want full access to your database
– and keep the people you don’t 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”
– Guaranteed!
At CompEd Solutions, we’ve 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. Don’t be a slave to cumbersome software manuals
that slow you down and rob you of your efficiency. And don’t
put yourself at the mercy of your I.T. department’s 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
You’ll Learn
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!
Who
Should Attend
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!
Software
Versions Covered
This program is for Windows and Mac users and will
cover all versions of Access.
Workshop
Agenda
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
Your
Guarantee of Complete Satisfaction
We stand behind our seminars
with a 100 percent , iron-clad, money-back guarantee
of satisfaction. If for any reason you’re not completely satisfied
with the solid skills, the tips, tools and shortcuts, and the crucial
information you receive during this workshop, we’ll refund your money
in full. Every penny. Guaranteed!
Program
Hours: