MS Access - Level I, ITI-153
Course Description Summer 2014: (Click here for Fall 2014 Description) Learn how to design and create databases. Learn to create table relationships to efficiently retrieve data from multiple tables and learn how to sort and modify table data. Create queries to find and locate data by using query criteria, design forms to manipulate data, and develop reports to display data in attractive and useful layouts.
This course uses a curriculum to prepare for the Microsoft Office Specialist exam for Access 2010 (exam 77-885). For comprehensive certification training, you should complete MS Access Level I, II, and III.
Prerequisites : Computer Basics, and Working with Windows, or File Management Skills.
Classroom Hours: 12
Textbook: Please bring your textbook to the first class session. See MC Bookstores for more information on your textbook, bring to first class along with a USB Flash Drive/memory stick (at least 512 MB).
Table Of Contents:
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
MS- ACCESS –LEVEL I
Fall 2014 Course Descrption: This course covers the basic features and functions of Access 2013. After an introduction to database concepts, the Access environment, and Help systems, learn how to design and create databases. Work with tables, fields, and records; sort and filter data; and set field properties and data entry rules. Finally, create basic queries, forms, and reports. This course follows the curriculum for the Microsoft Office Specialist core-level for Access 2013 (exam 77-424). For comprehensive certification training, students should complete MS Access Levels I, II, III. Prerequisites: Computer Basics, Working with Windows or File Management Skills or equivalent experience.
Textbook: Please bring your textbook to the first class session. See MC Bookstores for more information on your textbook; bring to first class along with a USB Flash Drive/memory stick (at least 512 MB).
Course Objective: After completing this course, students will know how to:
- Organize data efficiently by using a database management system; start Access, open Access databases and identify components of the Access window; and use the Help feature.
- Plan and create a database; use Datasheet view and Design view; create, modify, and work in tables; and set the primary key for a table.
- Modify a table’s design; use the Attachment data type; find and replace values; and sort, filter, and delete records.
- Set field properties; create input masks; and set validation rules.
- Create queries, and sort and filter the results; modify queries; and perform operations in queries.
- Create, modify, and work forms; and use them to sort and filter records.
- Create, modify, and print reports; and add summary fields to a report.