Access 2016 - Part 2

Access 2016 — Part 2

COURSE SCHED­ULE

Access 2016 — Part 2

Length Days: 2

Length Hours: 16


PREREQUISITES

To ensure your suc­cess in your course you should have expe­ri­ence work­ing with Microsoft Access 2016, includ­ing a work­ing knowl­edge of data­base design and cre­ation, form design and cre­ation, report design and cre­ation, a work­ing knowl­edge of data­base query­ing and the var­i­ous table relationships.

TAR­GET AUDIENCE

Stu­dents tak­ing this course are data­base admin­is­tra­tors or prospec­tive data­base admin­is­tra­tors who have expe­ri­ence work­ing with Access 2016 and need to learn advanced skills.


COURSE OBJEC­TIVES

In this course, you will learn to cre­ate and man­age a fun­da­men­tal Access 2016 data­base. You will: Cus­tomize a form lay­out to improve usabil­ity and effi­ciency of data entry. Share data across appli­ca­tions. Use macros to improve user inter­face design. Use VBA to enhance tasks. Orga­nize data into appro­pri­ate tables to ensure data depen­dency and min­i­mize redun­dancy. Lock down and pre­pare a data­base for dis­tri­b­u­tion to mul­ti­ple users. Cre­ate and mod­ify a data­base switch­board and set the startup options.


COURSE OUT­LINE

1IMPLE­MENT­ING ADVANCED FORM DESIGN

Topic A: Add Con­trols to Forms Topic B: Enhance Nav­i­ga­tion and Orga­ni­za­tion of Forms Topic C: Apply Con­di­tional Formatting

2SHAR­ING DATA ACROSS APPLICATIONS

Topic A: Import Data into Access Topic B: Export Access Data Topic C: Link Tables to Exter­nal Data Sources Topic D: Cre­ate a Mail Merge

3USING MACROS TO IMPROVE USER INTER­FACE DESIGN

Topic A: Cre­ate a Macro Topic B: Restrict Records Using a Con­di­tion Topic C: Val­i­date Data Using a Macro Topic D: Auto­mate Data Entry Using a Macro

4USING VBA

Topic A: Get­ting Started with VBA Topic B: Enhance Access Using VBA

5USING ADVANCED DATA­BASE MANAGEMENT

Topic A: Man­age a Data­base Topic B: Deter­mine Object Depen­dency Topic C: Doc­u­ment a Database

6DIS­TRIB­UT­ING AND SECUR­ING A DATABASE

Topic A: Split­ting a Data­base for Mul­ti­ple User Access Topic B: Imple­ment Secu­rity Topic C: Con­vert an Access Data­base to an ACCDE File Topic D: Pack­age a Data­base with a Dig­i­tal Signature

7MAN­AG­ING SWITCHBOARDS

Topic A: Cre­ate a Data­base Switch­board Topic B: Mod­ify a Data­base Switch­board Topic C: Set Startup Options


Actual course out­line may vary depend­ing on offer­ing cen­ter. Con­tact your sales rep­re­sen­ta­tive for more information.

Short Descrip­tion

In this course, stu­dents add to their Access edu­ca­tion in order to pro­vide them­selves with mar­ketable job skills. This course builds on the foun­da­tional skills obtained by attend­ing the Access 2016 — Part 1 course.

Con­tact Us

ITBC­group.…

25 Amhurst Road…

Lon­don , UK , E5 8HH

Cell: +07495497301

Maadi , Cairo, Egypt

Cell: 01001531899 | 01017080808

www​.itbcg​.net | info@​tbcg.​net

logo

إذا كان لديك رؤية مستقبلية، فاصنعها بنفسك