Synopses & Reviews
As the most popular database management program on the market, Microsoft Access didn't need much improvement. But with the release of Access 2003, Microsoft managed to further enhance the way people organize, access, and share information.
In this new version, Access is more capable than ever, thanks to additional features like automatic error checking, automatic property updating, and the expanded ability to import, export, and work with Extensible Markup Language (XML) data files. The number of features it offers is truly impressive--and potentially daunting.
Anyone baffled by the multitude of features and functionality in Microsoft Access can get up to speed quickly with the help of Access 2003 Personal Trainer. Part of our new Personal Trainer Series, this book lets people of any technical level learn exactly what they need to know at their own pace. Unlike many consumer software tutorials that dumb down the material or present it in a confusing fashion, this book is written in a non-technical and engaging style that readers find fun, easy, and informative.
This book will not only help existing users, but those who received Access as part of Microsoft Office and are now ready to dip their toe in the water. It starts with Access fundamentals and then moves on to tables, fields, queries, forms, reports, macros, and advanced topics like linking information from an external source. Access 2003 Personal Trainer explains how you can easily:
- Access information from multiple sources
- Link business systems
- Create powerful database solutions
- Share information more efficiently
To best guide learning, Access 2003 Personal Trainer includes detailed diagrams, dozens of task-oriented lessons, and a fully interactive training simulation CD--everything you need to become an Access pro.
A fully illustrated, modular approach to the features of Access allows readers to proceed at their own pace.
About the Author
CustomGuide, Inc. is a leading provider of computer training materials. Founded by instructors who grew dissatisfied with the industry's dry course materials, CustomGuide offers courseware (for instructors and students), quick references, software bulletins and e-learning courses that are fun, flexible, and easy to use. They must be onto something, because CustomGuide has quickly become a leading provider of computer training materials. Although CustomGuide has grown, the founders continue to have the same vision, drive, and commitment.
Table of Contents
About CustomGuide, Inc.; CustomGuide, Inc. Staff and Contributors; Introduction; About the Personal Trainer Series; About This Book; Conventions Used in This Book; Using the Interactive Environment; How to Contact Us; Safari® Enabled; Chapter 1: The Fundamentals; 1.1 Introduction to Databases; 1.2 What's New in Access 2003; 1.3 Starting Access and Opening a Database; 1.4 Understanding the Access Program Screen; 1.5 Using Menus; 1.6 Using Toolbars; 1.7 Filling Out Dialog Boxes; 1.8 Keystroke and Right Mouse Button Shortcuts; 1.9 Opening and Modifying Database Objects; 1.10 Working with Multiple Windows; 1.11 Tour of a Table; 1.12 Adding, Editing, and Deleting Records; 1.13 Tour of a Form; 1.14 Tour of a Query; 1.15 Tour of a Report; 1.16 Previewing and Printing a Database Object; 1.17 Selecting Data; 1.18 Cutting, Copying, and Pasting Data; 1.19 Using Undo; 1.20 Checking Your Spelling; 1.21 Getting Help; 1.22 Changing the Office Assistant and Using the Quick ReferenceHelp Button; 1.23 Using the Zoom Box; 1.24 Closing a Database and Exiting Access; 1.25 Chapter One Review; Chapter 2: Creating and Working with a Database; 2.1 Planning a Database; 2.2 Creating a Database Using the Database Wizard; 2.3 Creating a Blank Database; 2.4 Creating a Table Using the Table Wizard; 2.5 Modifying a Table and Understanding Data Types; 2.6 Creating a New Table from Scratch; 2.7 Creating a Query in Design View; 2.8 Modifying a Query; 2.9 Sorting a Query Using Multiple Fields; 2.10 Developing AND and OR Operators; 2.11 Creating a Form with the Form Wizard; 2.12 Creating a Report with the Report Wizard; 2.13 Creating Mailing Labels with the Label Wizard; 2.14 Database Object Management; 2.15 File Management; 2.16 Compacting and Repairing a Database; 2.17 Converting an Access Database; 2.18 Chapter Two Review; Chapter 3: Finding, Filtering, and Formatting Data; 3.1 Finding and Replacing Information; 3.2 Sorting Records; 3.3 Filtering by Selection; 3.4 Filtering by Form; 3.5 Creating an Advanced Filter; 3.6 Adjusting Row Height and Column Width; 3.7 Rearranging Columns; 3.8 Changing Gridline and Cell Effects; 3.9 Freezing a Field; 3.10 Hiding a Column; 3.11 Changing the Datasheet Font; 3.12 Chapter Three Review; Chapter 4: Working with Tables and Fields; 4.1 Understanding Field Properties; 4.2 Indexing a Field; 4.3 Adding a Primary Key to a Table; 4.4 Inserting, Deleting, and Reordering Fields; 4.5 Changing a Field's Data Type; 4.6 Using Field Descriptions; 4.7 Adding a Caption; 4.8 Changing the Field Size; 4.9 Formatting Number, Currency, and Date/Time Fields; 4.10 Formatting Number, Currency, and Date/Time Fields by Hand; 4.11 Formatting Text Fields; 4.12 Setting a Default Value; 4.13 Requiring Data Entry; 4.14 Validating Data; 4.15 Creating an Input Mask; 4.16 Creating a Lookup Field; 4.17 Creating a Value List; 4.18 Modifying a Lookup List; 4.19 Chapter Four Review; Chapter 5: Creating Relational Databases; 5.1 Understanding Table Relationships; 5.2 Creating Relationships Between Tables; 5.3 Enforcing Referential Integrity; 5.4 Testing Referential Integrity and Printing and Deleting Table Relationships; 5.5 Understanding Relationship Types; 5.6 Chapter Five Review; Chapter 6: Working with Queries; 6.1 A Quick Review; 6.2 Understanding the Different Types of Queries; 6.3 Creating a Multiple-Table Query; 6.4 Creating a Calculated Field; 6.5 Working with Expressions and the Expression Builder; 6.6 Using an IIf Function; 6.7 Summarizing Groups of Records; 6.8 Display Top or Bottom Values; 6.9 Parameter Queries; 6.10 Finding Duplicate Records; 6.11 Finding Unmatched Records; 6.12 Crosstab Queries; 6.13 Delete Queries; 6.14 Append Queries; 6.15 Make-Table Queries; 6.16 Update Queries; 6.17 Chapter Six Review; Chapter 7: Working with Forms; 7.1 Creating a Form with AutoForm; 7.2 Modifying a Form; 7.3 Adding and Deleting Fields; 7.4 Moving and Sizing Controls; 7.5 Changing the Tab Order; 7.6 Working with Control Properties; 7.7 Control Property Reference; 7.8 Working with Form Properties; 7.9 Form and Report Property Reference; 7.10 Working with Multiple Controls; 7.11 Adding, Cutting, Copying, and Pasting Controls; 7.12 Changing a Control's Data Source; 7.13 Creating a Calculated Control; 7.14 Changing a Control's Default Value; 7.15 Using the Control Wizard; 7.16 Creating a Subform; 7.17 Modifying and Working with Subforms; 7.18 Chapter Seven Review; Chapter 8: Working with Reports; 8.1 Creating a Report with AutoReport; 8.2 Modifying a Report; 8.3 Adding and Deleting Fields; 8.4 Moving and Sizing Controls; 8.5 Adjusting Page Margins and Orientation; 8.6 Adding Page Numbers and Dates; 8.7 Understanding Report Sections; 8.8 Grouping and Sorting Records; 8.9 Creating Calculated Controls; 8.10 Working with Section Properties; 8.11 Creating Charts with the Chart Wizard; 8.12 Chapter Eight Review; Chapter 9: Formatting Forms and Reports; 9.1 Formatting Fonts with the Formatting Toolbar; 9.2 Changing Text Alignment; 9.3 Using AutoFormat; 9.4 Changing Colors; 9.5 Applying Special Effects; 9.6 Using the Format Painter; 9.7 Adding Pictures and Lines; 9.8 Aligning Controls with One Another; 9.9 Changing a Control's Formatting Properties; 9.10 Chapter Nine Review; Chapter 10: Working with Macros; 10.1 Creating and Running a Macro; 10.2 Editing a Macro; 10.3 Working with Macro Groups; 10.4 Assigning a Macro to an Event; 10.5 Creating Conditional Expressions; 10.6 Assigning a Macro to a Keystroke Combination; 10.7 Macro Action Reference; 10.8 Chapter Ten Review; Chapter 11: Advanced Topics; 11.1 Importing Information; 11.2 Exporting Information; 11.3 Importing Objects from Another Access Database; 11.4 Linking Information from an External Source; 11.5 Analyzing Records with Microsoft Excel; 11.6 Exporting Records to Microsoft Word; 11.7 Mail Merging Records to Microsoft Word; 11.8 Using Hyperlink Fields; 11.9 Using OLE Object Fields; 11.10 Displaying Database Object Dependencies; 11.11 Chapter Eleven Review; Colophon;