Access 2013: MOS Certification Comprehensive Student Manual
Duration: 3 Days
Contents:
Introduction v
Topic A: About the manual
Topic B: Setting your expectations
Topic C: Re-keying the course
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 | AX142603802X |
---|---|
Weight | 2.8570 |
Coming Soon | No |
Days of Training | 3 |
Audience | Student |
Product Family | Axzo |
Product Type | Print Courseware |
Electronic | No |
ISBN | 142603802X |
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 |