Editorial Reviews:
|
CD-ROM 1 - PERSONAL DB TOOL (2 hours 46 minutes)
1. Relational & Access Database Terminology
2. Objects: Tables, Queries, Forms & Reports
3. Designing Reports, Queries, Tables & Forms
4. Menus, Navigation Pane, Toolbar & Ribbon
5. Exploring Access 2007: Northwind Sample Database
6. Local Templates: Contacts, Projects, Tasks & more
7. Business, Education, Personal & Non-profit Templates
8. Creating DB & Tables Manually or from Template
9. Primary & Foreign Keys, Table Relationships
10. Copying, Moving, Migrating & Populating Tables
11. 3NF DB Design, Indexing Columns for Speed
12. Enforcing DB Integrity and Business Rules
13. SQL Query: Data Retrieval from Related Tables
14. Visual SQL Query Designer & Query Wizard
15. INNER JOIN, LEFT JOIN & RIGHT JOIN Operations
16. Logical, Math, Range & String Operators
CD-ROM 2 -ACCESS BASICS (2 hours 49 minutes)
1. Navigating & Managing Datasheet Views
2. Configuring Record Display in a Datasheet
3. Filtering, Sorting & Printing Records
4. Data Entry: Creating Forms with the Form Wizard
5. Configuring Controls for Forms
6. Working with Property Sheets & Getting HELP
7. Form Data Update: Pictures & OLE Objects
8. Combo Boxes and List Boxes
9. Preparing Form Headers & Footers
10. Architecting New Reports with Report Wizard
11. Creating a New Report in the Report Designer
12. Building Expressions for Dynamic Reports
13. Saving, Distributing and Printing Reports
14. Extending Access: Visual Basic for Applications
15. Designing Tables with Performance Indexes
16. The Simple & Crosstab Query Wizards
CD-ROM 3 - COMPLEX QUERIES (2 hours 47 minutes)
1. Performing Calculations : Percentages
2. The COUNT, AVG, SUM and TOP n Functions
3. Hiding Fields & Columns, Restricting Data
4. Renaming Fields in Queries, the Lookup Wizard
5. The PivotTable and PivotChart Views
6. Subtotal, Total & Grand Total Calculations
7. Aggregate Queries in Design View
|
|
