You’ve covered many of the basic functions of Microsoft® Office Access® and now you’re ready to learn advanced Access features such as, database management, advanced form design, packaging a database, encrypting a ...You’ve covered many of the basic functions of Microsoft® Office Access® and now you’re ready to learn advanced Access features such as, database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access and more. Knowledge of these features separate database professionals from the casual database users or occasional designers. Today’s training added to that which you’ve gained from the previous two days round out your Access education and provide you with marketable job skills. You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Access 2010.Show MoreCourse Prerequisites:
Computer Literacy Add to CartRequest a Quote
Instructor-Led Training (ILT)
Attend training in a classroom environment at a campus near you. Instructor-led training is still the number one delivery method of choice because it allows you to interact and discuss the training material, either individually or in a group setting, and you gain access to expert knowledge from certified instructors. This form of guided learning is impactful and produces positive learning outcomes. Day, evening and Saturday classes are offered.
Course Price (ILT) R1,196.00
* incl. VAT
Duration 1 Day
Upcoming dates for MOS: Microsoft Office Access 2010 Intermediate
Hang on... we're fetching some dates from the Course Schedule.
77-885 MOS: Microsoft Office Access 2010 Intermediate
Duration: 1 Day
Lesson 1: Designing a Relational Database
Topic A: Relational Database Design
Topic B: Create a Table
Topic C: Create Table Relationships
Lesson 2: Joining Tables
Topic A: Create Query Joins
Topic B: Join Tables That Have No Common Fields
Topic C: Relate Data within a Table
Topic D: Work with Subdatasheets
Topic E: Create Subqueries
Lesson 3: Organizing a Database for Efficiency
Topic A: Data Normalization
Topic B: Create a Junction Table
Topic C: Improve Table Structure
Lesson 4: Sharing Data Across Applications
Topic A: Import Data into Access
Topic B: Export Data to Text File Formats
Topic C: Export Access Data to Excel
Topic D: Create a Mail Merge
Lesson 5: Advanced Reporting
Topic A: Organize Report Information
Topic B: Format Reports
Topic C: Include Charts in a Report
Topic D: Add a Calculated Field to a Report
Topic E: Add a Subreport to an Existing Report
CTU Training Solutions, Updated: April 24th, 2018
Share with friends
Request a Quote
The course information above is subject to change without notification due to market trends in the industry, legislation and/or programme version updates.
Terms and Conditions
Refer a friend
Save 23% when you register for the Cisco CCNA Routing and Switching (CCNAX) course at CTU, or share it with a friend and get 5% on your course of choice!
Either way you win!
Join the CTU community
Join the CTU Community Portal and gain access to superior resources.