Skip to Content

Bookings and Enquiries: 0800 077 36 46

Microsoft Access – Database Design Essentials

Microsoft Access – Database Design Essentials

2 Days Crawley £420.00+VAT
Available Date(s):
Print

Is this course right for me?

Our Microsoft Access Database Design – Essentials course will enable you to build databases, e.g. training records, help call log, etc., and quickly and easily enter and extract information.

This course is designed for new users who need to build relational database systems. You should be competent in using a PC for general business use. No previous experience of Access is required.

Training course objectives:

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

Versions Available

2003, 2007, 2010

Related Training Courses in Our Range

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

Contact

Call our expert Learning and Development team today on
0800 077 36 46 for more details about the training options available to
you or to book your course.