OUTCOMES

By the end of this training course, participants will:

• Create a blank database from a template
• Open, close, and save a database
• Use the Ribbon Interface
• Work with database Objects
• Sort and Filter the View
• Create a blank table from a template, in Datasheet view, and Design View
• Use Lookup columns in a table
• Add information to a table
• Edit, delete and search records
• Create a form with the Wizard and in Layout View
• Modify a form in Design View
• Perform common formatting tasks on forms

• Use Auto Format
• Add or move controls on a form
• Create reports using the Report Wizard
• Understand the Report Design View
• Create Queries using the Wizard
• Execute a Query
• Understand the Query Design View
• Understand Access file formats and save a database as another file format
• Back up the database
• Email the database

Course Length:

1-day

OUTLINE

Microsoft Access 2007 Essentials Training Outline

Download a Course Outline 

Foreword:

Access is the world’s premier database software. You can use Access to create and edit databases by just downloading a ready-made database template and start typing. It’s that easy. You can create a database of contacts, expenses, household and/or business inventory.

In other words, if you have data, you can create a database of that data using Access. Microsoft’s newest version of Access uses the new ribbon interface and offers significant improvement to its database capability.

Who Should Attend?

Anyone that wants to quickly learn to build and manage databases in Microsoft Access.

• Workshop Objectives

• Opening Access
• Common Database Terms
• Understanding the Getting Started Window
• Creating a Blank Database from a Template

• Understanding Security Warnings
• Interface Overview
• Overview of the Ribbon Interface
• Using the Navigation Pane

• Viewing Database Objects
• Exporting an Object
• Renaming an Object
• Sorting and Filtering Your View

• Creating a Blank Table in Datasheet View
• Creating a Blank Table from a Template
• Understanding Data Types
• Understanding Lookup Columns
• Creating a Blank Table using Design View
• Saving Your Table
• Key Table Tools

• Adding Information to a Table
• Editing Records
• Deleting Records
• Searching for Records

• Types of Controls
• Creating a Form with the Wizard
• Creating a Form In Layout View
• Modifying Your Form in Design View
• Key Features on the Form Tools Tab

• Working with Forms
• Common Formatting Tasks
• Using AutoFormat
• Adding Controls
• Moving Controls
• Deleting Records

• Creating Reports
• Using The Report Wizard
• Using Design View
• Adding a Logo
• Working with Controls
• Key Features on the Report Tools Tab

• Creating Queries
• Types of Queries
• Creating a Query with the Wizard
• Executing a Query
• Query Views
• Key Features on the Query Tools Tab

• Understanding Access File Formats
• Printing an Object
• Backing Up Your Database
• Emailing Your Database

• Words From the Wise

Public training courses in Brisbane now include: lunch, a games room, unlimited espresso coffee and WiFi.

'your place or ours'

In-House training benefits:

• tailored to your needs and goals
• cost effective - from $140 per person (full day)
• you choose the day, place and time
• greatest impact in the shortest time
• tailoring ensures practical tools directly applicable to your workplace
• great team building opportunity
• more convenient, people don't need to go off-site

Ph: 1300 121 400

Tailored Delivery - standard

We will always tailor the delivery of your In-House Training course to ensure it is relevant to your team, and targeted at your learning goals. We can incorporate your company's examples and terminology to ensure you the training can be directly related back to your workplace. This is standard, and included in the price.

Your delivery options

We offer a range of different class types to suit your operational needs.

	The "1-hour Motivator" training sessions These 60-90 minute sessions are highly motivating and thought provoking - ideal for those people who need to fit training in around a busy work schedule - great as an early morning kick-start or lunch time boost! Read more...
	The "3-hour Power" sessions 3-hour power sessions – are a great solution when you have very specific outcomes you are targeting, or scheduling the team to be off the job for a whole day is proving to be a challenge Read more...
	Full-day short courses 1-2 day short courses delivered with a unique focus on 80% activities 20% content – just the way learning should be! Read more...
	Conferences and workshops Do you want your conference to be memorable, fun, interactive and have a real highlight? pdtraining's dynamic trainers can add that flair, excitement and much much more! Read more...

Q: Who else uses Professional Development Training?

A: Take a look at some of our recent clients

Q: Are they Happy?

A: This is what they say about us testimonials

Questions?

Email:  This e-mail address is being protected from spambots. You need JavaScript enabled to view it  or

Phone: 1300 121 400

Scheduled Access 2007 Essentials Training Courses
Classes fill up fast - click a date to enrol now!

Questions?

Email: This e-mail address is being protected from spambots. You need JavaScript enabled to view it  or
Phone: 1300 121 400