access 2013

Access 2013 for Beginners – Basics Level

Duration:

3 Days
12 hours
28th, 29th and 30th of April 2017
From 10 AM : 2 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:

•    Know what is the database? And why we use it?
•    Know the data types
•    Create Tables
•    Create basic Form
•    Know the relationships types
•    Create One Table Query & Multi-Table Query (With a simple criteria)
•    Create basic Report

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

Where:

Egyptian Council, Dokki

Registration fee:

600 LE instead of 1000 until 20th of April 2017

Registration fee including:

Attending the Course
Coffee break.
Attendance certificate

For registration:

37 Mosadak St, Floor# 6
Dokki - Giza, Egypt.
Tel/Fax: +2 (02) 3748 7742
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