Support

MS Access 2010 Introduction

3 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
* Have an understanding of Windows

COURSE CONTENT

* Exploring Access
Start Access, Open & Close a Database, Use...

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
* 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, Edit 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
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

Choose from 3 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

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

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




My Other Listings

Adobe InDesign Essentials Course
Adobe InDesign Essentials Course
6 sessions available starting from $795.00
Microsoft Outlook 2007 Advanced
Microsoft Outlook 2007 Advanced
3 sessions available starting from $390.00
Microsoft Outlook 2002 / 2003 Introduction
Microsoft Outlook 2002 / 2003 Introduction
2 sessions available starting from $390.00

see all listings »


Found In