Information Technology

Access 2013 - Level 1

Instructor-Led 7 Agenda

Description

Students 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.

Course Overview

Students 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.

Getting Started Lesson Id 1

Getting Started

Databases and Tables Lesson Id 2

Databases and Tables

Fields and Records Lesson Id 3

Fields and Records

Data Entry Rules Lesson Id 4

Data Entry Rules

Basic Queries Lesson Id 5

Basic Queries

Using Forms Lesson Id 6

Using Forms

Working With Reports Lesson Id 7

Working With Reports

Lesson Id	Title	Description
1	Getting Started	Database Concepts<br />Exploring the Access environment
2	Databases and Tables	Planning and designing databases<br />Exploring tables<br />Creating tables
3	Fields and Records	Changing the design of a table<br />Finding and editing records<br />Organizing records
4	Data Entry Rules	Setting field properties<br />Working with input masks<br />Setting validation rules
5	Basic Queries	Creating and using queries<br />Modifying query results and queries<br />Performing operations in queries
6	Using Forms	Creating forms<br />Using Design view<br />Sorting and filtering records
7	Working With Reports	Creating reports<br />Modifying and printing reports