Access Training Course by CustomGuideCBT

Access 2003~The Fundamentals
Introduction to Databases
What's New in Access 2003?
Starting Access and Opening a Database
Understanding the Access Program Screen
Using Toolbars
Hiding, Displaying, and Moving Toolbars
Filling Out Dialog Boxes
Keystroke and Right Mouse Button Shortcuts
Opening and Modifying Database Objects
Working with Multiple Windows
Tour of a Table
Adding, Editing, and Deleting Records
Tour of a Form
Tour of a Query
Tour of a Report
Previewing and Printing a Database Object
Selecting Data
Cutting, Copying, and Pasting Data
Using Undo
Checking Your Spelling
Getting Help from the Office Assistant
Changing the Office Assistant and Using the "What's This" Button
Using the Zoom Box
Closing a Database and Exiting Access
Creating and Working with a Database
Planning a Database
Creating a Database Using the Database Wizard
Creating a Blank Database
Creating a Table Using the Table Wizard
Modifying a Table and Understanding Data Types
Creating a New Table from Scratch
Creating a Query in Design View
Modifying a Query
Sorting a Query using Multiple Fields
Developing AND and OR Operators
Creating a Form with the Form Wizard
Creating a Report with the Report Wizard
Creating Mailing Labels with the Label Wizard
Database Object Management
File Management
Compacting and Repairing a Database
Converting an Access 97 Database
Finding, Filtering, and Formatting Data
Finding and Replacing Information
Sorting Records
Filtering by Selection
Filtering by Form
Creating an Advanced Filter
Adjusting Row Height and Column Width
Rearranging Columns
Changing Gridline and Cell Effects
Freezing a Field
Hiding a Column
Changing the Datasheet Font
Working with Tables and Fields
Understanding Field Properties
Indexing a Field
Adding a Primary Key to a Table
Inserting, Deleting, and Reordering Fields
Changing a Field?s Data Type
Using Field Descriptions
Adding a Caption
Change the Field Size
Formatting Number, Currency, and Date/Time Fields
Formatting Number, Currency, and Date/Time Fields by Hand
Formatting Text Fields
Setting a Default Value
Requiring Data Entry
Validating Data
Creating an Input Mask
Creating a Lookup Field
Creating a Value List
Modifying a Lookup List
Creating Relational Databases
Understanding Table Relationships
Creating Relationships between Tables
Enforcing Referential Integrity
Testing Referential Integrity and Deleting a Relationship
Understanding of Relationship Types
Working with Queries
A Quick Review
Creating a Multiple Table Query
Creating a Calculated Field
Using Expressions
Using an IIF Function
Summarizing Groups of Records
Using Criteria
Display Top or Bottom Values
Parameter Queries
Finding Duplicate Records
Finding Unmatched Records
Crosstab Queries
Delete Queries
Append Queries
Make Table Queries
Update Queries
Working with Forms
Creating a Form with AutoForm
Modifying a Form
Adding and Deleting Fields
Moving and Sizing Controls
Changing the Tab Order
Working with Control Properties
Control Property Reference
Working with Form Properties
Form and Report Property Reference
Working with Multiple Controls
Adding, Cutting, Copying, and Pasting Controls
Changing a Control?s Data Source
Creating a Calculated Control
Changing a Control?s Default Value
Using the Control Wizard
Creating a Subform
Modifying and Working with Subforms
Working with Reports
Creating a Report with AutoReport
Modifying a Report
Adding and Deleting Fields
Moving and Sizing Controls
Adjusting Page Margins and Orientation
Adding Page Numbers and Dates
Understanding Report Sections
Grouping and Sorting Records
Creating Calculated Controls
Working with Section Properties
Creating Charts with the Chart Wizard
Formatting Forms and Reports
Formatting Fonts with the Formatting Toolbar
Changing Text Alignment
Using AutoFormat
Changing Colors
Applying Special Effects
Using the Format Painter
Adding Pictures and Lines
Aligning Controls with One Another
Changing a Control?s Formatting Properties
Working with Macros
Creating and Running a Macro
Editing a Macro
Working with Macro Groups
Assigning a Macro to an Event
Creating Conditional Expressions
Assigning a Macro to a Keystroke Combination
Macro Action Reference
Using Access with Other Programs
Importing Information
Exporting Information
Importing Objects from another Access Database
Linking Information from an External Source
Analyzing Records with Microsoft Excel
Exporting Records to Microsoft Word
Mail Merging Records to Microsoft Word
Using Hyperlink Fields
Using OLE Object Fields~~~6949~6952~~

