XCOA 1000 - Access 2010 Fundamentals
Cover the basic functions and features of Access 2010. After an introduction to database concepts and the Access environment and Help systems, students will design and create databases. They will work with tables, fields, and records; sort and filter data; and set field properties and data entry rules. Students will then create basic queries, forms, and reports. This class can also be taken as part of the Access Specialist Certificate. For details visit our web page.Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Comfortable using Windows, keyboard, and mouse.
CEU Hours: .7
Contact Hours: 7
Access Fundamentals outline: 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
|53443 020||--W----||08:00-03:59 PM||09/03/14-09/03/14||RC 254||Tuck L||5 of 14|
Enroll for $189.00