Book Online: Login | Register

1300 658 388

Search form

 

 

This course builds skills and knowledge to create database systems, enter edit and delete data in database files, produce information in forms and reports, and generate queries on the data.
Course Price (inc GST where applicable): 
$900.00
Locations: 
Sydney, Melbourne
Duration: 
2 days
Versions: 

2010

You'll Learn how to: 
  • Understand the principles upon which Access is based
  • Design and create a database using Access 2010
  • Create, modify and manipulate tables
  • Add transactional records to a lookup database
  • Create simple and effective queries
  • Perform more advanced queries using a variety of querying techniques
  • Create and work with aggregation queries
  • Create reports from tables
  • Create and use a variety of forms
Course Content: 

Access 2010 Orientation

 
The backstage view and navigation pane
Opening an existing database file
Understanding the Access 2010 screen
Working with tables and other database objects

Designing a Lookup Database

How Access stores data
Data types in Access 2010
Scoping your new database
Identifying table problems and refining table structures
Finalising the design

Creating a Lookup Database

Creating a new database file
Creating the lookup table
Defining the primary key
Creating the transaction table
Understanding and creating lookup table relationships

Modifying Table Structures

Opening and altering existing tables
Changing field sizes and names
Changing decimal places and date formats
Indexing fields
Deleting fields from a table
Copying and deleting tables

Adding Records to a Table

Typing records into a table
Adding records
Importing from Microsoft Excel

Adding Transactional Records

Using forms to add transactional records
Adding records using a subdatasheet
Inserting and removing subdatasheets

Working with Records

Navigating to a specific record
Editing and deleting records and undoing changes
Searching in tables and fields
Finding and replacing
Printing records from a table
Compacting a database

Formatting Tables

Changing column widths and formatting cells
Changing fonts
Moving and freezing columns in a table

Sorting and Filtering

Sorting on several fields
Working with filters

Creating Queries

Creating queries and query designs
Working with a query
Applying record criteria
Clearing selection criteria

Querying Techniques

Creating 'and' queries and 'or' queries
Querying numeric data and dates
Using a range expression
Querying opposite values
Sorting query data
Querying using wildcards
Querying with a lookup table
Sorting query data numerically

Aggregation Queries

Creating an aggregation query
Working with aggregation queries
Multiple aggregations
Aggregating calculated fields
Applying criteria to aggregates
Creating an assembly query
Creating the nesting query

Creating and Using Reports

Working with existing reports
Previewing and printing Access reports
Changing the report layout
Using the report wizard
Creating grouped and statistical reports
Working with grouped reports

Creating and Using Forms

Creating basic forms and split forms
Binding a form to a query
Using the form wizard
Working with existing forms
Editing records in a form
Deleting an unwanted form
This Course Suits: 

This course is designed for users who need to know how to create databases and to manipulate data to provide viable information.

Prerequisites: 

A general understanding of personal computers and the Windows operating system environment.

The Learning Process: 
PREPARING TO LEARN

Get the most out of your course by preparing before you attend. TP3 provide pre-course materials that enable you to reflect on and align your learning outcomes with the course content.

AFTER THE COURSE

TP3's online Learning Resources contains additional tools and resources to help you consolidate and continue your learning. For more details, click here.

Customising this course: 

TP3 can provide a range of consulting services to better meet your business needs, including closed courses for your organisation, customised course material relevant to your industry and requirements, individual or group coaching and blended learning solutions.

Booking Information: 
Call 1300 658 388 to book this course, or book and pay online below.
Course Dates: 

Twitter icon
Facebook icon
Google icon
LinkedIn icon
e-mail icon