Corporate Training By Zack Academy - Access 2013 - Basic

Why Should You Take This Access 2013: Basic Course?

This ILT Series course covers the basic skills and concepts students need to use Microsoft Access 2013 productively and efficiently. After an introduction to the Access 2013 environment, students will learn how to plan databases and create tables. Then they will learn to organize fields and records, and to work with data entry rules. They will learn how to create basic queries, and how to work with forms and reports. This course will help students prepare for the Microsoft Office Specialist exam for Access 2013 (exam 77-424). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Access 2013.

Taking this course will give you the skills necessary to effectively and efficiently:

• Create and manage a database
• Build tables
• Create queries 
• Create forms
• Create reports

The Following Topics Will Be Covered:

1.  Getting Started:

• Topic A: Database Concepts
• Topic B: Exploring the Access environment

2.  Databases and Tables:

• Topic A: Planning and designing databases
• Topic B: Exploring tables
• Topic C: Creating tables

3.  Fields and Records:

• Topic A: Changing the design of a table
• Topic B: Finding and editing records
• Topic C: Organizing records

4.  Data Entry Rules:

• Topic A: Setting field properties
• Topic B: Working with input masks
• Topic C: Setting validation rules

5.  Basic Queries:

• Topic A: Creating and using queries
• Topic B: Modifying query results and queries
• Topic C: Performing operations in queries

6.  Using Forms:

• Topic A: Creating forms
• Topic B: Using Design view
• Topic C: Sorting and filtering records

7.  Working with Reports:

• Topic A: Creating reports
• Topic B: Modifying and printing reports

Syllabus

Unit 1: Getting Started:

• Topic A: Database Concepts
• Topic B: Exploring the Access environment

Unit 2: Databases and Tables:

• Topic A: Planning and designing databases
• Topic B: Exploring tables
• Topic C: Creating tables

Unit 3: Fields and Records:

• Topic A: Changing the design of a table
• Topic B: Finding and editing records
• Topic C: Organizing records

Unit 4: Data Entry Rules:

• Topic A: Setting field properties
• Topic B: Working with input masks
• Topic C: Setting validation rules

Unit 5: Basic Queries:

• Topic A: Creating and using queries
• Topic B: Modifying query results and queries
• Topic C: Performing operations in queries

Unit 6: Using Forms:

• Topic A: Creating forms
• Topic B: Using Design view
• Topic C: Sorting and filtering records

Unit 7: Working with Reports:

• Topic A: Creating reports
• Topic B: Modifying and printing reports