Access 2013 Basic Skills

In this course, students will learn how to use Access 2013 to manage data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

In this course, students will learn how to use Access 2013 to manage data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

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 tab les
• 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