Support

MS Access 02 / 03 Introduction

2 sessions available starting from $780.00

Subject: Microsoft Access

Ages: All ages

Skill level: All difficulty levels

TARGET AUDIENCE & PURPOSE

This Access Introduction Course is for people new to databases, and for self-taught users to enhance their knowledge. It is a pre-requisite for the Intermediate and Advanced courses.

OBJECTIVES

By the end of this course participants should be able to:

* Design and create a database
* Create tables and set the primary key
* Define the fields and properties for a table
* Enter data and modify the layout of a table
* Find data in tables
* Create queries
* Create table relationships
* Design and create forms and reports
* Print reports

PREREQUISITES

Participants should already be competent in using a mouse and keyboard and have an understanding of Windows.

COURSE CONTENT

* Exploring Access
Using Menu Commands, Displaying & Hiding Toolbars...

see more

TARGET AUDIENCE & PURPOSE

This Access Introduction Course is for people new to databases, and for self-taught users to enhance their knowledge. It is a pre-requisite for the Intermediate and Advanced courses.

OBJECTIVES

By the end of this course participants should be able to:

* Design and create a database
* Create tables and set the primary key
* Define the fields and properties for a table
* Enter data and modify the layout of a table
* Find data in tables
* Create queries
* Create table relationships
* Design and create forms and reports
* Print reports

PREREQUISITES

Participants should already be competent in using a mouse and keyboard and have an understanding of Windows.

COURSE CONTENT

* Exploring Access
Using Menu Commands, Displaying & Hiding Toolbars, Changing Menu & Toolbar Options, Using Database Objects, Using the Database Window, Opening a Database Object, Using the Task Pane

* Creating Tables
Using the Database Wizard, Creating a New Database, Designing Tables, Creating a Table in Design View, Using Design View, Adding Field Names, Assigning Data Types, Adding a Field Description, Setting a Primary Key, Saving a New Table, Using the Table Wizard

* Working with Tables
Using Datasheet View, Navigating Fields in Tables, Adding Records, Moving through Records, Selecting Records, Saving Records

* Editing Tables
Changing the Row Height, Changing the Column Width, Changing a Font Attribute, Changing a Cell Effect, Selecting a Column, Moving a Column, Hiding a Column, Unhiding a Column, Freezing a Column

* Finding & Filtering Data
Sorting Records, Finding Specific Records, Finding Records using Wildcards, Using Replace, Using Filter By Selection, Applying / Removing a Filter, Using Filter Excluding Selection, Using Filter For

* Printing Data
Changing Page Setup, Using Print Preview, Printing Selected Records

* Creating Relationships
Using Related Tables, Creating a Relationship between Tables, Setting Referential Integrity, Viewing Subdatasheets, Deleting a Join Line

* Using Simple Queries
Using Queries & Recordsets, Creating a Query in Design View, Adding a Table to a Query, Joining Tables in a Query, Running a Query

* Modifying Query Results
Sorting a Query, Adding Criteria to a Query, Hiding a Field in a Query, Adding a Record using a Query, Printing a Query

* Creating Basic Forms
Using Forms, Using the Form Wizard, Viewing Records in a Form, Printing Records in a Form, Basing a Form on a Query, Using AutoForm, Adding a Record using a Form

* Creating Basic Reports
Using Print Preview, Printing Pages of a Report, Grouping & Summarizing, Basing a Report on a Query, Using AutoReport

* Modifying Tables
Inserting a Column into a Table, Inserting a Lookup Column, Inserting a Hyperlink Column, Creating a Many-to-Many Relationship

* Setting Field Properties
Limiting Field Size, Setting Number Formats, Setting Date/Time Formats, Setting Yes/No Formats, Setting Default Values, Setting Validation Rules, Creating an Input Mask – Wizard, Creating an Input Mask Manually, Creating a Custom Input Mask, Typing a Lookup List, Modifying Lookup Properties

* Using Operators in Queries
Using Comparison Operators, Using an And Condition, Using an Or Condition, Using the Between And Operator, Using a Wildcard Character

* Designing Advanced Queries
Setting Top Values in a Query, Creating a Calculated Field, Formatting a Calculated Field, Creating a Function Query, Creating a Parameter Query, Creating a Concatenation in a Query, Filtering a Query

* Using Advanced Query Wizards
Using the Crosstab Query Wizard, Find Duplicates Query Wizard, Find Unmatched Query Wizard

* Manipulating Controls
Using Controls, Selecting Non-adjacent Controls, Selecting Adjacent Controls, Deleting & Moving Controls, Sizing a Control by Dragging, Sizing Controls Automatically, Changing a Control Property

* Using Design View
Hiding the Ruler, Disabling the Snap to Grid Feature, Displaying the Field List, Adding a Field, Moving Part of a Paired Control, Aligning Controls Spacing Controls, Using the Toolbox, Adding a Label, Image, Rectangle, Line, Editing an Unbound Control, Using Undo/Redo in Design View

* Using Editing Tools
Selecting Objects with the Toolbar, Changing the Font, Font Size, Character Format, Font Colour, Fill & Background Colours, Formatting Lines & Borders, Applying Special Effects, Using the Format Painter Using AutoFormat, Setting AutoCorrect Options

* Using Advanced Form Design
(Time Permitting)
Using Forms in Design View, Creating a Combo Box, List Box, Option Group, Adding a Logic Control, Setting the Tab Order, Adding a Form Header & Footer, Creating a Blank Form

* Using Advanced Report Design
(Time Permitting)
Adding Report Sections in Design View, Creating a Calculated Control, Grouping Data in a Report, Creating Group Headers & Footers, Creating a Running Summary, Inserting a Date/Time Control & Page Break, Changing the Report Margins, Using the Label Wizard

Duration: Two Days

see less

Choose from 2 available sessions:

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 83 York St
    Sydney, NSW 2000

Price: $780.00

Notes: Course Inclusions * Comprehensive learning materials incl. exercise... see more

Notes:

Course Inclusions

* Comprehensive learning materials incl. exercise files
* 12 months post course telephone support
* 'Certificate of Attendance'
on completion of course
* Light lunch plus morning & afternoon tea

see less

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 83 York St
    Sydney, NSW 2000

Price: $780.00

Notes: Course Inclusions * Comprehensive learning materials incl. exercise... see more

Notes:

Course Inclusions

* Comprehensive learning materials incl. exercise files
* 12 months post course telephone support
* 'Certificate of Attendance'
on completion of course
* Light lunch plus morning & afternoon tea

see less

Type

  • Class / Group Sessions



My Other Listings

MS Access 2007 Introduction
MS Access 2007 Introduction
2 sessions available starting from $780.00
Introduction to Excel 2010
Introduction to Excel 2010
2 sessions available starting from $780.00
Microsoft Outlook 2002 / 2003 Advanced
Microsoft Outlook 2002 / 2003 Advanced
1 session available for $390.00

see all listings »


Found In