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

Back to Top

The best Access training available.

• e-Learning is simply web-based training. There are no CDs or software to install on your computer. All you need is an internet connection and a web browser (such as Internet Explorer). Watch, listen and learn as training professionals demonstrate each lesson right on your computer screen. No long-term commitments. Cancel anytime.
• Always available. All of our courses are available 24 hours a day, 7 days a week. Once you purchase your subscription, simply login for instant access to your courses.
• Our courses are designed by software training professionals who with years of classroom training experience.
• Learn at your office or home - at your own pace.
• Comprehensive! Includes all of the topics covered in classroom trainings.
• FREE access to e-manuals. Your subscription includes access to classroom e-manuals (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 your software, making it the most realistic practice available.
• The best, most convenient way to learn on your own - at a fraction of the price of classroom training.
• The confidence in knowing your training was created by software training professionals.

Back to Top

All Courses | Samples | FAQs | About Us | Contact Us | Buy Now

© TeachUcomp, Inc. All Rights Reserved.