|
Tech. Books
Software
PC & Laptops
Electronics
|
|
|
|
| Practical Access 2007 on 7 CD-ROMs | 
enlarge | From: Silico-Magnetic Intelligence Corp. Category: Software
Buy New: $375.00
New (2) from $375.00
Sales Rank: 22535
Format: Cd-rom Media: CD-ROM
UPC: 850171001128 EAN: 0850171001128 ASIN: B0018A80O4
Availability: Usually ships in 1-2 business days
|
| Features:
| • | Screen image video with audio narration | | • | Pause video lesson anytime to practice along | | • | Training by industry expert trainer | | • | Create tables, forms, queries, reports & charts | | • | Each video lesson is around 10 minutes |
|
| Editorial Reviews:
Product Description CD-ROM 1 - PERSONAL DB TOOL (2 hours 46 minutes) 1. Relational & Access Database Terminology 2. Objects: Tables, Queries, Forms & Reports3. Designing Reports, Queries, Tables & Forms4. Menus, Navigation Pane, Toolbar & Ribbon5. Exploring Access 2007: Northwind Sample Database 6. Local Templates: Contacts, Projects, Tasks & more7. Business, Education, Personal & Non-profit Templates8. Creating DB & Tables Manually or from Template9. Primary & Foreign Keys, Table Relationships10. Copying, Moving, Migrating & Populating Tables 11. 3NF DB Design, Indexing Columns for Speed 12. Enforcing DB Integrity and Business Rules13. SQL Query: Data Retrieval from Related Tables14. Visual SQL Query Designer & Query Wizard15. INNER JOIN, LEFT JOIN & RIGHT JOIN Operations 16. Logical, Math, Range & String OperatorsCD-ROM 2 -ACCESS BASICS (2 hours 49 minutes) 1. Navigating & Managing Datasheet Views2. Configuring Record Display in a Datasheet3. Filtering, Sorting & Printing Records4. Data Entry: Creating Forms with the Form Wizard5. Configuring Controls for Forms6. Working with Property Sheets & Getting HELP 7. Form Data Update: Pictures & OLE Objects8. Combo Boxes and List Boxes9. Preparing Form Headers & Footers10. Architecting New Reports with Report Wizard11. Creating a New Report in the Report Designer12. Building Expressions for Dynamic Reports13. Saving, Distributing and Printing Reports14. Extending Access: Visual Basic for Applications15. Designing Tables with Performance Indexes 16. The Simple & Crosstab Query Wizards CD-ROM 3 - COMPLEX QUERIES (2 hours 47 minutes) 1. Performing Calculations : Percentages2. The COUNT, AVG, SUM and TOP n Functions3. Hiding Fields & Columns, Restricting Data4. Renaming Fields in Queries, the Lookup Wizard 5. The PivotTable and PivotChart Views 6. Subtotal, Total & Grand Total Calculations7. Aggregate Queries in Design View
|
|
|
| |