Starting with the basics and building your skills
to more advanced tasks, this 2-day, hands-on Microsoft Access seminar provides you
with the database solutions you need to run your business or do
your job.
You'll learn first-hand how to create and manage
tables and queries, integrate with other applications, create
macros, design forms, use the Switchboard Manager, and generate
reports. Whether you're a first-time Access user, or looking to
move your skills to a more advanced level, this exceptional 2-day
Microsoft Access training will give you dozens of techniques you can apply the very next
day on the job.
Microsoft Access training — Seminar Overview
Day 1
Day 2
Day 1
Understanding the "Big Picture": Designing the Database
Knowing how to plan and organize a complete database structure from its inception
is the key to avoiding common problems. In this session, youll learn how to design
and plan an Access database that makes your data simple to collect, input, view, and
retrieve.
- A careful look at database structure — before you make the first keystroke
- How to "fix" an existing database that's poorly designed … without losing
your original data
- An Access "map"! Learn exactly what's behind every icon, bar, button, and switch
on the Access desktop
- Instant database! Use the Wizards to create and modify a database … in minutes
Back to Seminar Overview
Laying the Foundation: Creating Tables
Learn how to design and create tables that are easy to use and understand, and
discover tips, tricks, and terminology that take the mystery out of creating and using
tables.
- Facts on fields: guidelines on field types, and how to choose the right one
- How to "build in" table features that will save you hours of input time later
- Table time-savers: Create ready-to-use tables with the Wizard
- A "checkpoint" you can set in the field level that minimizes input mistakes
Back to Seminar Overview
Getting the Data Back Out: Filtering Features
Learn the basics (and the slick tricks) of how to filter and sort your data, and
uncover the answers you're looking for — faster than you ever thought possible.
- When you need simple answers quickly: how to perform a fast temporary filter
- A clever way to "save" frequently used filters
- More complex filters: use "AND" and "OR" conditions, without the confusion!
- Filter versus Query: how they're different, and when to use each
Back to Seminar Overview
Retrieving Data, Your Way: Conquering Queries
Learn how to write and save Queries that put critical information in your hands …
quickly, easily, and effortlessly.
- Exactly what Queries are … and how they can save you hours of "busywork"
- How to design a Query once … and recall it again and again, whenever you need it
- When you're writing more complex Queries: 2 time-saving tools that will have you off and running!
- Syntax secrets: Learn how to easily read Query syntax!
Back to Seminar Overview
Day 2
Producing Functional Forms
Well-designed forms can save you precious hours and prevent needless hassle. Learn
the secrets to creating and using the powerful Access forms tools that make adding to
your database simple and headache-free!
- How to format a form for maximum ease of use and readability
- Don't avoid subforms! Why they're powerful, and how you can take advantage of them
- Autoform and Wizards: Let them take the labor out of forms creation
- How to modify any existing form to suit your exact needs
Back to Seminar Overview
Achieving Superior Output from Access: Creating Reports
Learn how to get the data in the format you need — on paper — where you
can use it to make better decisions, strategize, improve service … you name it! You'll
learn, step by step, how to output information from your database in reports that are
easy to generate, read, and use.
- 3 methods for generating reports … and how to choose the right one
- How to make a report from scratch — totally customized!
- Tips for "touching up" automatically generated reports for speedy "semi-customized" output
- How to transfer and use your reports in other applications, such as Microsoft Word
Back to Seminar Overview
Mastering Access Macros
Macros are incredible tools to get Access to do your work for you … with just a
single click, or even automatically! Learn how to write macros to perform the repetitive,
tedious tasks that eat up your time and energy.
- What macros are … and where you can use them to "automate" repetitive tasks
- Critical decisions you must make before attempting to design any macro
- An easy tool that makes macros even more powerful … and is unknown to most Access users!
- How to create and run macros: you may have more options than you think!
Back to Seminar Overview
Using Data Access Pages: Making the Net Connection
As the world goes online, there's a good chance your data will need to as well. You'll
learn how Data Access Pages enable you to publish information from your database on internal
networks or even the Internet — and you don't need to be a "Web guru" to do it!
- Data Access Pages defined … in plain English!
- The 3 main types of Data Access Pages: Which fits your needs?
- Security strategies: how to protect data that's published and accessible
- How to use AutoPage and Wizards to easily create Data Access Pages — even if you have
NO experience creating Web pages
Back to Seminar Overview
Creating the Dynamic Database
The ability to link, share, import, and export data gives you the ultimate in flexibility,
ease of use, and sheer power! You'll learn how to use your database in a more fluid way, without
the traps and mistakes that frustrate many users.
- How to avoid the bottleneck that forces you — or others — to "re-create" the
same data
- The "tie" to other applications: exactly where you can import/export data
- How to ensure your data stays safe through countless import/export transactions
- "Splitting" a database: how it can cure problems caused by multiple users or extra-large databases
Back to Seminar Overview
Seminars
Share this Page
CD-ROM
