Course Code:
WFTR 531
Calendar Description:
Microsoft® Office Access – Level 1 teaches students how to create simple databases, create and modify database objects including tables, forms, reports and queries. You will use a variety of commands, functions, and Microsoft Office Access capabilities. It is designed for computer users who are new to database programs or who only plan to use Access occasionally.
Date First Offered:
2009-03-02
Hours:
Total Hours: 18
Seminars and Tutorials: 18
Total Weeks:
3
This course is offered online:
No
Pre-Requisites:
NONE
Non-Course Pre-Requisites:
This course is designed for students who are familiar with personal computers, using a keyboard and using a mouse. The course assumes that students have experience working in a Microsoft Windows environment.
Co-Requisites:
NONE
Rearticulation Submission:
No
Course Content:
Unit 1: Introducing Access
- Overview
- Looking at the Screen
- Planning a Database
- Creating a Database Using a Template
- Moving Around a Database
- Creating a Blank Database
- Organizing Files
Unit 2: Creating and Modifying Tables
- Creating Tables using Datasheet View
- Moving Around a Table
- Inserting, Deleting and Modifying Data in a Table
- Creating Tables using Table Templates
- Creating Tables Based on Existing Tables
- Creating a Table in Design View
- Modifying Data Types
- Modifying Field Properties
- Adding and Removing Primary Keys
- Adding and Removing Multiple Primary Keys
Unit 3: Manipulating a Table
- Restructuring Tables
- Formatting Tables
- Modifying Tables
- Printing and Distributing Tables
Unit 4: Data Manipulations
- Inserting and Deleting Records
- Importing and Exporting Data
- Finding and Replacing Data
Unit 5: Sorting and Filtering
- Sorting Records
- Filtering Records
Unit 6: Select Queries
- What is a Query?
- Creating a Query using the Wizard
- Creating a Query in Design View
- Saving, Closing and Running Queries
- Adjusting Queries
- Sorting Fields
- Showing and Hiding Fields
- Applying Criteria
- Using Wildcard Characters
- Functions and Calculated Fields
- Changing Field Properties
- Working with Aliases
- Filtering Query Data
Unit 7: Relating Multiple Tables
- Establishing Table Relationships
- Enforced Referential Integrity
- Print Relationships
- Using the Table Analyzer
- Lesson Summary
- Review Questions
Unit 8: Maintaining Databases
- Database Maintenance
- Opening Databases
- Modify Database Options
- Modifying Database Properties
- Using the Database Documenter
- Saving a Database to a Previous Version
- Saving a Database with a Password
- Splitting Databases
Learning Outcomes:
Upon successful completion of this course, the student will be able to:
- Identify parts of the Access screen
- Define fields, data types and tables
- Create a database using templates, create a blank database, open, save and close databases
- Create a table using Datasheet View or Design View
- Insert, delete and modify data in a table
- Add, modify and remove primary key fields
- Insert, modify and delete a field
- Add a total row to a table
- Format, rename and delete tables
- Save database items in a variety of file formats
- Import or export data from or to other applications
- Find and replace data using exact or partial matches, case sensitive and wildcard searches
- Sort and filter data
- Create, save, close, or run a query using the wizard or in Design View
- Create query criteria using comparison, wildcard, AND, OR operators, or calculated fields
- Change queries field properties and apply aliases
Grading System:
Percentage
Passing Grade:
70%
Grading Weight:
Quizzes and Tests: 24 %
Assignments: 21 %
Project: 50 %
Participation: 5 %
Number of Assignments:
7
Nature of Participation:
Attendance
Percentage of Individual Work:
100
Course Offered in Other Programs:
No
Additional Comments:
The project in this course requires a minimum of forty hours to complete and is done outside of class hours.
Completion of this course partially prepares students to write the Microsoft Certified Application Specialist exam. By completing the other levels available for this application students will have reviewed all of the exam objectives.
Text Books:
Required - Microsoft, 2008, Microsoft Office Access 2007, Level 1 - Essential Skills (CCI Learning Solutions Inc.). Chapters Covered: AllAdd Content...