Support

Thank you from doMore

I'd like to thank you for being involved in the doMore.com.au community and the team and I hope that you've received value from being a part of it.

doMore was our original passion project born out of the desire to help connect people wanting to learn something new with experts that could teach them over 10 years ago.

Over the years we have helped almost 70,000 learners connect with one of over 1,500 courses and providers, across the country. For that, we're very proud and grateful for your contribution.

doMore.com.au also served to teach us about how to help measure and improve business performance and inspired the launch and growth of two other companies as a result, one of which we've decided to dedicate our resources and energy to making great.

We'll be switching the site off on Tuesday 31st of July. If you have any questions or concerns, please contact us directly on [email protected].

Thanks again and good luck with your teaching endeavours in the future.

Warm regards,

The doMore team.


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

Crystal Reports 11 Advanced Training
Crystal Reports 11 Advanced Training
1 session available for $1,050.00
Microsoft PowerPoint 2010 Advanced
Microsoft PowerPoint 2010 Advanced
3 sessions available starting from $390.00
Microsoft Project 2010 Introduction
Microsoft Project 2010 Introduction
2 sessions available starting from $780.00

see all listings »


Found In