Support

Access 2010 Introduction Course

3 sessions available starting from $700.00

Subject: Microsoft Access

Ages: All ages

Skill level: All difficulty levels

This course has been designed to introduce new users to Access 2010 databases. Students will learn about the components of a database, and the necessary procedures to ensure the integrity of data is maintained in a database and how to create an Access database including forms queries and reports . Students will consolidate their knowledge by creating a simple database on day two of the course.

Duration:

2 Days

Audience:

Students who need to learn basic database techniques as well as the skills required to modify an existing database or create a new database.

Prerequisites:

For best outcomes, participants should be familiar with the Windows operating system and basic mouse and keyboard techniques.

Course Content:

Getting Started

• What is Microsoft Access?
• What’s...

see more

This course has been designed to introduce new users to Access 2010 databases. Students will learn about the components of a database, and the necessary procedures to ensure the integrity of data is maintained in a database and how to create an Access database including forms queries and reports . Students will consolidate their knowledge by creating a simple database on day two of the course.

Duration:

2 Days

Audience:

Students who need to learn basic database techniques as well as the skills required to modify an existing database or create a new database.

Prerequisites:

For best outcomes, participants should be familiar with the Windows operating system and basic mouse and keyboard techniques.

Course Content:

Getting Started

• What is Microsoft Access?
• What’s New in Access 2010?
• Basic Terminology
• Opening Microsoft Access
• Interface Overview
• Closing Microsoft Access

Using the Getting Started Window

• Overview of the Window
• Navigating Through the Window
• Creating a Database from a Template
• Creating a Blank Database

The Trust Centre

• Warnings You May See when Opening a Database
• Enabling Content
• About Digital Signatures
• About Trusted Locations
• Opening the Trust Centre
• Assigning a Password to your Database

Getting Help in Access 2010

• Opening the Help Screen
• Overview of the Help Screen
• Online Help vs. Offline Help
• Searching for Help

Getting Help

• Opening the Help Screen
• Overview of the Help Screen
• Online Help vs. Offline Help
• Searching for Help

Access 2010 Interface

• Using the Quick Access Toolbar
• About the Default Buttons
• Adding Buttons
• Removing Buttons
• Customizing the Toolbar
• Basics of Ribbons
• Opening Dialog Boxes from the Ribbon
• About the Office Menu
• Reviewing the Ribbon Tabs

Creating a Database

• Planning a Database
• Creating a Database from a Template
• Creating a Blank Database
• Using Database Objects
• Setting Navigation Options

About Records and Tables

• What is a Record?
• Navigation Tips
• Adding Records
• Editing Records
• Deleting Records
• E-Mailing Records
• Printing Records

Creating a table

• About Tables
• Creating a Table
• Entering Data into a Table
• Formatting a Table

Creating Forms to View and Edit Data

• What is a Form?
• Bound vs. Unbound Controls
• Creating a Form with the Wizard
• Using Design View to Modify Your Form
• Using Forms

Creating Queries to Select Records

• What is a Query?
• Creating a Query with the Wizard
• Using Design View to Modify a Query
• Using Queries

Creating Reports

• What is a Report?
• Creating a Report with the Wizard
• Using Design View to Modify a Report
• Using Reports

Viewing and Filtering Data

• Using the View Menu
• Using the View Icons
• Using the Tabs
• Closing Individual Tabs Using Find and Replace
• Sort Ascending or Descending
• Toggling Filter
• Using Selection Sort
• Using Advanced Sort

Printing Data

• Using the Quick Print Icon
• Using the Print Menu
• Using Print Preview
• Using the Print Preview Ribbon
• Printing vs. Exporting

see less

Choose from 3 available sessions:

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $700.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $700.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 8/40 Creek St
    Brisbane, QLD 4000

Price: $700.00

Type

  • Class / Group Sessions



My Other Listings

Microsoft Word 2010 Course | Introduction
Microsoft Word 2010 Course | Introduction
4 sessions available starting from $350.00
Captivate CS5 Introduction Course
Captivate CS5 Introduction Course
1 session available for $1,055.00
Microsoft Excel 2003 Course | Introduction
Microsoft Excel 2003 Course | Introduction
2 sessions available starting from $350.00

see all listings »


Found In