Access 2013: MOS Certification Comprehensive Instructor's Edition
Duration: 3 Days
Contents:
Introduction v |
Topic A: About the manual |
Topic B: Setting student expectations |
Topic C: Classroom setup |
Topic D: Support |
Getting started 1-1 |
Topic A: Database concepts |
Topic B: Exploring the Access environment |
Databases and tables 2-1 |
Topic A: Planning and designing databases |
Topic B: Exploring tables |
Topic C: Creating tables |
Fields and records 3-1 |
Topic A: Changing the design of a table |
Topic B: Finding and editing records |
Topic C: Organizing records |
Data entry rules 4-1 |
Topic A: Setting field properties |
Topic B: Working with input masks |
Topic C: Setting validation rules |
Basic queries 5-1 |
Topic A: Creating and using queries |
Topic B: Modifying query results and queries |
Topic C: Performing operations in queries |
Using forms 6-1 |
Topic A: Creating forms |
Topic B: Using Design view |
Topic C: Sorting and filtering records |
Working with reports 7-1 |
Topic A: Creating reports |
Topic B: Modifying and printing reports |
Relational databases 8-1 |
Topic A: Database normalization |
Topic B: Table relationships |
Topic C: Referential integrity |
Related tables 9-1 |
Topic A: Creating lookup fields |
Topic B: Modifying lookup fields |
Topic C: Subdatasheets |
Complex queries 10-1 |
Topic A: Joining tables in queries |
Topic B: Using calculated fields |
Topic C: Summarizing and grouping values |
Advanced form design 11-1 |
Topic A: Adding unbound controls |
Topic B: Graphics |
Topic C: Adding calculated values |
Topic D: Adding combo boxes |
Topic E: Advanced form types |
Reports and printing 12-1 |
Topic A: Report formatting |
Topic B: Calculated values and subreports |
Topic C: Printing |
Topic D: Label printing |
Charts 13-1 |
Topic A: Charts in forms |
Topic B: Charts in reports |
Querying with SQL 14-1 |
Topic A: SQL and Access |
Topic B: Writing SQL statements |
Topic C: Attaching SQL queries to controls |
Advanced queries 15-1 |
Topic A: Creating crosstab queries |
Topic B: Creating parameter queries |
Topic C: Using action queries |
Macros 16-1 |
Topic A: Creating, running, and modifying macros |
Topic B: Attaching macros to the events of database objects |
Advanced macros 17-1 |
Topic A: Creating macros to provide user interaction |
Topic B: Creating macros that require user input |
Topic C: Creating AutoKeys and AutoExec macros |
Topic D: Creating macros for data transfer |
Importing, exporting, and linking objects 18-1 |
Topic A: Importing objects |
Topic B: Exporting objects |
Topic C: Working with XML documents |
Topic D: Linking Access objects |
Topic E: Using hyperlink fields |
Database management 19-1 |
Topic A: Optimizing resources |
Topic B: Protecting databases |
Topic C: Setting options and properties |
Microsoft Office Specialist exam objectives A-1 |
Topic A: MOS exam objectives |
Course summary S-1 |
Topic A: Course summary |
Topic B: Continued learning
|
Glossary G-1
|
Index I-1 |
SKU | AX1426038038 |
---|---|
Weight | 2.8570 |
Coming Soon | No |
Days of Training | 3 |
Audience | Instructor |
Product Family | Axzo |
Product Type | Print Courseware |
Electronic | No |
ISBN | 1426038038 |
Language | English |
Page Count | 520 |
Curriculum Library | Access |
Year | 2013 |
Manufacturer's Product Code | N/A |
Current Revision | 1 |
---|---|
Revision Notes | No Revision Information Available |
Original Publication Date | 2014-03-22 00:00:00 |