|
Provided by: Maverick Enterprises Get on Track with MS Access AdvancedAccess |
 |
Learn advanced techniques such as: querying with SQL; using crosstab, parameter, and action queries; creating and running macros; importing, exporting, and linking database objects; optimizing, replicating, and synchronizing databases; and basic database security.
|
|
||||||||||||||||||
Training
Provided by Maverick Enterprises
- S asked: Schedule and cost? Prerequisites?
- W asked: I am wanting to know how much is this seminar in Paola? It would be a seminar that to of my IT dept. would attend.
Get on Track with MS Access Advanced
Table of Contents
Unit 1: Querying with SQL; SQL and Access, Writing SQL statements, Attaching SQL queries to controls
Unit 2: Advanced queries; Creating crosstab queries, Creating parameter queries, Using action queries
Unit 3: Macros; Creating, running, and modifying macros, Attaching macros to the events of database objects
Unit 4: Advanced macros; Creating macros to provide user interaction, Creating macros that require user input, Creating the AutoKeys and AutoExec macros, Creating macros for data transfer
Unit 5: Importing, exporting, and linking objects; Importing objects, Exporting objects, Interacting with the XML documents, Linking Access objects
Unit 6: Database management; Optimizing resources, Replicating and synchronizing databases
Unit 7: Security fundamentals; Protecting databases, Encrypting and decrypting databases, User-level security
Unit 1: Querying with SQL; SQL and Access, Writing SQL statements, Attaching SQL queries to controls
Unit 2: Advanced queries; Creating crosstab queries, Creating parameter queries, Using action queries
Unit 3: Macros; Creating, running, and modifying macros, Attaching macros to the events of database objects
Unit 4: Advanced macros; Creating macros to provide user interaction, Creating macros that require user input, Creating the AutoKeys and AutoExec macros, Creating macros for data transfer
Unit 5: Importing, exporting, and linking objects; Importing objects, Exporting objects, Interacting with the XML documents, Linking Access objects
Unit 6: Database management; Optimizing resources, Replicating and synchronizing databases
Unit 7: Security fundamentals; Protecting databases, Encrypting and decrypting databases, User-level security
About The Training Provider: Maverick Enterprises
Maverick Enterprises - Maverick Enterprises offers Business, Technology and Communications training for the generation leading the digital revolution. Rob White brings more than 20 years of Technology Consulting Experience to the table. He is a Novell Certified Network Engineer, and a Certified Microsoft Office Specialist.
For over 10 years, Rob has been performing workshops, seminars and conferences in Software...
