Microsoft Access – Fundamentals

Start Date: 01/01/1970

Duration: 2 Days

Accreditation: There is no formal accreditation. All candidates receive a Trigraph Certificate of Attendance. Attendees are eligible for 1 Professional Development Unit (PDU’s).

Full Fee: €595

Network Members Fee: €315

Programme overview

This 2 day course provides a basic understanding of the features and functions available in MS Access to a level of competence sufficient for participants to produce tables, queries, forms and reports in a database application.

Course Objectives /Learning Outcomes

After this course, the participant will be able to:

  • Understand database concepts including tables, records and fields
  • Create and modify database tables
  • Query databases
  • Develop and format reports

Who should attend

Users who need to develop simple databases and creating queries, forms and reports Users who want to develop and consolidate their knowledge of the basic features MS Access

Course Content

Introduction

  • Relational databases
  • Key concepts
  • Tables, records and fields
  • Data types
  • Forms and objects
  • Pages
  • Queries
  • Reports
  • Macros
  • Modules
  • Importing and export
  • Saving a new record
  • Deleting records

Filtering Records

  • Filter By Selection
  • Filtering using part of a field
  • Removing a filter
  • Filtering by the entire field contents
  • Filter By Form
  • Clearing existing filter criteria
  • Using ‘Or’ in filters
  • Entering additional criteria
  • Using arithmetic expressions to filter records
  • Deleting a filter

Tables

  • The Datasheet view
  • Changing column widths
  • Changing the window size
  • Sorting
  • Finding records
  • Editing records
  • Adding records
  • Deleting a record
  • Printing a datasheet
  • Print Preview
  • Page Setup
  • Design view

Querying the Database

  • Types of queries
  • Simple select queries
  • Opening an existing query
  • Query based on one table
  • Adding a table
  • Choosing which fields to show
  • Running the query
  • Changing the query
  • Saving a query
  • Queries using two tables
  • Inserting new fields
  • Deleting a field
  • Saving the query

Forms

  • Relationships
  • Creating a new form
  • Form, Design and Datasheet views
    Reports
  • Running an existing report
  • Sending reports to Microsoft® Word and Excel
  • Using AutoReport
  • Saving and closing the report
  • Using the Report Wizard
  • Adding fields from other tables
  • Choosing how to view the data
  • Choosing how to sort data
  • Choosing a layout
  • Choosing a style
  • Saving the report

Trainer Profile