Access Level 1/2 - Core/Intermediate

Access Level 1/2 - Core/Intermediate

Overview

Microsoft Access is a powerful application which allows the user to store and manipulate large amounts of data. At the end of this course you will be able to create a basic database and understand and use Tables, Queries, Forms & Reports within a database.

This course will start Access from the very start. It is designed for those who have little or no experience of the application. It will cover most of the items that the average user or Access will ever need. Those looking for specific database design and consultancy should consider doing an Advanced level course.

Syllabus
  • Understand the concept of a Database including relational databases and referential integrity.
  • Understand concepts such as Primary Key and Index.
  • Understand the difference between fields, Records and Tables.
  • Create and edit a table within a database.
  • Create One-To-Many and Many-To-Many relationships.
  • Understand what Queries are and learn to create a basic query.
  • Set query criteria.
  • Create queries from several data tables.
  • Create a standard form for inputting data.
  • Learn to edit the design of a form.
  • Understand the benefits of knowing how to format parts of a form.
  • Search a database using a form.
  • Learn how to present your data within a report.
  • See how data is grouped and sorted within reports.
  • Learn how to edit and format a report for professional results.