Book Online: Login | Register

1300 658 388

Search form

 

 

This Access 2007 Introduction course is running in Sydney and Melbourne. You will learn how to design and create new databases, create tables, maintain records and produce reports based on information in the database.

Course Price (inc GST where applicable): 
$900.00
Locations: 
Sydney, Melbourne
Duration: 
2 days
Versions: 

2007

You'll Learn how to: 
  • Create a database and tables
  • Create fields
  • Enter and edit data
  • Create forms and reports
  • Use filters and queries
  • Create relationships
Course Content: 

Introduction to Access

Screen components
Database management concepts
Starting and exiting Access
Elements of an Access database
Opening and moving around tables
Selecting text

Creating Tables and Entering Data

Creating tables
Switching views in tables
Working in Design View
Field names
Data types
Field descriptions
Primary key
Saving and naming a table
Naming conventions
Field properties
Adding records in datasheet view
Table wizards

Importing and Linking Data

Overview of importing and linking
Import an Access table
Importing from another application
Linking

Working with Data

Copying tables
Appending data
Finding and replacing data
Sorting and filtering records
Hide and Unhide
Undo
Modifying the table structure
Changing the data type
Deleting fields
Deleting tables
Renaming tables
Deleting individual records

Relationships between Tables

Types of relationships
Creating a relationship

Forms

Using the Autoform button
Using the Form Wizards
Multi-table forms
Editing forms

Queries

Creating a Query
Sorting records
Entering text, number and date criteria
Comparison operators
Multiple table queries
Using calculations in queries
Query Wizards

Reports

AutoReport
The Report Wizards
Report sections
Grouping and summarising data
Creating mailing labels

Startup Options

Startup forms
Command buttons

Annex:

Introduction to macros

This Course Suits: 

This course will suit you if you need to create Access databases to store, manage and analyse business data.

Prerequisites: 

Basic Windows and file management skills.

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