Access Database Design – Essentials

Access Database Design – Essentials

2 DayCrawley£420.00+VAT

Microsoft Access is a powerful piece of software that allows you to quickly and easily create databases, and this programme looks at the key features and techniques required to achieve that.

Building a robust database is an effective way to keep track of important data, allowing you to enter and extract information quickly and easily, ultimately making your data more organised and useful.

If you want to learn how to build fully relational database systems, and you’re already competent in using a PC for business use, this essential Access training course will equip you with the necessary skills and knowledge.


Course Detail

What you’ll learn

By the end of the programme you’ll be able to:

  • Create a database
  • Build tables, forms, queries and reports
  • Create fully relational databases

What’s covered

Creating a database

  • Creating a new database
  • Database elements

Creating a data table

  • Setting field properties
  • Using input masks
  • Validation rules
  • Default values
  • Setting a primary key
  • Creating lookup fields

Working with data tables

  • Adding data
  • Deleting data
  • Sorting data
  • Data entry quick keys
  • Filtering

Creating simple data forms

  • The form wizard
  • Building and amending forms
  • Entering data using forms

Extracting data using queries

  • Creating select queries
  • Setting criteria
  • Creating parameter queries
  • Adding calculations to queries

Printing and reporting

  • Printing tables and queries
  • The report wizard
  • Building and amending reports
  • Error checking
  • Using layout view (2007 and 2010)

Principles of relational databases Importing data

  • Importing data from Excel

Building relational databases

  • Linking information between tables
  • One-to-one and one-to-many links
  • Defining referential integrity
  • Printing table relationships

Sub datasheets

  • Viewing a subdatasheet
  • Adding a subdatasheet

Building multiple table queries

  • Deciding which tables to use
  • Adding tables to the query
  • Creating links between tables
  • Join properties

Advanced form and report design

  • Field properties
  • Adding calculations
  • Adding headers and footers
  • Adding dates, times, page numbers
  • Sorting and grouping
  • Concatenating fields

Case study

2 DayCrawley£420.00+VAT