Access 2016 – Basic (2 Days)
- This event has passed.
Most organisations 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 AccessTM 2013 relational database application.
Who is this course for?
This course is designed for students who wish to learn the basic operations of the Microsoft Access Database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. The Basic course is for the individual whose job responsibilities include designing and creating new databases, tables and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database
Pre-requisites
- Windows XP: Introduction
- Windows 7: Basic or equivalent experience
Objectives
Upon successful completion of this course, students will be able to:
- Examine the basic database concepts and explore the Microsoft Office Access 2013 environment. design and build a simple database with related tables
- Manage the data in a table.
- Query a database using different methods.
- Design forms and generate reports.
Course contents
Unit 1:
- Getting started
- Database concepts
- Exploring the Access environment
- Getting help
Unit 2:
- Databases and tables
- Planning and designing databases
- Exploring tables
- Creating tables
Unit 3:
- Fields and records
- Changing the design of a table
- Finding and editing records
- Organizing records
Unit 4:
- Data entry rules
- Setting field properties
- Working with input masks
- Setting validation rules
Unit 5:
- Basic queries
- Creating and using queries
- Modifying query results and queries
- Performing operations in queries
Unit 6:
- Using forms Creating forms
- Using Design view
- Sorting and filtering records
Unit 7:
- Working with reports
- Reports
- Modifying and printing reports