Access XP~Introduction to Databases
What's New in Access 2002?
Starting Access and Opening a Database
Understanding the Access Program Screen
Using Menus
Using Toolbars and Creating a New Workbook
Filling Out Dialog Boxes
Keystroke and Right Mouse Button Shortcuts
Opening and Modifying Database Objects
Working with Multiple Windows
Tour of a Table
Adding, Editing, and Deleting Records
Tour of a Form
Tour of a Query
Tour of a Report
Previewing and Printing a Database Object
Selecting Data
Cutting, Copying, and Pasting Data
Using Undo
Checking Your Spelling
Getting Help from the Office Assistant
Changing the Office Assistant and Using
The "What's This" Button
Using the Zoom Box
Closing a Database and Exiting Access
Creating and Working with a Database
Planning a Database
Creating a Database Using the Database Wizard
Creating a Blank Database
Creating a Table Using the Table Wizard
Modifying a Table and Understanding Data
Types
Creating a New Table from Scratch
Creating a Query in Design View
Modifying a Query
Sorting a Query using Multiple Fields
Developing AND and OR Operators
Creating a Form with the Form Wizard
Creating a Report with the Report Wizard
Creating Mailing Labels with the Label Wizard
Database Object Management
File Management
Compacting and Repairing a Database
Converting an Access Database
Finding, Filtering, and Formatting Data
Finding and Replacing Information
Sorting Records
Filtering by Selection
Filtering by Form
Creating an Advanced Filter
Adjusting Row Height and Column Width
Rearranging Columns
Changing Gridline and Cell Effects
Freezing a Field
Hiding a Field
Changing the Datasheet Font
Working with Tables and Fields
Understanding Field Properties
Indexing a Field
Adding a Primary Key to a Table
Inserting, Deleting, and Reordering Fields
Changing a Field?s Data Type
Using Field Descriptions
Adding a Caption
Change the Field Size
Formatting Number, Currency, and Date/Time
Fields
Formatting Number, Currency, and Date/Time
Fields by Hand
Formatting Text Fields
Setting a Default Value
Requiring Data Entry
Validating Data
Creating an Input Mask
Creating a Lookup Field
Creating a Value List
Working with Relational Databases
Understanding Table Relationships
Creating Relationships between Tables
Enforcing Referential Integrity
Testing Referential Integrity and Deleting
a Relationship
Understanding of Relationship Types
Working with Queries
A Quick Review
Understanding the Different Types of Queries
Creating a Multiple Table Query
Creating a Calculated Field
Working with Expressions and the Expression
Builder
Using an IIF Function
Summarizing Groups of Records
Using Criteria
Display Top or Bottom Values
Parameter Queries
Finding Duplicate Records
Finding Unmatched Records
Crosstab Queries
Delete Queries
Append Queries
Make Table Queries
Update Queries
Working with Forms
Creating a Form with AutoForm
Modifying a Form
Adding and Deleting Fields
Moving and Sizing Controls
Changing the Tab Order
Working with Control Properties
Control Property Reference
Working with Form Properties
Form and Report Property Reference
Working with Multiple Controls
Adding, Cutting, Copying, and Pasting Controls
Changing a Control's Data Source
Creating a Calculated Control
Changing a Control's Default Value
Using the Control Wizard
Creating a Subform
Modifying and Working with Subforms
Working with Reports
Creating a Report with AutoReport
Modifying a Report
Adding and Deleting Fields
Moving and Sizing Controls
Adjusting Page Margins and Orientation
Adding Page Numbers and Dates
Understanding Report Sections
Grouping and Sorting Records
Creating Calculated Controls
Working with Section Properties
Creating Charts with the Chart Wizard
Formatting Forms and Reports
Formatting Fonts with the Formatting Toolbar
Changing Text Alignment
Using AutoFormat
Changing Colors
Applying Special Effects
Using the Format Painter
Adding Pictures and Lines
Aligning Controls with One Another
Changing a Control?s Formatting Properties
Working with Macros
Creating and Running a Macro
Editing a Macro
Working with Macro Groups
Assigning a Macro to an Event
Creating Conditional Expressions
Assigning a Macro to a Keystroke Combination
Macro Action Reference
Working with Other Programs
Importing Information
Exporting Information
Importing Objects from another Access Database
Linking Information from an External Source
Analyzing Records with Microsoft Excel
Exporting Records to Microsoft Word
Mail Merging Records to Microsoft Word
Using Hyperlink Fields
Using OLE Object Fields~~~6949~6953~~

