Loading Events

Access 2013 Basic ( 1 Day)

  • This event has passed.

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.

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

Course content

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
R1,900
1 day
13 October 2017
8:30am - 4:00pm

Book your place

(12 places available)