|
Provided by: Maverick Enterprises Get on Track with MS Access AdvancedAccess |
 |
Training
Provided by Maverick Enterprises
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.
|
|
||||||||||||||||||||
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 over 19 Years of Technology Consulting Experince to the table. He is a Novell Certified Network Engineer, and a Certified Microsoft Office Specialst.
For more than 8 years, Rob has been performing workshops, seminars and conferences in Software...
