in
f
Sign Up for eNews
- First Name
- Last Name
- Email Address
- Nearest Training Location
- Interested In: Microsoft Office Professional Development Adobe Scheduled Courses In-house/Customised Training

Items 0

Total $0.00

Select Courses

Odyssey Training is a national provider of professional, computer and management training and consultancy.

Microsoft Access 2010 Introduction

Upcoming Course Dates
Microsoft Access 2010 Introduction

Next Level Course

Microsoft Access 2010 Intermediate

Duration
2 Days (9:00 am – 4:00 pm)
Downloads
Practice Files
Meals Provided
Lunch and refresments
Print-Friendly
Print this page
Delivery Methods
Public, In-house, Closed Group
Skills Assessment
Take the test

Expected Outcomes

Create a new database
Define and edit tables
Add, edit and search for data
Create relationships between tables and query the contents
Use criteria to customise a query and create a calculated field
Create professional reports and data input forms

Prerequisites

Experience using Windows and other Microsoft Office programs (e.g. Excel), including the ability to open and save files.

Who Should Attend this Course

This course has been developed for people wanting to create a simple database to enter and extract data, and create reports.

Topics Covered [Click to Show All]

Access Overview
Database components

Relational Database Design
Understanding Database Design
Planning the Database
Defining Tables
Defining Fields
Determining Relationships

Building a Database
Create a database shell
Naming Conventions
Database File Formats (.mdb, .accdb)

Creating A Table
Design View
Creating Fields
Field Data Types
Primary Key
Save a Table
Table Views

Basic Field Properties
Field Size property
Format property
Decimal Places property
Caption Property
Default Value property
Required property
Indexed property

Adding Records Modifying Tables
Moving Columns
Rename a Field
Freezing Columns
Adding a Field

Working with Records
Filtering
Sorting
Deleting Records
Modifying a Record
Find and Replace Text

Importing Data
Import a spreadsheet into table

Lookup Fields
Creating a lookup field
Linking to an existing table
Creating a value list
Viewing subdatasheets

Forms
Create an AutoForm
Create a Wizard Form
Adding Fields to Form
Add Records on Form
Form Layout View
Modify Form fonts
Modify Form colours
Modify Form element placement
Tabbed Interface
Navigation Forms

Queries
Creating a simple Query
Adding a Table
Adding Fields
Sorting Results
View query result
Saving a Query
Modify a Query
Use Query Wizard

Query Criteria
Typing Criteria
Using Like
Using Wildcards
Using Operators
Between Operator
Multiple Criteria
Hiding Fields

Simple Query Calculations
Add a simple expression
Export Query results to Excel
Print Query results

Reports
Create an AutoReport
Preview Report Results
Report Layout View
Modify Report Fonts
Modify Report Colours
Modify Report Placement
Create Wizard Report
Report Design View
Report Header/Footer
Print Reports to PDF

Computer Training

Microsoft Office 2010

	Introduction	Intermediate	Advanced	VBA
Microsoft Access 2010	Microsoft Access 2010 Introduction	Microsoft Access 2010 Intermediate	Microsoft Access 2010 Advanced	VBA for Microsoft Access 2010
Microsoft Excel 2010	Microsoft Excel 2010 Introduction	Microsoft Excel 2010 Intermediate	Microsoft Excel 2010 Advanced	VBA for Microsoft Excel 2010
Office 2010 New Features	Microsoft Office 2010 New Features
Microsoft Outlook 2010	Microsoft Outlook 2010 Introduction		Microsoft Outlook 2010 Advanced
Microsoft Powerpoint 2010	Microsoft PowerPoint 2010 Introduction		Microsoft PowerPoint 2010 Advanced
Microsoft Project 2010	Microsoft Project 2010 Introduction		Microsoft Project 2010 Advanced
Microsoft Visio Professional 2010	Microsoft Visio 2010 Professional Introduction		Microsoft Visio 2010 Professional Advanced
Microsoft Word 2010	Microsoft Word 2010 Introduction	Microsoft Word 2010 Intermediate	Microsoft Word 2010 Advanced	VBA for Microsoft Word 2010
Introduction to Computers	Introduction to Computers

Microsoft Office 2007

	Introduction	Intermediate	Advanced	VBA
