Microsoft Access Introduction

Course Details

 

This course has been designed to introduce new users to Microsoft Access 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.

Duration:

1 Day

Audience:

Students who need to learn basic database techniques and 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.

2016

 

Getting Started

  • What is Microsoft Access?
  • Basic Terminology - Tables, Records, Forms, Queries and Reports
  • Understanding a relational database
  • Opening Microsoft Access
  • Interface Overview
  • Ribbon and commands
  • Quick Access Toolbar
  • Closing Microsoft Access

Working with Tables

  • Opening Tables
  • Table Views
  • Datasheet View
  • Navigating Records in a Datasheet
  • Adding and Editing records in a datasheet
  • Managing Column widths and row heights
  • Moving a Column
  • Hiding / Unhiding Columns
  • Freezing / Unfreezing Columns

Working with Data through Forms

  • Understanding forms and their relationship to tables
  • Moving a round a form
  • Understanding form controls
  • Find records through a form
  • Filtering data
    • using a data sheet
    • on a split form
    • by date
    • by selection
  • Sorting Data
  • Printing records
  • Export to PDF
  • Export to Excel
  • Deleting a record

Working with Reports

  • Running a Report
  • Understanding the relationship of the report data
  • Veiwing the Report structure
  • Printing the report

Creating a table

  • Planning a new Table
  • Creating a Table
  • Setting Field properties and data types
  • Using a Lookup field
  • Setting a Primary Key
  • Setting Indexes
  • Entering Data into 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

Creating a New Database

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

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

2013

 

Learning Outcomes

  • Become familiar with the Access 2010 Interface
  • Understand the components of a database
  • Create a multi-table database and establish relationships
  • Import data from various sources into the database
  • Create simple forms to add and manage data
  • Create simple queries to list specific data
  • Create simple reports for output of data
  • Use various techniques to find data in a database

Getting Started

  • 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

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 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 Simple Reports

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

Viewing and Filtering Data

  • Searching for Records
  • Filtering Records
  • 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

2010/2007

 

Getting Started

  • What is Microsoft Access?
  • What's New in Access 2007?
  • 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

Access 2007 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

Viewing and Filtering Data

  • Searching for Records
  • Filtering Records
  • 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

About Records and Tables

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

Creating 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 Simple Reports

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

Event Properties

Event Date 16-10-2017
Event End Date 16-10-2017
Individual Price $429.00
Course Code ACINT
Location
Corporate Training Solutions Australia
Level 19, Waterfront Place, 1 Eagle St Brisbane, QLD 4000 Australia
Corporate Training Solutions Australia
We are no longer accepting registration for this event

Group Rate

#Registrants Rate/Person($)
3 407.55
4 386.10
$429.00 10

Location Map

Share this event: