Beginners Access Course

Duration: 1 day plus optional one day workshop

Description

This beginners Access course is designed for users who would like to understand the processes involved in setting up a simple database from scratch and learn the core skills of good database design.

You will learn how to create tables (for your data), build queries (to filter, consolidate or manipulate the data), design forms (for data entry) and organise reports (to print info in a presentable way).

On the second day (which is optional) we'll workshop with you to build the framework of your own database. Bring along all your ideas, existing paper forms, spreadsheets and a list of requirements for your new database and together we'll produce a database design (one that will hold up over time) and you'll walk away with all the fundamental elements of your database in place.

All that's left for you to do over the following days and weeks is add some flesh to your skeleton by populating your database tables with some data etc.

Prerequisites

This course is not recommended for new computer users. Participants should have some experience with the other Microsoft applications such as Excel and Word.

Participants need not have any prior knowledge of database concepts.

Versions Taught

Access 2016, Access 2013, Access 2010

Want To Customise Your Training Content?

Don't see exactly what you want in the topic list below?

You are welcome to swap topics in and out from the different courses available to create your own custom course.

We can accommodate all requests. Customisation is 100% free. 

Let us deliver a powerful course with useful content that you or your staff will actually use. Tailor the training around your own needs and requirements.

Contact us right now and tell us what you need.

TOPICS

Overview

      • General database concepts

Getting Acquainted With The Access Interface

      • Using Tabs, contextual tabs, ribbons and groups
      • Using the Database Window
      • An overview of newest Access features
      • Common (and useful) shortcuts

Database Design

      • Fields, records and tables
      • Table relationships
      • Fundamentals of good database design
      • Introducing normalisation
      • Applying referential integrity

Table Design (80% of Database Development Time)

      • Opening and closing a table
      • Fields and records
      • Using Design view vs Datasheet view
      • Moving around a table
      • Adding a new record
      • Creating a new table
      • Table structures
      • Naming conventions
      • Field names and descriptions
      • Setting and changing the primary key
      • Data types
      • Formatting data
      • Input masks
      • Validating data
      • Using the lookup wizard
      • Shortcut keys for data entry
      • Sorting, filtering and finding records
      • Changing the order and width of columns
      • Freezing and hiding columns
      • Printing data

Query Design

      • Using basic queries to filter data
      • Creating and editing a Select query
      • Working with criteria
      • Using query functions
      • Creating calculated fields
      • Make-Table and Update queries

Form Design

      • The purpose of forms
      • Opening and closing a form
      • Moving between fields in a form
      • Browsing existing records using forms
      • Form design
      • Adding a new record
      • Creating a new form using the wizard
      • Finding records in a form
      • Using the form toolbox
      • Selecting, moving, resizing and aligning form controls
      • Moving labels and controls separately
      • Setting colours
      • Changing the tab order

Report Design

      • Opening, previewing, printing and closing a report
      • Designing a new report
      • Organising data on a report