This MS Access course was developed to master the all functions (Beginners to Intermediate Levels) and featers of MS Access Versions 2003, 2007, 2010 or
2013. In order to successfully master MS Access, Windows Beginners must have been completed.
COURSE REQUIREMENTS - THE USER MUST BE CONFIDENT WITH AT LEAST 80% OF THE COURSE MATERIAL FROM THE WINDOWS BEGINNERS
COURSE.
VERSIONS: 2007-2010-2013
Starting Access
Opening an Existing Database
Using Database Objects
Opening a Database Object
Closing a Database Object
Closing a Database
Opening an Existing Database
Using Database Objects
Opening a Database Object
Closing a Database Object
Closing a Database
Changing Row Height
Changing Column Width
Changing Font Attribute
Changing a Cell Effect
Selecting a Column
Moving a Column
Hiding a Column
Unhiding a Column
Freezing a Column
Changing Column Width
Changing Font Attribute
Changing a Cell Effect
Selecting a Column
Moving a Column
Hiding a Column
Unhiding a Column
Freezing a Column
Creating a Blank Database
Designing Tables
Creating a Table in Design View
Using the Table Design Window
Adding Field Names
Assigning Data Types
Adding Field Descriptions
Setting a Primary Key
Saving a New Table
Using the Table Wizard
Designing Tables
Creating a Table in Design View
Using the Table Design Window
Adding Field Names
Assigning Data Types
Adding Field Descriptions
Setting a Primary Key
Saving a New Table
Using the Table Wizard
Sorting Records
Finding Specific Records
Finding Data using Wildcards
Using Replace
Using Filter by Selection
Applying/removing a Filter
Using filter Excluding Selection
Using the Filter for Feature
Finding Specific Records
Finding Data using Wildcards
Using Replace
Using Filter by Selection
Applying/removing a Filter
Using filter Excluding Selection
Using the Filter for Feature
Using Datasheet View
Navigating Fields in Tables
Adding Records
Moving through Records
Selecting Records
Editing Records
Saving Records
Deleting Records
Navigating Fields in Tables
Adding Records
Moving through Records
Selecting Records
Editing Records
Saving Records
Deleting Records
Using Queries
Creating a Query - Design View
Opening a Query
Adding a Table to a Query
Running a Query
Modifying Query Results
Sorting a Query
Adding Criteria to a Query
Hiding a Field in a Query
Printing a Query
Using Comparison Operators
Using a Wildcard Character
Creating a calculated field
Creating a parameter query
Creating a Query - Design View
Opening a Query
Adding a Table to a Query
Running a Query
Modifying Query Results
Sorting a Query
Adding Criteria to a Query
Hiding a Field in a Query
Printing a Query
Using Comparison Operators
Using a Wildcard Character
Creating a calculated field
Creating a parameter query
Using Reports
Using the Report Wizard
Using Print Preview
Printing pages of a Report
Basing a Report on a Query
Using AutoReport
Using the label wizard
Grouping data in a report
Creating a header for each group
Using the Report Wizard
Using Print Preview
Printing pages of a Report
Basing a Report on a Query
Using AutoReport
Using the label wizard
Grouping data in a report
Creating a header for each group
Creating Relationships
Setting Referential Integrity
Adding a Table to the Window
Setting Referential Integrity
Adding a Table to the Window
Using Field Properties
Limiting Field Size
Setting Number Formats
Setting Date/Time Formats
Setting Default Values
Required Fields
Setting Validation Rules
Input Masks
Inserting a Lookup Field
Limiting Field Size
Setting Number Formats
Setting Date/Time Formats
Setting Default Values
Required Fields
Setting Validation Rules
Input Masks
Inserting a Lookup Field
ACCREDITED