Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages
Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages

Course Outline

Access 2013 Level 1

This is a 1 day, instructor-led course.

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

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.

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. 

Access 2013 Level 1

This is a 1 day, instructor-led course.

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

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.

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. 

Course Contents

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

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

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

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

Introduction to Reports
Reports
The Report Wizard

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

Price per delegate

£249

Scheduled Classes

Indicia Training, Glasgow:

Please complete the contact form below or call 0141 221 5676 for further course information and available dates.
Alternatively you can email us at info@indiciatraining.com

Contact Us