Access Advanced 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 2007. 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 & Intermediate 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
Querying with SQL
- SQL & Access
- Writing SQL Statements
- Attaching SQL Queries to Controls
Advanced Queries
- Creating Crosstab Queries
- Creating Parameter Queries
- Using Action Queries
Macros
- Creating, Running and Modifying Macros
- Attaching Macros to the events of the Database
Advanced Macros
- Creating Macros to Prevent User Interaction
- Creating Macros that Require User Input
- Creating the AutoKeys & AutoExec Macros
- Creating Macros for Data Transfer
Importing, Exporting and Linking Objects
- Importing Objects
- Exporting Objects
- Interacting with the XML Documents
- Linking Access Objects
- Working with Windows SharePoint Services
Database Management
- Optimizing Resources
- Replicating and Synchronizing Databases
Security Fundamentals
- Protecting Databases
- Encrypting & Decrypting Databases
- User-level Security.
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.