Access 2013 – Intermediate Level

Access 2013 – Intermediate Level

Duration:

3 Days
12 hours
11th, 12th and 13th of May
From 10 AM : 2 PM

Requirements before you study this program:

1- Good Knowledge for Access 2013 basics (creating tables, forms, basics of creating queries & reports, relationships )
2- 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:

•    Creating more advanced queries
•    Creating more advanced Forms
•    Understanding most used Access Built-in functions
•    Create macros and use Forms, report & their tools events

Outline:

-    Using most popular functions

o    Right
o    Left
o    LCase
o    UCase
o    Trim
o    Mid
o    Len
o    InStr
o    DateAdd
o    DateDiff
o    Day, Hour, Minute, Second, Month, Year
o    Now
o    Between

-    Action Queries

o    Append Query
o    Update Query
o    Delete Query
o    Union Query

-    More Queries

o    CrossTab Query
o    Duplicate Query
o    Unmatched Query

-    Advanced Forms Skills

o    Using subforms
o    Create search form
o    Using IIF
o    Using Forms tools properties
o    Using tools events
o    Using forms to integrate with all Access objects

-    Create Macros

o    Using If
o    Open forms, queries, reports and tables
o    Beep
o    Close Window
o    Delete Records
o    Save Record
o    Print
o    Find
o    AutoExec Macro

Where:

Egyptian Council, Dokki

Registration fee:

600 LE instead of 1000 until 8th of May 2016

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