Creating Databases with Access

Creating Databases with Access

Duration:
2 Days
Aims:

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.

Objectives:

On completion of this course, attendees will understand the design techniques involved in building a database as well as how to create tables, input forms and basic reports.

Pre-Requistites

Attendees do not need any previous experience of Access but must have a basic understanding of PC's, including familiarity with a keyboard and mouse.

Versions

Courses are delivered in 2007, 2010, 2013, 2016.

What will I learn?
Database Introduction
  • - Database concepts and terminology
  • - Ground rules for database design
  • - Relational database concepts
  • - Getting started in Access
  • - Getting help
Table Design
  • - Creating a table in design view
  • - Data types
  • - Indexes
  • - Default values
  • - Validation rules
  • - Input masks
  • - Setting a primary key
Working with Tables
  • - Adding and editing data
  • - Navigating, adding, editing and deleting records
  • - Finding and replacing data
  • - Sorting and filtering records
  • - Filtering by selection
Table Relationships
  • - Relational database design
  • - Creating relationships
  • - Database integrity and validation
Queries
  • - Creating a select query
  • - Refining the results of a query
  • - Add a calculated field to a query
  • - Create query joins
  • - Multi table queries
  • - Parameter queries
Form Design
  • - Create a form
  • - Modify the design of a form
  • - Moving, resizing and deleting controls
  • - View and edit data using an Access form
Reports
  • - Create a report
  • - Add a control to a report
  • - Format the controls in a report
  • - Enhance the appearance of a report
  • - Prepare a report for print
Sharing Data across Applications
  • - Publish Access Data in Word
  • - Analyse Access Data in Excel
  • - Create a Mail Merge
Related courses
Run this
course at
your offices
Request a quote
Speak to a friendly advisor

call

0333 344 6630

or visit our

Online Chat
Trustpilot