Microsoft® Office Access 2003 Inside Out (Bpg-Inside Out)

dc:abstract'''Hey, you know your way around a database so now dig into Access 2003 and really put your information to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds all in concise, fast-answer format. It s all muscle and no fluff. Discover the best and fastest ways to perform everyday tasks, and challenge yourself to new levels of Access mastery! Build on what you already know about Access and quickly dive into what s new Design your database the way the experts do and sidestep common mistakes Import data from spreadsheets, text files, databases, and other sources Write simple to sophisticated queries to manipulate data Learn advanced techniques for building forms and reports Develop PivotTable and PivotChart dynamic views Tap the power of Microsoft SQL Server with Access projects and views, functions, and stored procedures Implement database security features Deliver dynamic data on the Web with data access pages and XML Use Microsoft Visual Basic for Applications (VBA) and script to automate your applications and Web pages CD features: Complete eBook in PDF format Insider Extras including fully functional sample databases, VBA code, and sample web pages Catalog of Access resources with links to third-party tools and demos Microsoft resources and demos, including Insider s Guide to Microsoft Office OneNote 2003 eBook Microsoft Computer Dictionary, Fifth Edition, eBook 10,000+ entries A Note Regarding the CD or DVDThe print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com. Cover 1 Copyright Page 2 Contents at a Glance 5 Table of Contents 7 Acknowledgments 23 We’d Like to Hear from You! 25 About the CD 27 What’s On the CD 27 Sample Applications 28 Using the CD 29 System Requirements 29 Support Information 29 Conventions and Features Used in This Book 31 Text Conventions 31 Design Conventions 31 Syntax Conventions 33 Introduction 35 Microsoft Access Today 36 About This Book 37 Part 1 Understanding Microsoft Access 41 Chapter 1 What Is Microsoft Access? 43 What Is a Database? 43 Relational Databases 44 Database Capabilities 45 Microsoft Access as an RDBMS 46 Data Definition and Storage 46 Data Manipulation 48 Data Control 51 Microsoft Access as an Application Development System 51 Deciding to Move to Database Software 53 Chapter 2 The Many Faces of Microsoft Access 57 The Architecture of Microsoft Access 57 Exploring a Desktop Database—Housing Reservations 59 Tables 63 Queries 67 Forms 69 Reports 74 Data Access Pages 78 Macros 83 Modules 84 Organizing Your Objects 86 Exploring a Project File—LawTrack Contacts 88 Tables 88 Views, Functions, and Stored Procedures 90 The Many Faces of Microsoft Access 91 Chapter 3 Designing Your Database Application 93 Application Design Fundamentals 93 Step 1: Identifying Tasks 94 Step 2: Charting Task Flow 94 Step 3: Identifying Data Elements 95 Step 4: Organizing the Data 95 Step 5: Designing a Prototype and a User Interface 95 Step 6: Constructing the Application 95 Step 7: Testing, Reviewing, and Refining 96 An Application Design Strategy 96 Analyzing the Tasks 98 Selecting the Data 101 Organizing Tasks 103 Data Analysis 104 Choosing the Database Subjects 104 Mapping Subjects to Your Database 106 Database Design Concepts 107 Waste Is the Problem 107 Normalization Is the Solution 109 Efficient Relationships Are the Result 117 When to Break the Rules 119 Improving Performance of Critical Tasks 119 Capturing Point-In-Time Data 120 Creating Report Snapshot Data 121 Part 2 Building a Microsoft Access Desktop Application 123 Chapter 4 Creating Your Database and Tables 125 Creating a New Database 126 Using a Database Template to Create a Database 126 Creating a New Empty Database 130 Creating Your First Simple Table by Entering Data 132 Creating a Table Using the Table Wizard 134 Creating a Table in Design View 140 Defining Fields 140 Understanding Field Data Types 142 Setting Field Properties 144 Completing the Fields in the Companies Table 150 Defining Simple Field Validation Rules 151 Defining Input Masks 154 Defining a Primary Key 158 Defining a Table Validation Rule 158 Understanding Other Table Properties 161 Defining Relationships 163 Defining Your First Relationship 166 Creating a Relationship on Multiple Fields 168 Adding Indexes 170 Single Field Indexes 170 Multiple-Field Indexes 171 Setting Table Design Options 173 Printing a Table Definition 176 Database Limitations 177 Chapter 5 Modifying Your Table Design 179 Before You Get Started 180 Making a Backup Copy 180 Checking Object Dependencies 182 Deleting Tables 183 Renaming Tables 185 Changing Field Names 186 Moving Fields 190 Inserting Fields 192 Copying Fields 194 Deleting Fields 196 Changing Data Attributes 197 Changing Data Types 197 Changing Data Lengths 202 Dealing with Conversion Errors 203 Changing Other Field Properties 203 Reversing Changes 205 Using the Table Analyzer Wizard 205 Taking a Look at Lookup Properties 211 Changing the Primary Key 216 Compacting Your Database 217 Chapter 6 Importing and Linking Data 219 A Word About Open Database Connectivity (ODBC) -1 Importing vs. Linking Database Files 221 Importing Data and Databases 222 Importing dBASE Files 222 Importing Paradox Files 224 Importing SQL Tables 226 Importing Access Objects 231 Importing Spreadsheet Data 232 Preparing a Spreadsheet 233 Importing a Spreadsheet 234 Fixing Errors 237 Importing Text Files 239 Preparing a Text File 239 Importing a Text File 242 Fixing Errors 246 Modifying Imported Tables 248 Linking Files 248 Security Considerations 249 Performance Considerations 249 Linking Access Tables 251 Linking dBASE and Paradox Files 253 Linking Text and Spreadsheet Files 253 Linking SQL Tables 254 Modifying Linked Tables 256 Unlinking Linked Tables 256 Using the Linked Table Manager 256 Chapter 7 Creating and Working with Simple Queries 259 Selecting Data from a Single Table 261 Specifying Fields 263 Setting Field Properties 264 Entering Selection Criteria 266 Using Expressions 273 Using the Expression Builder 280 Specifying Field Names 285 Sorting Data 287 Testing Validation Rule Changes 289 Checking a New Field Validation Rule 289 Checking a New Table Validation Rule 290 Working in Query Datasheet View 292 Moving Around and Using Keyboard Shortcuts 292 Working with Subdatasheets 294 Changing Data 297 Working with Hyperlinks 304 Sorting and Searching for Data 309 Chapter 8 Building Complex Queries 317 Selecting Data from Multiple Tables 317 Creating Inner Joins 318 Building a Query on a Query 324 Using Outer Joins 327 Using a Query Wizard 333 Summarizing Information with Totals Queries 336 Totals Within Groups 336 Selecting Records to Form Groups 341 Selecting Specific Groups 342 Building Crosstab Queries 342 Partitioning Data in a Crosstab Query 346 Using Query Parameters 348 Customizing Query Properties 350 Controlling Query Output 351 Working with Unique Records and Values 352 Defining a Subdatasheet 355 Other Query Properties 358 Editing and Creating Queries in SQL View 359 Limitations on Using Select Queries to Update Data 363 Creating PivotTables and PivotCharts from Queries 364 Building a Query for a PivotTable 365 Designing a PivotTable 368 Designing a PivotChart 372 Chapter 9 Modifying Data with Action Queries 377 Updating Groups of Rows 377 Testing with a Select Query 378 Converting a Select Query to an Update Query 379 Running an Update Query 380 Updating Multiple Fields 382 Creating a New Table with a Make-Table Query 386 Creating a Make-Table Query 386 Running a Make-Table Query 390 Inserting Data from Another Table 392 Creating an Append Query 393 Running an Append Query 395 Deleting Groups of Rows 396 Testing with a Select Query 396 Using a Delete Query 398 Deleting Inactive Data 399 Troubleshooting Action Queries 400 Solving Common Action Query Errors and Problems 400 Looking at an Error Example 401 Part 3 Creating Forms and Reports in a Desktop Application 403 Chapter 10 Using Forms 405 Uses of Forms 405 A Tour of Forms 406 Headers, Detail Sections, and Footers 406 Multiple-Page Forms 407 Continuous Forms 408 Subforms 409 Pop-Up Forms 410 Modal Forms 411 Special Controls 412 PivotTables and PivotCharts 419 Moving Around on Forms and Working with Data 420 Viewing Data 421 Adding Records and Changing Data 424 Searching for and Sorting Data 431 Performing a Simple Search 432 Performing a Quick Sort on a Form Field 432 Adding a Filter to a Form 432 Printing Forms 434 Chapter 11 Building a Form 437 Forms and Object-Oriented Programming 437 Starting from Scratch—A Simple Input Form 440 Building a New Form with Design Tools 440 Building a Simple Input Form for the tblCompanies Table 451 Customizing Colors and Checking Your Design Results 458 Working with Form Wizards 460 Creating the Basic Products Form with a Form Wizard 460 Modifying the Products Form 464 Simplifying Data Input with a Form 466 Taking Advantage of Combo Boxes and List Boxes 466 Using Toggle Buttons, Check Boxes, and Option Buttons 470 Chapter 12 Customizing a Form 473 Aligning and Sizing Controls 473 Sizing Controls to Fit Content 475 Adjusting Control Layout 479 “Snapping” Controls to the Grid 480 Lining Up Controls 481 Enhancing the Look of a Form 484 Lines and Rectangles 484 Colors and Special Effects 487 Fonts 489 Setting Control Properties 491 Formatting Properties 491 Adding a Scroll Bar 501 Enabling and Locking Controls 502 Setting the Tab Order 502 Adding a Smart Tag 503 Understanding Other Control Properties 505 Setting Form Properties 509 Allowing Different Views 509 Setting Navigation Options 510 Defining a Pop-Up and/or Modal Form 511 Controlling Edits, Deletions, Additions, and Filtering 512 Defining Window Controls 512 Setting the Border Style 513 Understanding Other Form Properties 514 Setting Form and Control Defaults 517 Changing Control Defaults 517 Working with AutoFormat 518 Defining a Template Form 519 Chapter 13 Advanced Form Design 521 Basing a Form on a Multiple-Table Query 522 Creating a Many-to-One Form 522 Creating and Embedding Subforms 527 Specifying the Subform Source 528 Designing the Innermost Subform 530 Designing the First Level Subform 534 Embedding a Subform 535 Specifying the Main Form Source 539 Creating the Main Form 539 Creating a Subdatasheet Subform 542 Displaying Values in an Option Group 544 Using Conditional Formatting 546 Working with the Tab Control 549 Creating Multiple-Page Forms 553 Introducing ActiveX Controls- The Calendar Control 555 Working with PivotChart Forms 558 Building a PivotChart Form 559 Embedding a Linked PivotChart 560 Chapter 14 Using Reports 563 Uses of Reports 563 A Tour of Reports 564 Print Preview—A First Look 565 Headers, Detail Sections, Footers, and Groups 566 Subreports 568 Objects in Reports 570 Printing Reports 572 Print Setup 572 Chapter 15 Constructing a Report 577 Starting from Scratch—A Simple Report 577 Building the Report Query 578 Designing the Report 579 Sorting and Grouping Information 581 Completing the Report 582 Using a Report Wizard 586 Selecting a Report Type 586 Specifying Wizard Options 587 Viewing the Result 592 Chapter 16 Advanced Report Design 595 Building a Query for a Complex Report 596 Creating the Basic Facility Occupancy by Date Report 597 Defining the Sorting and Grouping Criteria 599 Setting Section and Report Properties 602 Section Properties 602 Report Properties 604 Using Calculated Values 612 Adding the Print Date and Page Numbers 612 Performing Calculations 613 Hiding Redundant Values and Concatenating Text Strings 618 Calculating Percentages 620 Using Running Sum 621 Taking Advantage of Conditional Formatting 624 Creating and Embedding a Subreport 625 Understanding Subreport Challenges 626 Building a Report with a Subreport 629 Adding a PivotChart to a Report 632 Designing the PivotChart Form 632 Embedding a PivotChart in a Report 633 Part 4 Designing an Access Project 637 Chapter 17 Building Tables in an Access Project 639 Creating a New Project File 640 Building a New SQL Server Database 640 Connecting to an Existing SQL Server Database 643 Creating a Table in Design View 647 Defining Columns 648 Column Data Types 650 Completing the Columns in the Companies Table 654 Understanding Column Properties 656 Defining a Primary Key 658 Adding Indexes 659 Creating Additional Tables in Contact Tracking 663 Defining Check Constraints 665 Creating Additional Constraint Expressions 668 Defining Relationships 669 Defining Relationships in Table Design View 669 Defining Relationships Using Database Diagrams 672 Setting Table Design Options 675 Chapter 18 Building Queries in an Access Project 677 Building Queries Using the Query Designer 680 Understanding the Query Designer 680 Working with Views 690 Working with In-Line Functions 695 Working with Stored Procedures 701 Building Queries Using a Text Editor 705 Building a Text Stored Procedure 707 Building a Text Scalar Function 721 Building a Text Table-Valued Function 723 Chapter 19 Designing Forms in an Access Project 725 Understanding Form Differences in an Access Project 725 Choosing Option Settings 727 Setting Project Form Properties 729 Setting Recordset Type 732 Understanding Max Records 732 Working with Server Filters 734 Setting Input Parameters 737 Chapter 20 Building Reports in an Access Project 741 Understanding Report Differences in an Access Project 741 Setting Project Report Properties 742 Working with Server Filters 743 Working with Input Parameters 745 Part 5 Automating an Access Application 751 Chapter 21 Understanding Event Processing 753 Access as a Windows Event-Driven Application 753 Understanding Events in Windows 753 Leveraging Access Events to Build an Application 754 Summary of Form and Report Events 755 Opening and Closing Forms and Reports 756 Changing Data 757 Detecting Focus Changes 760 Detecting Filters Applied to Forms 762 Trapping Keyboard and Mouse Events 762 Detecting Changes in PivotTables and PivotCharts 765 Printing 767 Trapping Errors 768 Detecting Timer Expiration 768 Understanding Event Sequence and Form Editing 768 Summary of Macro Actions 771 Opening and Closing Access Objects 772 Printing Data 775 Executing a Query 776 Testing Conditions and Controlling Action Flow 777 Setting Values 778 Searching for Data 779 Building a Custom Menu and Executing Menu Commands 780 Controlling Display and Focus 781 Informing the User of Actions 783 Renaming, Copying, Deleting, Saving, Importing, and Exporting Objects 783 Running Another Application 785 The Macro Design Facility—An Overview 785 Working with the Macro Design Window 785 Defining Multiple Actions 789 Grouping Macros 791 Conditional Expressions 793 Converting Your Macros to Visual Basic 795 Chapter 22 Understanding Visual Basic Fundamentals 797 The Visual Basic Development Environment 798 Modules 798 The Visual Basic Editor Window 800 Working with Visual Basic Debugging Tools 806 Variables and Constants 814 Data Types 815 Variable and Constant Scope 817 Declaring Constants and Variables 818 Const Statement 818 Dim Statement 819 Enum Statement 822 Event Statement 823 Private Statement 824 Public Statement 826 ReDim Statement 827 Static Statement 828 Type Statement 829 Collections, Objects, Properties, and Methods 831 The Access Application Architecture 831 The Data Access Objects (DAO) Architecture 833 The ActiveX Data Objects (ADO) Architecture 835 Referencing Collections, Objects, and Properties 838 Assigning an Object Variable—Set Statement 841 Object Methods 843 Functions and Subroutines 852 Function Statement 852 Sub Statement 854 Understanding Class Modules 855 Property Get 856 Property Let 858 Property Set 860 Controlling the Flow of Statements 863 Call Statement 863 Do...Loop Statement 864 For...Next Statement 865 For Each...Next Statement 866 GoTo Statement 866 If...Then...Else Statement 867 RaiseEvent Statement 868 Select Case Statement 869 Stop Statement 870 While...Wend Statement 870 With...End With Statement 871 Running Macro Actions and Menu Commands 872 DoCmd Object 872 Executing a Menu Command 873 Actions with Visual Basic Equivalents 874 Trapping Errors 874 On Error Statement 874 Some Complex Visual Basic Examples 876 A Procedure to Randomly Load Data 876 A Procedure to Examine All Error Codes 890 Chapter 23 Automating Your Application with Visual Basic 897 Why Aren’t We Using Macros? 897 When to Use Macros 898 When to Use Visual Basic 898 Assisting Data Entry 899 Filling In Related Data 899 Handling the NotInList Event 903 Fixing an E-Mail Hyperlink 907 Providing a Graphical Calendar 907 Working with Linked Photos 912 Validating Complex Data 918 Checking for Possible Duplicate Names 918 Testing for Related Records When Deleting a Record 920 Verifying a Prerequisite 921 Maintaining a Special Unique Value 923 Checking for Overlapping Data 924 Controlling Tabbing on a Multiple-Page Form 926 Automating Data Selection 927 Working with a Multiple-Selection List Box 928 Providing a Custom Query By Form 931 Selecting from a Summary List 938 Filtering One List with Another 939 Linking to Related Data in Another Form or Report 942 Linking Forms Using a Filter 942 Linking to a Report Using a Filter 943 Synchronizing Two Forms Using a Class Event 946 Automating Complex Tasks 949 Triggering a Data Task from a Related Form 949 Linking to a Related Task 953 Calculating a Stored Value 957 Automating Reports 957 Allowing for Used Mailing Labels 957 Drawing on a Report 960 Dynamically Filtering a Report When It Opens 963 Chapter 24 The Finishing Touches 967 Creating Custom Menus and Toolbars 967 Understanding the Customize Toolbar Facility 968 Creating a Custom Form Toolbar 971 Creating a Custom Form Menu Bar 976 Creating Custom Shortcut Menus 980 Setting Form, Form Control, and Report Menu and Toolbar Properties 982 Fine-Tuning with the Performance Analyzer Wizard 984 Disabling Form Design View 986 Defining Switchboard Forms 987 Designing a Switchboard Form from Scratch 987 Using the Switchboard Manager to Design Switchboard Forms 989 Controlling How Your Application Starts and Runs 992 Setting Startup Properties for Your Database 992 Starting and Stopping Your Application 993 Creating an AutoKeys Macro 996 Performing a Final Visual Basic Compile 997 Part 6 Linking Access and the Web 999 Chapter 25 Publishing Data on the Web 1001 Working with the Web 1001 Understanding HTML 1002 Introducing XML 1009 Maintaining Static Web Pages 1011 Creating Dynamic Web Pages 1013 Delivering Dynamic Query Results 1013 Processing Live Data with HTML Forms 1015 Sharing Your Data with SharePoint 1018 Introducing SharePoint 1018 Office and SharePoint 1019 Discovering the Possibilities 1019 Viewing Static HTML Pages 1019 Exploring Active Server Pages 1021 Looking at Data Access Pages 1022 Chapter 26 Creating Static and Dynamic Web Pages 1025 Creating a Static HTML Document 1025 Improving the Look of Exported Data in HTML 1028 Generating an HTML Page from an Access Report 1035 Writing HTML from Visual Basic 1037 Creating a Dynamic Active Server Page 1041 Defining a System Data Source 1041 Exporting Access Data to an Active Server Page 1044 Programming Active Server Pages 1046 Chapter 27 Building Data Access Pages 1055 Introducing Data Access Pages 1056 Underlying Structure of a Data Access Page 1056 Usefulness and Limitations 1057 Types of Pages You Can Create 1058 Designing Data Access Pages 1061 Setting Options for Data Access Pages 1061 Creating Pages Using the Wizards 1063 Understanding the Data Access Page Design Facility 1068 Modifying a Wizard-Generated Data Access Page 1078 Generating Data Access Pages from Forms and Reports 1087 Creating a Data Access Page in Design View 1095 Automating Data Access Pages 1105 Using the Microsoft Script Editor with Data Access Pages 1105 Creating Scripts for Data Access Pages 1108 Updating Data Access Page Links and Connections 1121 Updating Links from Access to Data Access Pages 1121 Updating Connections 1122 Updating Links and Connections from Within Visual Basic 1128 Uploading Your Pages to a Web Server 1130 Copying Pages Using the Windows XP My Web Sites 1131 Publishing Pages Using FTP 1133 Chapter 28 Working with XML and SharePoint 1135 Exploring XML 1135 Well-Formed XML 1136 Understanding XML File Types 1137 Using XML in Microsoft Access 1145 Exporting and Importing XML from the User Interface 1145 Importing and Exporting XML in Visual Basic 1155 Working with SharePoint 1159 Using SharePoint from Access 1161 Using Access from SharePoint 1166 Part 7 After Completing Your Application 1171 Chapter 29 Upsizing a Desktop Application to a Project 1173 Benefits of the Client/Server Architecture 1174 Deciding When to Upsize 1175 Deciding on a Strategy 1177 Upsizing Using the Import Facility 1177 Using the Upsizing Wizard 1178 Preparing Your Desktop Database 1178 General Upsizing Considerations 1178 Preparing Your Tables 1179 Modifying Queries 1181 Changing Forms and Reports 1182 Modifying Your Code 1183 Using the Upsizing Wizard 1187 Ensuring That Your Server Is Started 1188 Running the Wizard 1189 Starting Over If the Wizard Fails 1194 Correcting the Upsize Result 1195 Adding Relationships and Constraints and Fixing Indexes 1195 Correcting Query Problems 1196 Fixing Parameters in Forms and Reports 1199 Fixing Combo Boxes and List Boxes That Use a Large Row Source 1201 Chapter 30 Securing Your Database 1203 Securing a Desktop Database -1 Access Security Architecture 1204 Users, Groups, and Permissions 1205 Using the Security Wizard 1210 Setting Up Your Secured Database 1222 Security Considerations in a Project File 1235 Understanding Macro Security 1237 Chapter 31 Distributing Your Application 1243 Using Linked Tables in a Desktop Database 1244 Taking Advantage of the Database Splitter Utility 1244 Creating Startup Code to Verify and Correct Linked Table Connections 1246 Verifying Server Connection in a Project File 1250 Understanding Runtime Mode 1253 Creating an Execute-Only Database 1254 Creating an Application Shortcut 1255 Understanding the Visual Studio Tools for the Microsoft Office System 1258 Part 8 Appendix 1261 Appendix Installing Microsoft Office 1263 Installing Microsoft Office 1264 Choosing Options When You Have No Previous Version of Office 1264 Choosing Options to Upgrade a Previous Version of Office 1268 Installing the Microsoft SQL Server Data Engine (MSDE) 1270 Managing ODBC Connections 1273 Creating an ODBC System Data Source Name for Microsoft Access 1275 Using ODBC for Connecting to Microsoft SQL Server 1277 Converting from a Previous Release of Microsoft Access 1281 Conversion Issues 1282 Creating an Office Toolbar in Windows XP 1283 Index to Troubleshooting Topics 1287 A 1287 C 1287 D 1287 E 1287 I 1287 L 1287 M 1288 Q 1288 S 1288 T 1288 V 1288 W 1288 About the Author 1289

dc:abstract

Hey, you know your way around a database-so now dig into Access 2003 and really put your information to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds all in concise, fast-answer format. It’s all muscle and no fluff. Discover the best and fastest ways to perform everyday tasks, and challenge yourself to new levels of Access mastery!

• Build on what you already know about Access and quickly dive into what’s new
• Design your database the way the experts do-and sidestep common mistakes
• Import data from spreadsheets, text files, databases, and other sources
• Write simple to sophisticated queries to manipulate data
• Learn advanced techniques for building forms and reports
• Develop PivotTable and PivotChart dynamic views
• Tap the power of Microsoft SQL Server with Access projects and views, functions, and stored procedures
• Implement database security features
• Deliver dynamic data on the Web with data access pages and XML
• Use Microsoft Visual Basic for Applications (VBA) and script to automate your applications and Web pages

CD features:

• Complete eBook in PDF format
• Insider Extras-including fully functional sample databases, VBA code, and sample web pages
• Catalog of Access resources with links to third-party tools and demos
• Microsoft resources and demos, including Insider’s Guide to Microsoft Office OneNote 2003 eBook
• Microsoft Computer Dictionary, Fifth Edition, eBook-10,000+ entries

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

""" Hey, you know your way around a databaseso now dig into Access 2003 and really put your information to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds all in concise, fast-answer format. Its all muscle and no fluff. Discover the best and fastest ways to perform everyday tasks, and challenge yourself to new levels of Access mastery! CD A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com. Hey, you know your way around Microsoft Access—so now dig into Access 2003 and really put your databases to work! This supremely organized reference packs all the information you need to master every major tool, task, and enhancement in Access 2003—without the fluff. Quickly advance your expertise constructing a database, importing and exporting data, building queries, linking data, using forms, creating reports and applications, publishing data on the Web, implementing security features, and other critical functions. YouвЂTMll gain hundreds of timesaving solutions and troubleshooting tips in concise, fast-answer format. You also get the entire book on CD-ROM, along with the Access Productivity Kit, featuring author extras such as sample files; two complete database applications from inside the book; the Microsoft Computer Dictionary, Fifth Edition; and dozens of other resources, including several direct from the Office product group. With INSIDE OUT, youвЂTMll discover the best and fastest ways to perform everyday tasks—and challenge yourself to new levels of Access mastery!