AX1423918088 – Access 2007 Advanced
Duration:
One day
Description:
This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, builds on the skills and concepts taught in Access 2007: Intermediate. Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; work with XML documents; work with Windows SharePoint Services; optimize databases; password-protect and encrypt databases; set Access options and properties; create hyperlink fields; and use Outlook 2007 to update data.
Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Basic, Intermediate, and Advanced.
Table Of Contents:
Unit 1: Querying with SQL
Topic A: SQL and Access
Topic B: Writing SQL statements
Topic C: Attaching SQL queries to controls
Unit 2: Advanced queries
Topic A: Creating crosstab queries
Topic B: Creating parameter queries
Topic C: Using action queries
Unit 3: Macros
Topic A: Creating, running, and modifying macros
Topic B: Attaching macros to the events of database objects
Unit 4: Advanced macros
Topic A: Creating macros to provide user interaction
Topic B: Creating macros that require user input
Topic C: Creating the AutoKeys and AutoExec macros
Topic D: Creating macros for data transfer
Unit 5: Importing, exporting, and linking
Topic A: Importing objects
Topic B: Exporting objects
Topic C: Interacting with XML documents
Topic D: Linking Access objects
Topic E: Working with Windows SharePoint Services
Unit 6: Database management
Topic A: Optimizing resources
Topic B: Protecting databases
Topic C: Setting options and properties
Unit 7: Internet integration
Topic A: Hyperlink fields
Topic B: Working with Outlook 2007
SKU | AX1423918088 |
---|---|
Weight | 1.0070 |
Coming Soon | No |
Days of Training | 1 |
Audience | Instructor |
Product Family | Axzo |
Product Type | Print Courseware |
Electronic | No |
ISBN | 1423918088 |
Language | English |
Page Count | 178 |
Curriculum Library | Access |
Year | 2007 |
Manufacturer's Product Code | N/A |
Current Revision | 1 |
---|---|
Revision Notes | No Revision Information Available |
Original Publication Date | 2014-03-22 00:00:00 |
datafile | 9-1808-8-d.exe |
---|---|
datafile | 9-1808-8-s.exe |
datafile | 9-1808-8-p.exe |
datafile | 9-1808-8-fto.htm |
datafile | MCAS_Map_Access2007.pdf |
datafile | 1423918088.gif |
datafile | 1423918088mini.gif |
datafile | 1423918088.jpg |
datafile | 9-1808-8-faq.htm |