strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.

strict warning: Declaration of views_handler_argument::options_validate() should be compatible with views_handler::options_validate($form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_argument.inc on line 917.

strict warning: Declaration of views_handler_argument::query() should be compatible with views_handler::query($group_by = false) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_argument.inc on line 917.

strict warning: Declaration of views_handler_sort::options_validate() should be compatible with views_handler::options_validate($form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_sort.inc on line 165.

strict warning: Declaration of views_handler_sort::options_submit() should be compatible with views_handler::options_submit($form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_sort.inc on line 165.

strict warning: Declaration of views_handler_sort::query() should be compatible with views_handler::query($group_by = false) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_sort.inc on line 165.

strict warning: Declaration of views_handler_filter::options_validate() should be compatible with views_handler::options_validate($form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_filter.inc on line 587.

strict warning: Declaration of views_handler_filter::query() should be compatible with views_handler::query($group_by = false) in /home3/indiciat/public_html/sites/all/modules/views/handlers/views_handler_filter.inc on line 587.

strict warning: Declaration of views_handler_filter_node_status::operator_form() should be compatible with views_handler_filter::operator_form(&$form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/modules/node/views_handler_filter_node_status.inc on line 13.

strict warning: Declaration of views_plugin_argument_validate::options_submit() should be compatible with views_plugin::options_submit($form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/plugins/views_plugin_argument_validate.inc on line 87.

strict warning: Declaration of views_plugin_argument_validate_taxonomy_term::options_submit() should be compatible with views_plugin_argument_validate::options_submit(&$form, &$form_state) in /home3/indiciat/public_html/sites/all/modules/views/modules/taxonomy/views_plugin_argument_validate_taxonomy_term.inc on line 165.

strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.

strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.

strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.

strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.

strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.

strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.

strict warning: Non-static method view::load() should not be called statically in /home3/indiciat/public_html/sites/all/modules/views/views.module on line 1113.

warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.

warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.

warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.

warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.

warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.

warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.

warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.

warning: preg_replace(): Compilation failed: invalid range in character class at offset 11 in /home3/indiciat/public_html/sites/all/themes/indiciatraining/template.php on line 170.

In this course you will consider how to design and create a new Access database, how to customise database components, and how to share Access data with other applications.

This course is available on our new V-Learning platform or as an onsite/closed event. Please call for details.

MicrosoftAccess 2003 Level 2

Duration

1 day

Course Overview

As you begin this course, you should have the basic skills you need to work with a Microsoft Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. But thus far you have been focusing on essential database user skills only. In this course you will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other applications.This course is available on our new V-Learning platform or as an onsite/closed event. Please call for details.

Course Objectives

You will design and create a new Access database; improve queries, forms, and reports; and integrate Microsoft Office Access 2003 with other applications.

Target Audience

Microsoft Access 2003: Level 2 is designed for the student who wishes to learn intermediate-level operations of the Microsoft Access program. The Level 2 course is for the individual whose job responsibilities include creating new databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces the student to integrating Access data with other applications such as Microsoft Word or Excel. This course is also designed for students pursuing the Microsoft Office Specialist Certification for Access 2003, and it is a prerequisite to taking more advanced courses in Access 2003.

Course Contents

Reports

Purpose of a Report

Creating a Report

Creating an Autoreport

Amending Report Design

Subforms

Using the Subform Wizard

Using an Existing Form as a Subform

Using the Form Wizard

Enhancing Form Presentation

Adding and Deleting Controls

Adding Text Labels

Changing Properties

Tab Order

Adding Command Buttons

Action Queries

Make Table Query

Calculated Fields in Queries

Using the Expression Builder

Parameter Queries

Please call 0141 221 5676 for course information and available dates or email us at info@indiciatraining.com.