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 2007 Introduction

Sydney, NSW

Subject: Microsoft Access

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...

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
Start Access, Open & Close a Database, Use the Ribbon, Use the Contextual Tabs, Use Toolbar, Use Database Objects, Use Navigation Pane, Open a Database Object, Use & Close All Tabbed Documents, Use the Status Bar, Use the Options Dialog Box, Exit Access

* Creating Tables
Use Database Templates, Create a Database, Design Tables, Create a Table in Datasheet View, Create a Table in Design View, Add Field Names, Assign Data Types, Save a Table, Add a Field Description, Set a Primary Key, Use Multi-valued Fields

* Working with Tables
Use Datasheet View, Navigate Fields in Tables, Add & Move through Records, Select, Editing, Save, Delete Records

* Editing Tables
Change Row Height & Column Width, Change Font Attribute, Change Cell Effect, Use Alternate Background Colors, Select, Move, Hide, Unhide & Freeze a Column

* Finding & Filtering Data
Sort Records, Find Specific Records, Find Records using Wildcards, Use Replace, Use Filter By Selection, Apply/Remove a Filter, Use Filter Exclude Selection, Use the Search Box, Use Quick Filter, Use AutoFilter

* Printing Data
Change Page Setup, Use Print Preview, Print Selected Records

* Creating Relationships
Use Related Tables, Create a Relationship between Tables, Set Referential Integrity, View Subdatasheets, Delete a Join Line

* Using Simple Queries
Use Queries & Recordsets, Simple Query Wizard, Create Query in Design View, Open a Query, Add a Table, Join Tables, Run a Query

* Modifying Query Results
Sort a Query, Add Criteria to a Query, Hide a Field in a Query, Display a Totals Row in a Query, Add a Record using a Query, Print a Query

* Creating Basic Forms
Use Form Button, Add a Record using a Form, Use the Calendar for Date Picking, Use the Form Wizard, View Records in a Form, Print Records in a Form, Base a Form on a Query

* Creating Basic Reports
Use Report Button, Use Print Preview, Print Pages of a Report, Report Wizard, Change Views in a Report, Group & Summarize Report Data, Base a Report on a Query

* Modifying Tables
Insert a Column into a Table, Insert a Lookup Column, Insert a Hyperlink Column, Create a Many-to-Many Relationship

* Setting Field Properties
Limit Field Size, Set Number Formats, Set Date/Time Formats, Setting Yes/No Formats, Set Default Values, Set Validation Rules, Create an Input Mask – Wizard, Create an Input Mask Manually, Create a Custom Input Mask, Lookup List, Modify Lookup Properties

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

* Designing Advanced Queries
Set Top Values in a Query, Create a Calculated Field, Format a Calculated Field, Create a Function Query, Create a Parameter Query, Multivalued Fields, Create a Concatenation in a Query, Filter a Query

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

* Manipulating Form Controls in Design View
Select, Delete, Size Controls, Set Control Margins & Padding, Hide the Ruler, Disable Snap to Grid Feature, Display Field List, Add a Field, Move Part of a Paired Control, Align & Space Controls

* Using Design View
Add a Label, Add an Image, Add a Rectangle, Add a Line, Edit an Unbound Control, Use Multiple Undo/Redo in Design View

* Using Editing Tools
Change the Font, Change Character Format, Change Fill & Background Colors, Format Lines & Borders, Apply Special Effects, Conditional Formatting, Use Format Painter, Use AutoFormat, Use Error Checking, Run Spelling Checker, Set AutoCorrect Options, Add AutoCorrect Entries

* Using Advanced Form Design
Use Forms in Design View, Create a Combo Box, Edite List Items, Create a List Box, Create an Option Group, Add a Logic Control, Set the Tab Order Automatically, Set the Tab Order Manually, Add a Form Header & Footer, Create a Blank Form

* Using Advanced Report Design
(Time Permitting)
Add Report Sections in Design View, Create a Calculated Control, Create a Running Summary, Insert a Date/Time Control, Insert a Page Break, Chang the Report Margins, Use the Label Wizard, Create a Report without Using a Wizard

Duration: Two Days

see less

When

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

Where

83 York St
Sydney, NSW 2000

Type

  • Class / Group Sessions

Price: $780.00

 

Notes:

Course Inclusions

* Comprehensive learning materials incl. exercise files
* 12...

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


The teachers

COMPUTER TRAINING with Forrest

With over 15 years experience providing Computer Training solutions Australia wide...

see more

COMPUTER TRAINING with Forrest

With over 15 years experience providing Computer Training solutions Australia wide, you can be assured that whatever your requirements, we can deliver solutions to meet them. Ensuring your specific learning needs are met is our number one priority.

Microsoft Office Training is our specialty however, we provide a full range of learning solutions including courses in non-Microsoft software such as Prince2, Crystal Reports and InfoPath to name but a few. Our Professional Development Courses are also very popular and can provide you with key business skills to give you the edge over your competition.

Our modern training rooms are equipped with data projectors, networked DualCore Pentium computers, fast Internet access and 19" LCD monitors.

Forrest offers you...

Certified, experienced, professional trainers
National capability with associates in all Australian states
Small class sizes (Max 8) for personal attention
An extensive range of computer courses incl. Microsoft Office training
Access, Excel, Outlook, Powerpoint, Project, Publisher, Visio, and Word
Professional development / soft skills courses
Microsoft Certified Technical Training
Morning & afternoon tea plus light lunch when attending publically scheduled courses
Pre-course questionnaires – ensuring the right course for you
Unlimited telephone support for the course completed
Comprehensive courseware (customisable for clients in private groups)
Central location in Sydney's CBD
Modern facilities and equipment
Totally Australian owned

Getting to Know Us
Preparing you for the future.

Forrest Training Pty Ltd has been providing a wide range of innovative and custom designed courses and training services since 1994. Our training center, located in the heart of Sydney's CBD is modern and well equipped with current technologies. Forrest Training is an Australian owned and operated Training Organisation.

We have long established partnerships with training providers throughout Australia including: ACT, VIC, QLD, SA, TAS & WA and can assist with company rollouts and upgrades.

At Forrest we believe in...

BEST PRACTICE Learning Methods
Forrest Training courses are presented by qualified professional trainers and consist of a combination of trainer presentations, demonstrations, and hands-on practical sessions in which participants complete practical, work-related exercises to reinforce the topics covered. Our educators understand how people learn and can help you get the most from your training course.

Most courses are delivered over a two week period, eg two consecutive Mondays. This allows for practice between learning sessions. This internationally recognised 'Adult Education Technique' increases the retention rate for each participant. Group bookings may chose to undertake training on consecutive days.

see less


Additional session available

MS Access 2007 Introduction has 1 additional session available, including:

View all sessions