Web Design

At the end of this course you will have a good working knowledge of Access basics. You will be more confident using Access. You will be able to create a database from scratch. You will Understand how to use tables, fields and records, create simple queries, use forms and, ultimately create reports.

Suitable for:
Our Microsoft Access course is suitable for complete beginners to Microsoft Access.

Prerequisites:

A basic understanding of the windows environment .
A basic level of numeracy and literacy is required.

book a course now by calling 0845 686 2888 or complete the online enquiries form

Course outline:

Database Concepts

Database concepts and terminology
Exploring the Access environment
Planning and designing databases
Closing a database and Access

Access Basics

Exploring tables
Examining queries
Exploring reports

Creating Databases

Creating a database
Using the table wizard
Working in design view

Working with Fields and Records

Changing the design of a table
Adding and deleting records
Finding and editing records
Sorting and filtering records Querying Tables
Creating and using queries
Modifying query results and queries
Using calculations in queries

Creating and Using Forms

Creating forms by using AutoForm
Using the form wizard
Using design view
Finding, sorting and filtering records

Creating and Using Reports

Using the report wizard and queries
Creating, modifying and printing reports

Importing, Exporting and Linking Objects

Importing Access objects
Exporting Access objects
Linking Access objects

Creating relational databases

Database normalising
Introducing relating tables
Adding referential integrity

download course outline

book a course now by calling 0845 686 2888 or complete the online enquiries form