Microsoft Access 2016 Level 1

Microsoft Access 2016 Level 1

Overview

To give an introduction to database design concepts. This course offers grounding in creating the core objects of a database and covers data manipulation and extraction at an introductory level

Duration

1 Day

Target Audience

People who intend to design databases from scratch or improve existing Access databases. Also conversion of databases made in other applications and spreadsheet (flat file) databases.

Prerequisites

This course assumes no previous experience of database design. However, delegates with some experience in database design will find this course beneficial if they do not know Access.

Topics

1; Introduction to Databases
Database concepts
Database Layout
Launching Access
The Access Menu System
Dialog Boxes
Getting Help
Creating A New Database
Creating an Access Web App
Closing A Database (Vs Exit Access)
Opening A Database

2; Tables
Database Design.
Creating Tables Using The Table Wizard
Creating Tables In The Datasheet View
Creating Tables In The Design View
Data Types
Field Properties
Data Display Format Vs Input Mask
The Input Mask
Data Entry Problems
Moving And Copying Records

3; Working with Tables
Pasting Records
Sorting The Table
Deleting A Table
Table Layout Changes
Find
Replace
Wildcards

4; Queries
The Simple Query Wizard
The Design View
Modifying The Query
Using Basic Criteria
Additional Criteria
Parameters
Multiple Object Queries
Custom Calculations In A Query
Calculating Fields Continued
Grouping Fields

5; Introduction to Reports
Reports
The Report Wizard

6; Introduction to E-mailing database information
E-Mailing Database Information

 

Course Details

Course Ref:

MSA2016L1

Course Duration:

1 Day

Course Location:

Sunderland

Course Dates:

Please call for dates...

Course Price (Excl VAT):

£195

Course Downloads

Send course details to a colleague

Telephone

   To book or for further information, please telephone 0191 515 3355 or e-mail us at sales@mtc-training.co.uk