Access Basic 2007
Description
Access 2007 can strengthen your data organization capabilities for powerful results no matter what business you’re in. This course will arm you with practical knowledge and demonstrate the powerful features of Access 2003. After attending the course, delegates should understand the concepts of relational database design, be able to build and modify a database and use the query and report features to obtain information from the database.
Entrance Requirements
Those who wish to attend this course should be knowledgeable with the Windows operating system.
Who Should Attend
This course is targeted at those training or trained in Office administration and/or small business owners.
Course Outline
Getting Started
- Database Concepts
- Exploring the Access Environment
- Getting Help
- Closing the Database & Access
Databases & Tables
- Planning & Designing Databases
- Exploring Tables
- Creating Tables
Fields & Records
- Changing the Design of a Table
- Finding & Editing Records
- Oganizing Records
Data Entry Rules
- Setting Field Properties
- Working with Input Masks
- Setting Validation Rules
- Using Indexes
Simple Queries
- Creating & Using Queries
- Modifying Query Results & Queries
- Performing Operations in Queries
- Using Indexes
Using Forms
- Creating Forms
- Using the Form Wizard
- Using Design View
- Finding, Sorting & Filtering Records
Working with Reports
- Creating Reports
- Modifying & Printing Reports
Examinations and Assessments
Learners write the CCS IT examination, the pass mark for which is 70%. Learners may elect to write the International Microsoft examinations at CCS’s Authorized Prometric Testing Centre. The costs for International exams are not included in the course fees.
Learning Materials
All standard learning materials are included in the course fee.
Links and Further Information
Duration and Times
We run this course as both full time (1 day) and part time (2 evenings) course. Contact us for current starting dates and times.