A.K.Solutions:- Microsoft Access Part 1

Microsoft Access
Part 1

Tel:
024 7637 2073

To return to the Microsoft Access Course Index please Click Here

A.K.Solutions: Microsoft Access Part 1 Course Content
More than just a beginners course! Creating a Database / Designing Tables / Specifying Field Properties:- Primary Key, Default Value , Input Masks , Validation Rules , Formats / Criteria Expressions / Filters and Queries / Forms / Reports.

INTRODUCTION

Tutor lead introduction to Designing a database from scratch
Tour of the database window and its objects

TABLES

Table design: Field Names, Data Types, Field Descriptions and Field Properties
Getting to grips with essential field properties such as Size, Indexing, Validation rules, Default Values, Input Masks, Captions and Formatting
Primary key properties
Testing a tables design with test data
Modifying a tables design

FORMS

Creating a form to enter/edit data in a table
Basic form navigation techniques
Editing data in forms
Advantages of using forms
Understanding some of the basic form properties
Some simple form design techniques
Adding a calculated control to a form

SORTING and SEARCHING

Methods of Sorting data in Forms and Tables
Simple searches
Search criteria expressions
Use of wild cards
Applying filters to recordsets
Advanced filters
Saving filters as queries
Using queries as filters

QUERIES

What is a query?
Where are queries used?
Different types of query available

REPORTS

Creating reports
Why base a report on a query rather than a table?
Grouping and Sorting data in reports
Totaling data in reports
Labels and some very important properties
Print preview / printing

All is explained in an easy to understand way

By the end of the day you will have a good working knowledge of Microsoft Access

You may print this page by selecting File Print in your Browser Window

All candidates are advised to have a good working knowledge of Windows Part 1 before taking this course. For example a candidate should know how to Save / Retrieve documents and have basic Mouse / Keyboard skills.

To contact A.K.Solutions:- enquiries@aksolutions.co.uk

E-Mail Us

Tel:
024 7637 2073

A.K.Solutions: Microsoft Access Part 1 Course Content More than just a beginners course! Creating a Database / Designing Tables / Specifying Field Properties:- Primary Key, Default Value , Input Masks , Validation Rules , Formats / Criteria Expressions / Filters and Queries / Forms / Reports.

A.K.Solutions: Microsoft Access Part 1 Course Content
More than just a beginners course! Creating a Database / Designing Tables / Specifying Field Properties:- Primary Key, Default Value , Input Masks , Validation Rules , Formats / Criteria Expressions / Filters and Queries / Forms / Reports.