Microsoft Access 2007	Microsoft Access 2007 Introduction	Microsoft Access 2007 Intermediate	Microsoft Access 2007 Advanced	VBA for Microsoft Access 2007
Microsoft Excel 2007	Microsoft Excel 2007 Introduction	Microsoft Excel 2007 Intermediate	Microsoft Excel 2007 Advanced	VBA for Microsoft Excel 2007
Office 2007 New Features	Microsoft Office 2007 New Features
Microsoft Outlook 2007	Microsoft Outlook 2007 Introduction		Microsoft Outlook 2007 Advanced
Microsoft Powerpoint 2007	Microsoft PowerPoint 2007 Introduction		Microsoft PowerPoint 2007 Advanced
Microsoft Project 2007	Microsoft Project 2007 Introduction		Microsoft Project 2007 Advanced
Microsoft Visio Professional 2007	Microsoft Visio 2007 Introduction		Microsoft Visio 2007 Professional Advanced
Microsoft Word 2007	Microsoft Word 2007 Introduction	Microsoft Word 2007 Intermediate	Microsoft Word 2007 Advanced	VBA for Microsoft Word 2007

Microsoft Office 2003

	Introduction	Intermediate	Advanced	VBA
Microsoft Access 2003	Microsoft Access 2003 Introduction	Microsoft Access 2003 Intermediate	Microsoft Access 2003 Advanced	VBA for Microsoft Access 2003
Microsoft Excel 2003	Microsoft Excel 2003 Introduction	Microsoft Excel 2003 Intermediate	Microsoft Excel 2003 Advanced	VBA for Microsoft Excel 2003
Microsoft Outlook 2003	Microsoft Outlook 2003 Introduction		Microsoft Outlook 2003 Advanced
Microsoft Powerpoint 2003	Microsoft PowerPoint 2003 Introduction		Microsoft PowerPoint 2003 Advanced
Microsoft Project 2003	Microsoft Project 2003 Introduction		Microsoft Project 2003 Advanced
Microsoft Visio Professional 2003	Microsoft Visio 2003 Introduction		Microsoft Visio 2003 Advanced
Microsoft Word 2003	Microsoft Word 2003 Introduction	Microsoft Word 2003 Intermediate	Microsoft Word 2003 Advanced	VBA for Microsoft Word 2003

Microsoft Sharepoint 2010

Adobe Publishing and Web

	Introduction	Advanced
Adobe Acrobat 9.0	Adobe Acrobat 9.0 Introduction	Adobe Acrobat 9.0 Advanced
Adobe Acrobat X	Adobe Acrobat X Introduction	Adobe Acrobat X Advanced
Adobe Captivate 5	Adobe Captivate Introduction
Adobe Dreamweaver CS4	Adobe Dreamweaver CS4 Introduction
Adobe Dreamweaver CS5	Adobe Dreamweaver CS5 Introduction
Adobe Illustrator CS4	Adobe Illustrator CS4 Introduction
Adobe Illustrator CS5	Adobe Illustrator CS5 Introduction
Adobe InDesign CS4	Adobe InDesign CS4 Introduction	Adobe InDesign CS4 Advanced
Adobe InDesign CS5	Adobe InDesign CS5 Introduction	Adobe InDesign CS5 Advanced
Adobe Photoshop CS4	Adobe Photoshop CS4 Introduction	Adobe Photoshop CS4 Advanced
Adobe Photoshop CS5	Adobe Photoshop CS5 Introduction	Adobe Photoshop CS5 Advanced

“I feel well equipped to commence working on new Access Systems within my workplace.” Kelly – Communications Officer

Copyright
Privacy
Collection Statement

Microsoft Certified Silver Learning Partner Odyssey Training is a national Australian provider of professional, technical and management training and consultancy. We run customised training and scheduled training courses in Brisbane, Cairns, Melbourne, Sydney and Townsville. We have been a major outsource partner for local and national projects across the private and public sectors. Quality Assurance System conforming to AS/NZS ISO 9001:2008 (Certification no. 1075). Odyssey Training is also a signatory to the Government’s Information Technology Conditions v5 (GITC v5) – Q-953.

Training Schedules

Partnering with employers across Australia. Training your people, bringing out their best!

Experience that speaks for itself.

Build your team, your way!

We are an Australian training company, developing Australia’s professionals.

Microsoft Access 2010 Introduction

Upcoming Course Dates Microsoft Access 2010 Introduction

Melbourne

Sydney

Brisbane

Next Level Course

Related Courses

Duration

Downloads

Meals Provided

Print-Friendly

Delivery Methods

Skills Assessment

Expected Outcomes

Prerequisites

Who Should Attend this Course

Topics Covered [Click to Show All]

Training Courses

Upcoming Course Dates
Microsoft Access 2010 Introduction