Access for HR

Access 2013 for HR – Basics Level

Duration:

4 Days
12 hours
25th, 26th of March, 1st and 2nd of April
From 1 PM : 4 PM

Requirements before you study this program:

1- Good Knowledge for MS windows
2- Good knowledge for MS office interface
3- Please bring your laptop at the time of the training, and be sure to install Access 2013.

Program outcomes:

By the end of the program, the participants will be able to:

•    Create the Employees Database (main data, insurance details, Hiring details ... etc)
•    Calculate the date of pension
•    Create data entry forms
•    Create search forms by employee or dept.
•    Manage the employees' vacations
•    Create reports for each dept, employee details and vacation balance for each employee or group by dept
•    Create history report for each employee including the details of the promotions and related salary

Outline:

-    Introduction to Databases

What is a DB?

Why use a DB?

-    Introduction to objects

Tables

Forms

Queries

Reports

Putting it all together

-    Getting Started With Access 2013

Getting to know Access 2013

Working with your Access environment

-    Managing DBs with Objects

Intro

Working with objects

-    Working with Tables

Table Basics

Adding records & entering data

Editing records

Modify Table appearance

Table formatting options

-    Working with a simple Form

Intro

Why use Forms?

Working with Forms

Using form features

-    Sorting & filtering records

Intro

Filtering records

Creating a filter from a search term

-    Designing a simple query

Intro

Object relationship pane

Fields & table Names

The design grid

Sorting

Showing & hiding fields

Query criteria

-    Designing a Multi-Table Query

Intro

Planning Our Query

Joining Tables In Queries

Creating a multi-table Query

-    Creating simple Report

Intro

Create a report

Printing & saving reports

-  Formulas

Dsum

Dlookup

Now

Where:

Greek Campus, Falaki Street - Bab El Louk

Registration fee:

600 LE instead of 1000 until 20th of March 2016

Registration fee including:

Attending the Course
Coffee break.
Attendance certificate

For registration:

Office #112 - Greek Campus
28 Falaki St., Bab El Louk, Cairo, Egypt
Tel: +2 (02) 2792 9539
Fax: +2 (02) 2792 9539
Mob:+2 (010) 2048 3878
This email address is being protected from spambots. You need JavaScript enabled to view it.
www.egyptiancouncil.com
https://www.facebook.com/ECTD.EG

 

JoomShaper