Saturday, January 3, 2009

CompTIA A Complete Study Guide or Special Edition Using Microsoft Office Access 2003

CompTIA A+ Complete Study Guide

Author: Quentin Docter

All-in-one guide prepares you for CompTIA's new A+ Certification

Candidates aiming for CompTIA's revised, two-exam A+ Certified Track will find everything they need in this value-packed book. Prepare for the required exam, CompTIA A+ Essentials (220-601), as well as your choice of one of three additional exams focusing on specific job roles--IT Technician (220-602), Remote Support Technician (220-603), or Depot Technician (220-604). This in-depth book prepares you for any or all four exams, with full coverage of all exam objectives. Inside, you'll find:

• Comprehensive coverage of all exam objectives for all four exams in a systematic approach, so you can be confident you're getting the instruction you need

• Hand-on exercises to reinforce critical skills

• Real-world scenarios that show you life beyond the classroom and put what you've learned in the context of actual job roles

• Challenging review questions in each chapter to prepare you for exam day

• Exam Essentials, a key feature at the end of each chapter that identifies critical areas you must become proficient in before taking the exams

• A handy fold-out that maps every official exam objective to the corresponding chapter in the book, so you can track your exam prep objective by objective

• Look inside for complete coverage of all exam objectives for all four CompTIA A+ exams.

Featured on the CD

Test your knowledge with advanced testing software. Includes all chapter review questions and 8 total practice exams.

Reinforce your understanding with flashcards that can run on your PC, Pocket PC, or Palm handheld.

Also on CD, you'll find the entire book in searchable and printable PDF. Study anywhere, any time, and approach the exam with confidence.

Visit for all of your CompTIA certification needs.

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Interesting textbook: Depression or Numb Toes and Aching Soles

Special Edition Using Microsoft Office Access 2003

Author: Roger Jennings

Special Edition Using Microsoft Office Access 2003 is a comprehensive reference for all the features of Access 2003. This edition adds new chapters on collaboration with Microsoft SharePoint Team Server, and creating or consuming XML Web Services, both of which are hot topics. The XML chapter includes Access 2003's new XML export/import features.

The book's organization follows the development process for typical Access database applications. Detailed, step-by-step instructions with icons guide those who are new to Access through table design, data addition, importing data from external sources, query design and execution, and designing data entry forms and printed reports. Chapters on advanced form and report design emphasize data-entry efficiency and presentation clarity.

Table of Contents:
Pt. 1Getting Acquainted with Access 200317
Ch. 1Access 2003 for Access 97 and 2000/2002 Users: What's New19
Ch. 2Building a Simple Desktop and Web Application53
Ch. 3Navigating the Access User Interface83
Pt. 2Learning the Fundamentals of Jet Databases121
Ch. 4Exploring Relational Database Theory and Practice123
Ch. 5Working with Jet Databases and Tables151
Ch. 6Entering, Editing, and Validating Jet Table Data217
Ch. 7Sorting, Finding, and Filtering Data241
Ch. 8Linking, Importing, and Exporting Data267
Pt. 3Transforming Data with Queries and PivotTables325
Ch. 9Designing Queries for Jet Databases327
Ch. 10Understanding Jet Operators and Expressions355
Ch. 11Creating Multitable and Crosstab Queries395
Ch. 12Working with PivotTable and PivotChart Views461
Ch. 13Creating and Updating Jet Tables with Action Queries489
Pt. 4Designing Forms and Reports517
Ch. 14Creating and Using Access Forms519
Ch. 15Designing Custom Multitable Forms569
Ch. 16Working with Simple Reprots and Mailing Labels635
Ch. 17Preparing Advanced Reports677
Ch. 18Adding Graphs, PivotCharts, and PivotTables703
Pt. 5Upgrading to SQL Server Databases741
Ch. 19Linking Access Front-Ends to Jet and Client/Server Tables743
Ch. 20Exploring Access Data Projects and SQL Server 2000801
Ch. 21Moving from Jet Queries to Transact-SQL853
Ch. 22Upsizing Jet Applications to Access Data Projects887
Pt. 6Publishing Data to Intranets and the Internet941
Ch. 23Exporting and Importing Data with XML943
Ch. 24Designing and Deploying Data Access Pages997
Ch. 25Converting Access Objects to Data Access Pages1065
Ch. 26Integrating with InfoPath and SharePoint Services1101
Pt. 7Programming and Converting Access Applications1147
Ch. 27Learning Visual Basic for Applications1149
Ch. 28Handling Events with VBA 6.01191
Ch. 29Programming Combo and List Boxes1229
Ch. 30Understanding Universal Data Access, OLE DB, and ADO1257
Ch. 31Consuming and Providing XML Web Services1333
Ch. 32Upgrading Access 97 and 2000/2002 Applications to Access 20031375

No comments:

Post a Comment