Access

Duration:

One Day

Aims:

This course is designed to give delegates an understanding of some of the major features and functions within Access and the advantages of using a database running under Windows. Course also gives and tips on good database design techniques. All material will be taught within the context of the developing a database. Following the course delegates will be able to design and implement their own database in Access.

Prerequisites:

A working knowledge of PCs and Windows is assumed gained by attendance on an Apt Training PCs & Windows course or equivalent workplace experience.

Course Introduction
  • Starting & exiting Access
  • The Access screen
  • The database control window
  • Accessing help
Creating a Database
  • Database concepts & planning
  • Designing & creating a database
  • Different database components
Creating Tables
  • Field names & data types
  • Setting the field properties
  • Building indexes
  • Setting the primary key
  • Saving a table
  • Changing the table design
Datasheet View
  • Using datasheet view
  • Changing datasheet view
Creating Forms
  • Creating an AutoForm
  • Using Form Wizard
  • Working with records: adding, finding, editing, deleting and sorting
Enhancing a Form
  • Selecting controls
  • Moving controls
  • Resizing controls
  • Inserting controls
  • Deleting controls
  • Changing the tab order
  • Changing the control label text
  • Formatting controls
Using the Toolbox
  • Adding calculations to forms
  • Inserting text onto the form
  • Adding rectangles & lines
  • Inserting pictures
  • Using Option groups
  • Using Combo boxes
  • Using List boxes
Relating Tables
  • Using forms with linked tables
  • Using a Combo box on a form to lookup data from another table
Select Queries
  • Select the fields
  • Setting the criteria
  • Sorting the records
  • Hiding fields
  • Using queries with linked tables
  • Using calculated fields in queries
  • Creating a parameter query
Reports
  • Using Report Wizard
  • Creating a tabular report
  • Print preview
  • Printing a report
Enhancing a Report
  • Report sections
  • Applying enhancements
  • Controls & calculations
Other Reports
  • Grouping & summary reports
  • Using reports with linked tables
  • Using reports with queries
  • Producing mailing labels
  • Merging with Word
  • Analysing to Excel