Microsoft Access 2010: Comprehensive(ITSC1004)

This instructor-led training course covers the basic and intermediate functions and features of Access 2010. After an introduction to database concepts and the Access environment and Help systems, the course will cover subjects such as how to design and create databases. Topics include: tables, fields, and records; sort and filter data; and set field properties and data entry rules. In addition, the course covers how to create queries, forms, and reports.

Instructor:

{slide=Table of Contents|green|closed}

Unit 1: Getting started

Topic A: Database concepts

Topic B: Exploring the Access environment

Topic C: Getting help

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

{/slides}

XA01141Q

Nov 8 - 15

8:00 am - 6:00 pm

Sat

$169.00 ($174.00 out-of-state)

ATC

16.0 Hours

Course Canceled!

For more information about courses and programs, please call (432) 681-6335.

Midland College is accredited by the Commission on Colleges of the Southern Association of Colleges and Schools to award certificates and associate and baccalaureate degrees. Contact the Commission on Colleges at 1866 Southern Lane, Decatur, Georgia 30033-4097 or call 404-679-4501 for questions about the status of Midland College.