Full-motion animation & crystal-clear audio.
Instruction manuals provided in PDF.
Topics Covered | Tutorial Features
Comprehensive
CPE self-study tutorials
for accounting professionals.
| Product: | Mastering Access Made Easy | ||
| Versions: | 2007 through 97 | ||
| Edition: | CPE Edition | ||
| CPE Hours: | 9 (verify eligibility) | ||
| Lessons: | 129 Video Lessons | ||
| e-Manuals: | 3 | ||
| Price: | |||
| Includes: | Complete Access Tutorial CPE Module Practice Exams Final Exam Submission Certificate of Completion |
||
Additional people in the same office need CPE? Just $39.95/test submission! |
|||
How do I know if the hours qualify for me? |
|||
How It Works
1. Complete the tutorial at your own pace.
2. Submit your exam within one year of
your receipt date.
3. Pass the exam with a score of 70%+.
4. Receive your Certificate of Completion.
TeachUcomp, Inc.'s courses are written by internationally
known authors and prepared in accordance with the
standards and requirements for interactive self-study as
defined by NASBA and AICPA.
Each individual State Board of Accountancy has
the final authority in awarding CPE credit.
TeachUcomp, Inc. makes no representations or
warranties with respect to its content, use or
acceptability. It is the responsibility of the individual
user to verify approved credits.
Check your state here
The most comprehensive Access tutorial available. Covers all of the same material as a
three-day classroom training - Introductory, Intermediate & Advanced.
Getting
Acquainted with Access
1. The Access Screen
2. Overview of a Database
3. Working with Database Objects
4. Opening and Closing Databases
5. Database Objects
Creating
Relational Database Tables
1. Creating New Databases
2. Flow Overview of a Database
3. The "Flat-File" Model of Data Storage
4. The Relational Model of Data Storage
5. Tips for Creating a Relational Database
6. Creating Relational Database Tables
7. Assigning a Primary Key to a Table
Using
Tables
1. Using Datasheet View
2. Navigating in Datasheet View
3. Adding Records in Database View
4. Editing and Deleting Records in Datasheet View
5. Inserting New Fields
6. Renaming Fields
7. Deleting Fields
Field
Properties
1. Setting Field Properties
2. The 'Field Size' Property
3. The 'Format' Property for Date/Time Fields
4. The 'Format' Property for Logical Fields
5. Setting Default Values for Fields
6. Setting Input Masks
7. Setting Up Validation Rules and Responses
8. Requiring Field Input
9. Allowing Zero Length Entries
Joining
Tables in a Database
1. Using the Relationships Window
2. Enforcing Referential Integrity
3. Creating Lookup Fields
Indexing
Tables
1. Indexes
2. Creating Indexes
3. Designing a Multi-field Primary Key
4. Deleting Indexes
Queries
1. What Does a Query Do?
2. Using the Simple Query Wizard
3. Designing Queries
4. Joining Tables in a Query
5. Adding Criteria to the QBE Grid
6. Running A Query
7. How is Using the QBE Grid Writing SQL Code?
8. Sorting Query Results
9. Hiding Fields in a Query
10. Using Comparison Operators
11. Using 'AND' and 'OR' Conditions
Advanced
Queries
1. Using the 'BETWEEN...AND' Condition
2. Using Wildcard Characters in Criteria
3. Creating a Calculated Field
4. Creating 'Top Value' Queries
5. Function Queries
6. Parameter Queries
Advanced
Query Types
1. Make-Table Queries
2. Update Queries
3. Append Queries
4. Delete Queries
5. Crosstab Queries
6. The 'Find Duplicates' Query
7. The 'Find Unmatched' Query
Creating Forms
1. What Are Forms For?
2. The Form Wizard
3. Creating AutoForms
4. Using AutoForms
5. Designing Basic Forms
6. Form and Report Design View
7. Viewing the Ruler and Gridlines
8. The 'Snap to Grid' Feature
9. Creating a Form in Design View
Form
& Report Controls
1. Selecting Controls
2. Deleting Controls
3. Moving and Resizing Controls
4. Sizing Controls 'To Fit'
5. 'Nudging' Controls
6. Aligning, Spacing and Sizing Controls
7. Formatting Controls
8. Viewing Control Properties
The
Control Toolbox
1. The Control Toolbox
2. Adding Label Controls
3. Adding Image Controls
4. Adding Line Controls
5. Adding Rectangle Controls
6. Adding Combo Box Controls
6. Adding List Box Controls
7. Setting Tab Order
Subforms
1. Creating Subforms
2. Displaying Subform Data
Reports
1. Using the Report Wizard
2. Creating AutoReports
3. Creating a Report in Design View
4. Sorting and Grouping Data in Reports
5. Creating Calculated Fields
Subreports
1. Creating Subreports
Charting Data
1. Creating Charts
2. Editing Charts
Macros
1. Creating and Using Macros
2. Macro Actions
3. Assigning Macros to a Command Button
4. Conditional Macros and Option Groups
5. Using Group Names in Macros
6. Creating Autoexec Macros
Switchboard Forms
1. Creating a Switchboard Form
2. Controlling Startup Behavior
Customizing Toolbars
1. Setting Toolbar and Menu Options
2. Creating Custom Toolbars
3. Creating Custom Popup Menus
Advanced Features
1. Linking Tables
2. Importing External Data
3. Setting a Database Password
4. Using the Help Files
- Designed by software training professionals.
- Earn your CPE hours and learn at your office or home - at your own pace.
- Comprehensive! Includes all of the topics covered in a three-day classroom training.
- Includes the same three classroom manuals our students receive (in PDF), along with practice exercises & keyboard shortcuts!
- Customize your training with the easy-to-use menu.
- Clear, easy-to-follow, step-by-step instruction.
- Watch the training sessions as many times as you want while you practice in Access.
- No messy set-up, no internet connections needed.
- The best way to earn your CPE hours and learn Access on your own.
- The confidence in knowing your Access tutorial was created by software training professionals.
All Products | Samples | FAQs | About Us | Contact Us
© TeachUcomp, Inc. All Rights Reserved.