Microsoft® Access® 2007 Basics
Smart data-management tools for every Access 2007 user
Covers Access 2007
Are you drowning in data?
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 such a never-ending stream of things to keep an eye on and remember, trends to spot-check or numbers to have at your fingertips — you could drown in all the data if you had to manage it manually.
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 managing any business — large, small, and in-between.
Through a lively mix of demonstrations, examples, and instructor-led exercises, you'll learn how to use Access to create 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 current and future needs.
In just one information-packed day, you'll be able to …
- Improve workplace productivity with a wealth of Access tools, tips, and insider secrets
- Make data immediately available and easily understandable to coworkers, customers, vendors, and anyone else who needs it
- Customize views and formats to show precisely the information you need
- Create professional reports of exceptional quality — complete with graphics, color, and special effects
- Design complex macros that automate even the most complicated database management tasks
- Master advanced query techniques to make entering, retrieving, and manipulating data a breeze
- Keep your database secure and protected at all times
Who will benefit the most …
Managers and Supervisors, Administrative Assistants, Small Business Owners — Anyone responsible for organizing, analyzing, and interpreting data.
How we present this material
This is not a hands-on training and for a good reason. Everyone works on computers at a different speed. Some people like to experiment, others get lost and need help. In the long run, a hands-on class slows everyone down.
You do need to know how your new system's features work, how to use them and where to activate them.
Your seminar leader will tailor the content of this one-day training program to address your organization's specific needs.
As a result of this training, your staff will come away from this workshop with …
- A greater understanding of databases and their uses
- A good grasp of the lingo they need to know
- A new appreciation for the careful planning that goes into building any kind of database
Read Program Overview
Program Overview
Understanding 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
Planning Your Database Management System
- How to decide which data you need to manage
- Why it's critical to determine what information your database needs 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
- Tips for eliminating redundancy and optimizing your database
Back to Program Overview
Creating 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 databases
- How to modify Wizard-created databases, tables, forms, and reports
Creating Access Tables
- 3 different ways to create tables and how to determine which way is best in each situation
- Importing data from other databases for use in your Access table
- Database fields explained — how to choose the right ones
- What a "primary key" is — and how to pick the right one
- How to add, remove, and modify fields in existing tables
Back to Program Overview
Creating User-Friendly Databases
- 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
Finding Data and Manipulating it to Your Advantage
- Shortcuts for more effective searches
- Find, Filter, and Sort — their differences, when to use each
- How to link tables so that finding and manipulating data are easier
- The correct way to apply memo and keyword fields
Back to Program Overview
Retrieving Data with Filters, Sorts, and Queries
- Simple, effective steps to creating the perfect query
- How "comparison operators" can help you track down hard-to-find data
- Query Wizards and other automatic features
- Datasheets explained — what they are and how to use them
- When to use multiple condition queries, and how to create them
Using Reports to Summarize and Analyze Data
- How to format reports for optimum clarity and user-friendliness
- Advanced analysis tools to consider in your data management system
Back to Program Overview
 Back to the "Corporate Seminars" Index
Contact us and bring this Seminar to your organization
|
Seminars
