Mastering Microsoft Access Basics Training Class

Course ID: 14152

Mastering Microsoft Access Basics Training Seminar

Discover all that Access can do to keep you on top of the mountain of information you need to run you business and manage your time

Keeping on top of the mountain of information you need to run your business or do your job is a job in itself these days. Practically everyone - in any role - is at some time overwhelmed by how much data needs to be recorded, kept track of, updated regularly, stored, and ultimately shared with or presented to someone else.

A daunting task, to be sure. But made far less intimidating thanks to data management programs like Microsoft's powerful - and user-friendly - Access software.

This is ideal training for...

Beginning Access users. This course will help you get the fundamentals down pat, allowing you to continue to build your Access expertise on solid ground.

Intermediate and more advanced users. Even if you believe you've mastered all the Access skills you need, we guarantee you'll come away with a slew of new tricks, tips and shortcuts that you never would have found on your own.

Managers, entrepreneurs, small business owners. Anyone in search of a better way to manage the often-intimidating volume of information it takes to run a business or department will gain valuable new skills.

Spectators eager to become active Access users. You've been observing long enough. You've seen the awesome reports - simple, clear, loaded with at-a-glance information - that others produce. Now you're ready to sit at the controls and master Access yourself. This course proves the impetus you need to add a powerful new business tool to your workbox.

Spend just one day learning the ropes of Access, and in no time you'll be using it to automate your data-keeping, monitor your inventory, or streamline just about any task in which having instant access to information is key to your success - and keeping your sanity! Covers 2003 and all previous versions

Agenda

Seminar Overview

The seemingly endless possibilities of using databases to manage and build your business

The lingo of database management - key terms that will help facilitate your mastery of Access

"Flat file" vs. "relational databases" - how they differ, when to use one or the other

Making certain the database you create meets your needs

Avoiding the common mistakes in database planning that inevitably spell trouble later

Eliminating redundancy and other tips to optimize your database

The all-important distinctions between tables, queries, forms and reports

Simple, effective steps to creating the perfect query

How to modify Wizard-created databases, tables, forms and reports

Amazing Access shortcuts - time and work-savers you'd never find on your own

How to generate automatic Access forms that will make data entry and retrieval easy for anyone

Find, Filter and Sort - their differences, when to use each

How to link tables so that finding and manipulating are easier

3 different ways to create tables and how to determine which way is best in each situation you face

Step-by-step instructions for running labels

Best ways to import and export data between databases

How to allow others to share your database info

Advanced analysis tools to consider in your data management system