About This Training Course

This 2-day Brisbane Access 03- Introduction Training Course (Creating Databases) has been designed to introduce new users to 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. Students will consolidate their knowledge by creating a simple database on day two of the Access 03- Introduction Training Course (Creating Databases).

Multiple-day course sessions are conducted 8-days apart to enable participants’ greater opportunity to absorb and practice learned topics, and cement transfer of skills to their everyday job roles. Our experience is that this course structure assists with the most effective learning and skills retention.

Subjects Covered

This Access 03- Introduction Training Course (Creating Databases) will cover the following subjects:

Working with Databases
• Overview of relational databases
• Spreadsheets -v- databases
• How Access stores data

Starting Access
• Opening an existing database
• Screen components of the Access window

Working with Tables
• Opening and closing a table
• Understanding fields and records
• Moving around records in a datasheet
• Identifying records
• Adding a new Record
• Columns widths and Row heights
• Moving and Hiding/unhiding columns
• Freezing columns

Working with Forms
• Overview of forms and their use
• Opening a Form
• Moving around fields in a form
• Moving between records using a form
• Adding new records with a form
• Closing a form
• Using different Form views
• Switching between form view

Working with Data
• Editing Data
• Finding and Filtering Records
• Deleting Records
• Sorting Data
• Using forms with subforms

Creating Tables
• Table structures in Access
• Planning tables
• Standard naming conventions
• Field names and descriptions
• Understanding Primary Keys
• Setting a Primary key
• Changing the Primary key

Table Properties
• Understanding and setting Field properties
• Setting Data types
• Formatting data
• Using input validation rules to control input
• Using an input mask to assist data entry
• Entering data into a table
• Using Shortcut keys for text entry
• Printing data from a table

Editing Properties
• Changing the data type of a field
• Renaming a field
• Adding a look up field with the wizard
• Finding a record

Creating Forms
• Understanding the uses of Forms
• Using the Auto Form button
• Using the Form wizards
• Adding a new record from a form
• Finding records in a form
• Editing a record in a form

Modifying Forms Data
• Using Design view
• Selecting a control
• Moving Controls and labels independently
• Resizing and Formatting controls
• Changing colours, fonts and borders
• Using Format painter
• Adding and formatting lines
• Nudging and Aligning controls
• Changing the stack order of controls
• Adding a new control
• Changing the Tab order of controls

Queries
• Opening a Query
• Creating new Queries
• Adding Fields to the Query
• Running a query
• Sorting Data in a query
• Adding a table to a query
• Creating a manual join
• Renaming a query
• Hiding fields in a record
• Creating calculated field

Creating Reports
• Creating a report based on a query
• Adding calculated fields to a report

Designing Databases
• Creating a new Database
• Importing and Linking Data from database tables or a spreadsheet
• Linking to another Database

Table Relationship
• Types of Relationships
• Setting Relationships
• Printing a Relationship Diagram

Training Course Outcomes

At the end of this Access 03- Introduction Training Course (Creating 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. Students will consolidate their knowledge by creating a simple database on day two of the course.

Prerequisites

Participants must have basic Windows environment skills.

Other Information

Multiple-day course sessions are conducted 8-days apart to enable participants’ greater opportunity to absorb and practice learned topics, and cement transfer of skills to their everyday job roles. Our experience is that this Access 03- Introduction Training Course (Creating Databases) structure assists with the most effective learning and skills retention.

If you need more information contact Startnextweek.com.au on 1300 728 102