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

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

ELECTRONICFLASHCARDS:
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 sybex.com 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. 1	Getting Acquainted with Access 2003	17
Ch. 1	Access 2003 for Access 97 and 2000/2002 Users: What's New	19
Ch. 2	Building a Simple Desktop and Web Application	53
Ch. 3	Navigating the Access User Interface	83
Pt. 2	Learning the Fundamentals of Jet Databases	121
Ch. 4	Exploring Relational Database Theory and Practice	123
Ch. 5	Working with Jet Databases and Tables	151
Ch. 6	Entering, Editing, and Validating Jet Table Data	217
Ch. 7	Sorting, Finding, and Filtering Data	241
Ch. 8	Linking, Importing, and Exporting Data	267
Pt. 3	Transforming Data with Queries and PivotTables	325
Ch. 9	Designing Queries for Jet Databases	327
Ch. 10	Understanding Jet Operators and Expressions	355
Ch. 11	Creating Multitable and Crosstab Queries	395
Ch. 12	Working with PivotTable and PivotChart Views	461
Ch. 13	Creating and Updating Jet Tables with Action Queries	489
Pt. 4	Designing Forms and Reports	517
Ch. 14	Creating and Using Access Forms	519
Ch. 15	Designing Custom Multitable Forms	569
Ch. 16	Working with Simple Reprots and Mailing Labels	635
Ch. 17	Preparing Advanced Reports	677
Ch. 18	Adding Graphs, PivotCharts, and PivotTables	703
Pt. 5	Upgrading to SQL Server Databases	741
Ch. 19	Linking Access Front-Ends to Jet and Client/Server Tables	743
Ch. 20	Exploring Access Data Projects and SQL Server 2000	801
Ch. 21	Moving from Jet Queries to Transact-SQL	853
Ch. 22	Upsizing Jet Applications to Access Data Projects	887
Pt. 6	Publishing Data to Intranets and the Internet	941
Ch. 23	Exporting and Importing Data with XML	943
Ch. 24	Designing and Deploying Data Access Pages	997
Ch. 25	Converting Access Objects to Data Access Pages	1065
Ch. 26	Integrating with InfoPath and SharePoint Services	1101
Pt. 7	Programming and Converting Access Applications	1147
Ch. 27	Learning Visual Basic for Applications	1149
Ch. 28	Handling Events with VBA 6.0	1191
Ch. 29	Programming Combo and List Boxes	1229
Ch. 30	Understanding Universal Data Access, OLE DB, and ADO	1257
Ch. 31	Consuming and Providing XML Web Services	1333
Ch. 32	Upgrading Access 97 and 2000/2002 Applications to Access 2003	1375
	Glossary	1397