Access 2010 - Part 2

Displaying courses for United States [Change]
This course provides material for:
Microsoft Exam code: 77-885
Certificate: Microsoft Office Specialist on Microsoft Office 2010

Overview

Students will expand their knowledge of Microsoft® Access® 2010 to include relational database design, writing advanced queries, structuring existing data, sharing data across applications, and customizing reports.

Audience

This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Access with other programs.

Syllabus

Advanced Form Design

  • Adding Controls to Forms
  • Creating Subforms
  • Organizing Information with Tab Pages
  • Displaying a Summary of Data in a Form
  • Applying Conditional Formatting

Data Validation

  • Field and Record Validation
  • Form Validation

Using Macros to Improve User Interface Design

  • Creating a Macro
  • Restricting Records Using a Condition
  • Validating Data Using a Macro
  • Automating Data Entry Using a Macro
  • Converting a Macro to VBA

Advanced Database Management

  • Linking Tables to External Data Sources
  • Managing a Database
  • Determining Object Dependency
  • Documenting a Database
  • Analyzing the Performance of a Database

Distributing and Securing a Database

  • Preparing a Database for Multiple User Access
  • Implementing Security
  • Setting Passwords
  • Converting an Access Database to an ACCDE File
  • Packaging a Database with a Digital Signature

Managing Switchboards

  • Creating a Database Switchboard
  • Modifying a Database Switchboard
  • Setting Startup Options

Training provider

Teaching mode:
Online - Self paced
Classroom - Instructor Led
Online - Instructor Led
Duration: 2 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Visual Basic for Applications
United States
This skill has an average salary of
US$82,795
and is mentioned in
0.44%
of job ads in this area.
Database
United States
This skill has an average salary of
US$78,579
and is mentioned in
13.91%
of job ads in this area.