Would you like to take control of information overload?
Learn how to design, build, manipulate, and maintain an efficient database. Plus, learn how to use new and advanced Access features that can make you the master of the mountain of data you are confronted with each day.
Put the power behind your customer records, mailing lists, inventory records, sales or product data. In just two high-impact days, you'll get advanced tips and tricks to master Access basics. This top-notch workshop is hands-on for learning that sticks.
In just one, six-hour course, participants will learn:
- How to alter "canned" reports to look like custom-programmed output
- How to prevent mistakes in input
- How to filter out data you don't need ... and highlight what you do want to see
- How to share data with others — without ever risking the safety of your original data
- 2 great tricks to get Access to do your job for you
Who will benefit the most:
This is ideal training for beginners to somewhat experienced Access users. Even those users who are getting the job done but are "stuck in a rut" or need to update their older Access verions will gain a deeper understanding of what Access can do for them.
How we present this material:
You'll do it yourself and see the results — making it even easier to apply the techniques when you're back at your own desk! What's more, we've designed it so that no matter what your pace of work, everyone can work in tandem.
Key learning points:
- Every bar, button, key, icon, and switch on your Access desktop explained
- A clever technique to do both spreadsheets and databases at the same time
- Little-known tricks to cut keyboarding by up to half
- Put your data on the Web instantly, with virtually NO knowledge of Web pages
- Put sparkle into Access reports with graphic elements
- Simple "checkpoints" that make it easy to produce even complex Queries
- Protect your data ... and even recover accidentally deleted data
As a result of this training:
You'll know when and why to use features, how to solve problems, and how to customize Access for the way you work. Working smarter, you'll add value, save time, simplify tasks, and produce more valuable information.
Program Overview
Designing the Database
- The Access Environment: Screens, Toolbars, and Windows
- Database Elements
- Using the Database Wizard
Creating Tables
- Creating Tables from Scratch
- Setting Field Properties
- Decimal Place, Default Value, Required Entry, Data Validation
- The Input Mask
- Creating a Primary Key
Filtering Features
- Filter by Selection and by Form
- Creating "AND" and "OR" Conditions
- Using Advance Filter/Sort
Conquering Queries
- Creating a Select Query in Design View
- Specifying Query Criteria
- Creating a Parameter Query
- Creating a Make Table Query
- Creating a Delete Query
- Creating an Append Query
- Using the Top Ten Feature
Producing Functional Forms
- Creating Forms from Scratch
- Adding and Resizing Controls
- Creating Forms with AutoForm
Reports Done Right
- Creating Reports from Scratch
- The Report Design Window
- Adding Controls
- Creating Reports with AutoReport
- Formatting Reports
Mastering Access Macros
- The Macro Design Environment
- Entering Actions in a Macro
- Adding Actions and Setting Conditions
- Creating a Macro Group
- Methods for Running Macros
Data Access Pages
- Defining Data Access Pages
- Creating Pages with AutoPage
- Creating Pages with the Wizard
- Linking, Importing, and Exporting Data
- Splitting the Database
|
