presents


National Seminars Group & Padgett Thompson
a division of Rockhurst University Continuing Education Center
Course Description


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   Software Versions Covered
What You’ll Learn   Who Should Attend

Dates/Locations, Pricing, Register

Workshop Agenda  

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:
9:00 a.m. to 4:00 p.m. Registration begins at
8:30 a.m.


Group Discount: When 3 enroll from your organization, a 4th attends FREE!

Lunch:
Lunch is on your own.

Continuing Education:
Continuing education credits may be recognized by your professional board. Contact your own board to find out what's required. If you cancel your registration up to five business days before the workshop,

Bring a seminar to your site! For information about bringing a course to your site please call 919-480-2550 or email the registry at .

If this course or the dates/locations below do not have what you are looking for, then click here and we will find it for you right away. It will save you a lot of time and energy finding it yourself.

** Register Online**

Select date/location from list box below (Use side arrow to scroll). Complete form and click on 'Send'

Title: Mr. Mrs. Ms
Fields with an "*" are required input.
* Attendee Name:
Position:
* E-Mail:
Company:
* Address 1:
Address 2:
* City:
* State/Province:
* Zip/Postal Code:
Country:
* Phone:
* Fax:
* Contact first and last name:
Approving supervisor first and last name:
Click here to add more attendees.
Dollar Amount of Transaction:
(Please add appropriate sales tax if in SD or WV.)

Payment Information
Invoice Me, or
Credit Card Info:
Credit Card Type: American Express VISA Mastercard
Credit Card Number:
Expiration Date:
Name on Card:
 
PO # (if applicable):
Tax Exempt #:

Additional Attendees: Use for listing additional attendees only.
Attendee 2 Name:
Attendee 3 Name:
Attendee 4 Name:
(4th is FREE when you register 3)
Attendee 5 Name:
Attendee 6 Name:
Attendee 7 Name:
Attendee 8 Name:
(8th is FREE when you register 7)

Additional Information:

National Seminars Group will e-mail confirmation soon. If you are not paying via credit card, you will receive an invoice with payment instructions.

Cancellation Policy:
If you cannot attend a workshop for which you are registered, you may send a substitute or receive a credit memo toward a future workshop. If you cancel your registration up to five business days before the workshop, your registration fee will be refunded less a $10 enrollment charge.

You can also register by emailing your registration information to us at or calling us at 919-480-2550. Please mention the meeting number specified above and BE SURE TO STATE VIP CODE "919-120001-000 -- Training Registry".

Cover Page | Padgett Thompson Seminars



The Training Registry