|
|
MICROSOFT ACCESS - BASIC
MS Access – Basic covers the basic functions and features of Access
2007. Students will learn how to design and create databases; work
with tables, fields, and records; sort and filter data; and create queries,
forms, and reports.
|
NEXT COURSE START DATES
| Contact us for Next Start Date |
Pre-Requisites: COMPUTER FUNDAMENTALS & MICROSOFT OFFICE APPLICATIONS
Course Overview
Getting started
- Topic A: Database concepts
- Topic B: Exploring the Access environment
- Topic C: Getting help
|
|
Databases and Tables
- Topic A: Planning and designing databases
- Topic B: Exploring tables
- Topic C: Creating tables
|
|
Fields and Records
- Topic A: Changing the design of a table
- Topic B: Finding and editing records
- Topic C: Organizing records
|
|
Data Entry Rules
- Topic A: Setting field properties
- Topic B: Working with input masks
- Topic C: Setting validation rules
|
|
Basic Queries
- Topic A: Creating and using queries
- Topic B: Modifying query results and queries
- Topic C: Performing operations in queries
|
|
Using Forms
- Topic A: Creating forms
- Topic B: Using Design view
- Topic C: Sorting and filtering records Access
2007: Basic Topic-Level Outline
|
|
Working with Reports
- Topic A: Reports
- Topic B: Modifying and printing reports
|
|
|
|