Microsoft Access

Category
Duration Time
1 day
Courses Provided:
2010 1 day
2013 1 day
2016 1 day

Microsoft Access is a program that allows users to create, manage and analyse large databases of information. Whether you're a small business owner managing your company's information or a researcher examining a large data set, Access can help you manage this task quickly and efficiently.

 

Database Design Essentials Overview

Duration: 2 days

Benefit: This course is designed to provide attendees with a thorough understanding of database design. It will benefit anyone new to databases wishing to learn how to design tables, forms, queries and reports.

Course Objectives: On completion of this course, attendees will understand the design techniques involved in building flat file and relational databases as well as how to create tables, input forms and basic reports.

Key Features

  • Introduction to Database Design
  • The Access Environment
  • Relational Tables
  • Manage Data
  • Work with Forms
  • Create Queries
  • Manage Reports
  • Course content can be designed to fit your company requirements

Reporting and Analysing Data Overview

Duration: 1 day

Benefit: This course is designed to provide attendees with an understanding of the data analysis and reporting functionality within Access. It will benefit individuals who wish to create queries, build reports and export data to third party software.

Course Objectives: By the end of this course, attendees will be able to create select, multi table, calculative and action queries. Attendees will also learn how to present this data by designing professional reports and exporting data to Excel and Word.

Key Features

  • Assessment of existing database design
  • Advanced Queries
  • Advanced Reporting
  • Course content can be designed to fit your company requirements

Advanced Front End Design Overview

Duration: 1 day

Benefit: This course will benefit advanced Access users needing to design a user friendly front end for their database. This training day will show attendees how to design a system enabling their users to add, edit and display data and run reports without the need for detailed knowledge of Access.

Course Objectives: On completion of this course, attendees will be able to create a user friendly front end to their database including switchboards, action buttons and macros.

Key Features

  • Assessment of existing database design
  • The concept of Front End Design
  • Start up options
  • Navigational design
  • Data analysis
  • Macros
  • Course content can be designed to fit your company requirements

Find out more about our Evergreen service   Learn more