Realdolmen Education

Details

Using MS Access

This course is currently not scheduled on the open calendar, but can be organized on request.

Request Course

Duration

3 day(s)

Audience

The course is intended for pc users who wish to use MS Access to create databases with the intention of storing, processing, processing and retrieving data.

Prerequisites

Knowledge of databases is not required. Participants are however assumed to have a basic knowledge of Windows. A good knowledge of Excel is a great advantage.

Objectives

At the end of this course, students will: understand the terminology; have insight in the possibilities of MS Access; be able to design and set up a relational database; create and use queries, forms and reports.

Methods

Classroom training with numerous hands-on exercises and intensive interaction between trainer and students. The creation of a new relational database is the unifying thread throughout the course.

Description

Access is a tool for storing and processing data in a relational database. As such, it differs from other applications in the Microsoft Office suite in a number of respects. In particular, the effectiveness of Access depends to a larger degree on the database design – that is, which data items are stored in which tables, and the way in which these tables are interrelated.

Therefore, in this course we devote considerable time and attention to the analysis of the data, and how to make the correct decisions in the definition of fields, tables, keys, and relationships. The other major topic of the course is the use of Access queries, forms and reports to store, process, retrieve, and manage data.

The scope of this course is limited to what can be done directly through the Access application GUI (graphical user interface). It does not go into the processing of data through programming code such as Visual Basic for Applications or OLE DB.

Contents

  • Introduction
    • What is Microsoft Access?
    • MS Access terminology
    • Starting and closing MS Access
    • the MS Access window
    • Using MS Access Help
  • Relational database concepts
    • What is a relational database
    • Types of relationships
    • Database design principles
    • Using templates
  • Tables
    • Creating tables
      • Methods
      • Fields (field name, data type, field properties)
      • Primary keys
    • Defining relations between tables
    • Formatting a table
    • Importing and exporting data
    • Using tables
      • Entering, modifying and deleting data
      • Handling columns (hide, unhide, freeze, …)
      • Finding and replacing data
      • Sorting and filtering data
    • Modifying the structure
    • Table properties
    • Formulas in tables
    • Analyzing a table
  • Queries
    • Types of queries
    • Creating select queries
      • Tables and fields
      • Sorting
      • Criteria
    • The query result
    • Formulas in queries
    • Creating and using parameter queries
    • Action queries
      • Make Table
      • Delete
      • Update
      • Append
    • Query wizards
      • Crosstab queries
      • Find Duplicate records
      • Find Unmatched records
    • Join types (equi-join, outer join, self join)
    • Query properties
  • Forms
    • Creating forms (AutoForm, wizard, …)
    • Using forms
    • Modifying the design
    • Sections and properties
    • Creating and using controls
    • Divided forms
  • Reports
    • Creating reports (AutoReport, wizard, …)
    • Using reports (page settings, printing, …)
    • Creating labels
    • Modifying the design
    • Sections and properties
    • Creating and using controls
    • Sorting and grouping data