Access 2013 - Foundation

Request more details:

Description:
Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft Office Access 2013 relational database application.
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.
1. 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
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 OBJECTIVES:
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.