Access Intermediate 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 and should have completed the Access Basic Training.
Who Should Attend
This course is targeted at those training or trained in Office administration, small business owners and those who wish to improve already existing databases.
Course Outline
Relational Databases
- Database Normalization
- Relating Tables
- Implementing Referential Integrity
Working with related tables
- Lookup Fields
- Modifying Lookup Fields
- Subdatasheets
Complex Queries
- Joining Tables in Queries
- Creating Calculated Fields
- Summarizing and Grouping Values
Advanced Form Design
- Adding unbound Controls
- Graphics
- Adding Calculated Values
- Adding Combo Boxes
Advanced Reports
- Creating Customized Headers & Footers
- Adding Calculated Values
- Subreports
Charts
- Charts in Forms
- Charts in Reports
PivotTables & PivotCharts
- PivotTables
- Modifying PivotCharts
- PivotCharts
Internet Integration
- Hyperlink Fields
- Working with Data Access Pages
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.