Microsoft Access 2013 Introduction

Course code: MSACC2013INTR
Duration: 1 day
 
Overview
For organizations, who are maintaining and managing large amounts of information. One of the most efficient 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. 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.
 
Pre-requisites
A good familiarisation with Windows
 
Delegates will learn how to:
Create and modify new databases and their various objects enabling them to search and filter their records.
 
COURSE CONTENT
Explore the Microsoft Office Access 2013 Environment
Examine Database Concepts
Use an Existing Access Database
Design and build a database using tables and relationships
Query information within the database
Create forms and reports
 
Basics
Understand the Access 2013 user interface
Opening, closing and saving a database
What is a database?
Using the navigation pane
Getting help
 
Designing a Database
Plan a database
Determine fields
Group fields into tables
Designate primary keys
Determine table relationships
 
Building a Database
Save a new database
Create a table
Setting field properties and validation rules
Create a table relationship
Managing Data in a Table
Adding and deleting records
Navigating and selecting data
Find, filter and sort table data
Work with sub datasheets
 
Querying a Database
Filter records
Create a query using the wizard and design view
Add criteria to a query
 
Designing Forms
View data using a form
Using AutoForm and the form wizard
Modify the design of a form
Finding, sorting and filtering records
 
Designing Reports
Using the report wizard
Create, design and print a report