Byron Employment

Byron Employment. Over 71,632 Jobs Australia Wide.

Delivery Method

  • Distance Learning
  • Price: $345.00

Course Overview

The skills and knowledge covered in this course are sufficient to sort, filter and query data, to validate data prior to entry and to build a small menu system for the purpose of database management. It is primarily designed for people who wish to create a database.

Learn To

  • Sort and filter data in a table
  • Format data in tables
  • Use a range of data validation techniques to protect data integrity
  • Export records from Access
  • Export records to HTML for use on the Web
  • Add parameters to queries to capture criteria data
  • Add calculated fields to queries
  • Create action queries to make tables, and update, append, and delete records
  • Understand table and query relationships and how they affect the integrity of your Data
  • Protect your database files against unauthorised access
  • Use the Switchboard Manager to create a menu system

Objectives

Sorting & Filtering Table Data

  • Simple Sorting
  • Sorting on Several Fields
  • Creating a Simple Filter
  • Clearing a Filter
  • Filtering by Exception
  • Filtering by Form

Formatting Table Data

  • Changing Column Widths
  • Changing Column Headings
  • Formatting the Data Sheet
  • Changing Fonts
  • Moving Columns
  • Freezing Columns
  • Hiding Columns
  • Unhiding Columns

Data Validation

  • Assigning Default Values
  • Marking a Required Field
  • Validation Rules and Text
  • Creating a Lookup Field
  • Working with Validations
  • Exporting Records
  • Copying a Table
  • Exporting a Table to Microsoft Excel
  • Exporting a Table to Text File
  • Exporting a Filtered Table
  • Exporting Selected Records
  • Creating an Export Query
  • Exporting From a Query

Exporting To HTML

  • Exporting a Table to HTML
  • Viewing an HTML Document
  • Exporting a Report to HTML
  • Creating Hyperlinks

Parameter Queries

  • Creating a Parameter Query
  • Displaying All Records
  • Using Parameters to Display a Record Range
  • Nominating Specific Data Types
  • Using Parameters in Expressions

Calculated Fields

  • Creating a Calculated Field
  • Formatting Calculations
  • Calculating Across Two Tables
  • Calculating Dates
  • Using Criteria in Calculations
  • Concatenating String Fields

Action Queries

  • Creating a Make Table Query
  • Viewing a Table Created By a Make Table Query
  • Expressions & Update Queries
  • Preparing an Update Query
  • Running an Update Query
  • Creating a Saved Update Query
  • Running a Saved Query
  • Creating a Delete Query
  • Creating an Append Query
  • Understanding Join Types
  • Using Default Joins
  • Orphan Records
  • Viewing Orphan Records
  • Deleting Orphan Records
  • Creating an Exception Query
  • Viewing a Query in SQL

Database Protection

  • Setting a Password
  • Opening a File with a Password
  • Removing a Password
  • Encoding a Database File
  • Decoding a Database File
  • Hiding Database Objects
  • Viewing & Unhiding an Object

Using the Switchboard

  • Creating a Switchboard
  • Creating Subsidiary Menus
  • Creating a Menu Item
  • Returning to Another Menu
  • Creating a Number of Menu Items
  • Linking the Menus
  • Modifying the Menu Forms
  • Changing the Startup
CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (02) 9779 9800
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (02) 9779 9800 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search