Sunny Health & Fitness Practical Access 2007 on 7 CD-ROMs
- Distribution Media: CD-ROM
Available From
Why are these offers here?
-
Overview
-
Reviews
- Compare Prices
Sunny Health & Fitness Practical Access 2007 on 7 CD-ROMs
Compare With Similar Products Other People Shopped For...
Available From
Practical Access 2007 on 7 CD-ROMs
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
| Stock Availability: | In stock |
| Store Note: | Fantastic prices with ease & comfort of Amazon.com! |
| Base Price: | $345.00 |
| Tax: | |
| Shipping: | $3.99 |
| Total Price: | $348.99 |
Prices are provided by the merchants. We assume no responsibility for accuracy of price information provided by merchants. Please alert us to any pricing discrepancies and we will alert the merchant. Sales taxes are estimated at the zip code level. Shipping costs are estimates. Please check store for exact shipping costs. To learn more about why certain stores are listed on the site, click here
Product specifications are obtained from third parties, and while we make every effort to assure the accuracy of product information, we do not assume any liability for inaccuracies. Store ratings and product reviews are written and submitted by online shoppers to assist you as you shop. They do not reflect our opinions. We take no responsibility for the content of ratings and reviews submitted by users.