Access 2000~The Fundamentals
Introduction to Databases
What's New in Access 2000?
Starting Access and Opening a Database
Understanding the Access Program Screen
Using Toolbars
Hiding, Displaying, and Moving Toolbars
Filling Out Dialog Boxes
Keystroke and Right Mouse Button Shortcuts
Opening and Modifying Database Objects
Working with Multiple Windows
Tour of a Table
Adding, Editing, and Deleting Records
Tour of a Form
Tour of a Query
Tour of a Report
Previewing and Printing a Database Object
Selecting Data
Cutting, Copying, and Pasting Data
Using Undo
Checking Your Spelling
Getting Help from the Office Assistant
Changing the Office Assistant and Using the "What's This" Button
Using the Zoom Box
Closing a Database and Exiting Access
Creating and Working with a Database
Planning a Database
Creating a Database Using the Database Wizard
Creating a Blank Database
Creating a Table Using the Table Wizard
Modifying a Table and Understanding Data Types
Creating a New Table from Scratch
Creating a Query in Design View
Modifying a Query
Sorting a Query using Multiple Fields
Developing AND and OR Operators
Creating a Form with the Form Wizard
Creating a Report with the Report Wizard
Creating Mailing Labels with the Label Wizard
Database Object Management
File Management
Compacting and Repairing a Database
Converting an Access 97 Database
Finding, Filtering, and Formatting Data
Finding and Replacing Information
Sorting Records
Filtering by Selection
Filtering by Form
Creating an Advanced Filter
Adjusting Row Height and Column Width
Rearranging Columns
Changing Gridline and Cell Effects
Freezing a Field
Hiding a Column
Changing the Datasheet Font
Working with Tables and Fields
Understanding Field Properties
Indexing a Field
Adding a Primary Key to a Table
Inserting, Deleting, and Reordering Fields
Changing a Field's Data Type
Using Field Descriptions
Adding a Caption
Change the Field Size
Formatting Number, Currency, and Date/Time Fields
Formatting Number, Currency, and Date/Time Fields by Hand
Formatting Text Fields
Setting a Default Value
Requiring Data Entry
Validating Data
Creating an Input Mask
Creating a Lookup Field
Creating a Value List
Modifying a Lookup List
Creating Relational Databases
Understanding Table Relationships
Creating Relationships between Tables
Enforcing Referential Integrity
Testing Referential Integrity and Deleting a Relationship
Understanding of Relationship Types
Working with Queries
A Quick Review
Creating a Multiple Table Query
Creating a Calculated Field
Using Expressions
Using an IIF Function
Summarizing Groups of Records
Using Criteria
Display Top or Bottom Values
Parameter Queries
Finding Duplicate Records
Finding Unmatched Records
Crosstab Queries
Delete Queries
Append Queries
Make Table Queries
Update Queries
Working with Forms
Creating a Form with AutoForm
Modifying a Form
Adding and Deleting Fields
Moving and Sizing Controls
Changing the Tab Order
Working with Control Properties
Control Property Reference
Working with Form Properties
Form and Report Property Reference
Working with Multiple Controls
Adding, Cutting, Copying, and Pasting Controls
Changing a Control's Data Source
Creating a Calculated Control
Changing a Control's Default Value
Using the Control Wizard
Creating a Subform
Modifying and Working with Subforms
Working with Reports
Creating a Report with AutoReport
Modifying a Report
Adding and Deleting Fields
Moving and Sizing Controls
Adjusting Page Margins and Orientation
Adding Page Numbers and Dates
Understanding Report Sections
Grouping and Sorting Records
Creating Calculated Controls
Working with Section Properties
Creating Charts with the Chart Wizard
Formatting Forms and Reports
Formatting Fonts with the Formatting Toolbar
Changing Text Alignment
Using AutoFormat
Changing Colors
Applying Special Effects
Using the Format Painter
Adding Pictures and Lines
Aligning Controls with One Another
Changing a Control's Formatting Properties
Working with Macros
Creating and Running a Macro
Editing a Macro
Working with Macro Groups
Assigning a Macro to an Event
Creating Conditional Expressions
Assigning a Macro to a Keystroke Combination
Macro Action Reference
Using Access with Other Programs
Importing Information
Exporting Information
Importing Objects from another Access Database
Linking Information from an External Source
Analyzing Records with Microsoft Excel
Exporting Records to Microsoft Word
Mail Merging Records to Microsoft Word
Using Hyperlink Fields
Using OLE Object Fields~~~6949~6954~~