Microsoft Access (Beginner)

This course is designed for those that want to learn Access from the start or refresh a basic knowledge of the program. Even with some familiarity with Microsoft Access, there is always something new to be learned from our Access Beginning course.

Course Outline:

• Create a New Blank Database 
• Add Records to a Table 
• Rename Table Fields in Datasheet View
• Modify the Design of a Table
• Add a Second Table to a Database
• Create and Use a Query, Form, and Report 
• Create a Database Using a Template
• Organize Database Objects in the Navigation Pane
• View a Report and Print a Table in a Database Created with a Template
• Create Table Relationships 
• Sort Records in a Table
• Create a Query in Design View
• Create a New Query from an Existing Query
• Sort Query Results
• Specify Criteria in a Query
• Importing an Excel Spreadsheet
• Specify Numeric Criteria in a Query
• Use Compound Criteria
• Create a Query Based on More Than One Table
• Use Wildcards in a Query
• Use Calculated Fields in a Query
• Group Data and Calculate Statistics in a Query
• Create a Form
• Use a Form to Add and Delete Records
• Create a Form by Using the Form Wizard
• Modify a Form in Design View and in Layout View
• Filter Records
• Create a Report by Using the Report Tool , Blank Report tool and Wizard
• Modify the Design of a Report
• Print a Report and Keep Data Together