Synopses & Reviews
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. 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 doand 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 Extrasincluding 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, eBook10,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 OReilly Medias Digital Distribution services. To download this content, please visit OReillys 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 email@example.com.
Target Audience: Tech-savvy information workers. About the Technology: Office 2003 provides new capabilities, new technologies, and new designs to help information workers and businesses in:
25-Word Description Take your database expertise to the next level! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and handy workarounds for Microsoft Access 2003 in concise, fast-answer format. 75-Word Description 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'll 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'll discover the best and fastest ways to perform everyday tasks--and challenge yourself to new levels of Access mastery! Positioning Statement: Designed for advanced users, this supremely organized, one-volume reference will help you conquer Access 2003--from the inside out!
- Process Management, including XML, task panes, and Smart Tags- Information Intelligence using XML- Consuming Information, making it easier to read, organize, annotate, and analyze data- Information Protection and Control- Effective Teamwork, including Document Workspaces and Meeting Workspaces, instant messaging and presence, integrated task panes, and live e-mail attachments- Coordination and Organization, including new features to help information workers manage and organize projects, information, and tasks
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
- 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
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
About the Author
John L. Viescas is a database expert who provides consulting and training services to companies around the globe. He is the author of numerous books, including Running Microsoft Access 97, Running Microsoft Access 2000, Microsoft Office Access 2003 Inside Out, Building Microsoft Access Applications, and Microsoft Office Access 2007 Inside Out. John has been recognized as a Microsoft MVP since 1993.
Home Page: Viescas Consulting, Inc.
Table of Contents
Acknowledgments; Wed Like to Hear from You!; About the CD; Whats On the CD; Sample Applications; Using the CD; System Requirements; Support Information; Conventions and Features Used in This Book; Text Conventions; Design Conventions; Syntax Conventions; Introduction; Microsoft Access Today; About This Book; Part 1: Understanding Microsoft Access; Chapter 1: What Is Microsoft Access?; What Is a Database?; Microsoft Access as an RDBMS; Microsoft Access as an Application Development System; Deciding to Move to Database Software; Chapter 2: The Many Faces of Microsoft Access; The Architecture of Microsoft Access; Exploring a Desktop DatabaseHousing Reservations; Exploring a Project FileLawTrack Contacts; The Many Faces of Microsoft Access; Chapter 3: Designing Your Database Application; Application Design Fundamentals; An Application Design Strategy; Data Analysis; Database Design Concepts; When to Break the Rules; Part 2: Building a Microsoft Access Desktop Application; Chapter 4: Creating Your Database and Tables; Creating a New Database; Creating Your First Simple Table by Entering Data; Creating a Table Using the Table Wizard; Creating a Table in Design View; Defining Fields; Defining a Primary Key; Defining a Table Validation Rule; Understanding Other Table Properties; Defining Relationships; Adding Indexes; Setting Table Design Options; Printing a Table Definition; Database Limitations; Chapter 5: Modifying Your Table Design; Before You Get Started; Deleting Tables; Renaming Tables; Changing Field Names; Moving Fields; Inserting Fields; Copying Fields; Deleting Fields; Changing Data Attributes; Reversing Changes; Using the Table Analyzer Wizard; Taking a Look at Lookup Properties; Changing the Primary Key; Compacting Your Database; Chapter 6: Importing and Linking Data; A Word About Open Database Connectivity (ODBC); Importing vs. Linking Database Files; Importing Data and Databases; Importing Spreadsheet Data; Importing Text Files; Modifying Imported Tables; Linking Files; Chapter 7: Creating and Working with Simple Queries; Selecting Data from a Single Table; Testing Validation Rule Changes; Working in Query Datasheet View; Chapter 8: Building Complex Queries; Selecting Data from Multiple Tables; Using a Query Wizard; Summarizing Information with Totals Queries; Using Query Parameters; Customizing Query Properties; Editing and Creating Queries in SQL View; Limitations on Using Select Queries to Update Data; Creating PivotTables and PivotCharts from Queries; Chapter 9: Modifying Data with Action Queries; Updating Groups of Rows; Creating a New Table with a Make-Table Query; Inserting Data from Another Table; Deleting Groups of Rows; Troubleshooting Action Queries; Part 3: Creating Forms and Reports in a Desktop Application; Chapter 10: Using Forms; Uses of Forms; A Tour of Forms; Moving Around on Forms and Working with Data; Searching for and Sorting Data; Printing Forms; Chapter 11: Building a Form; Forms and Object-Oriented Programming; Starting from ScratchA Simple Input Form; Working with Form Wizards; Simplifying Data Input with a Form; Chapter 12: Customizing a Form; Aligning and Sizing Controls; Enhancing the Look of a Form; Setting Control Properties; Setting Form Properties; Setting Form and Control Defaults; Chapter 13: Advanced Form Design; Basing a Form on a Multiple-Table Query; Creating and Embedding Subforms; Displaying Values in an Option Group; Using Conditional Formatting; Working with the Tab Control; Creating Multiple-Page Forms; Introducing ActiveX ControlsThe Calendar Control; Working with PivotChart Forms; Chapter 14: Using Reports; Uses of Reports; A Tour of Reports; Printing Reports; Chapter 15: Constructing a Report; Starting from ScratchA Simple Report; Using a Report Wizard; Chapter 16: Advanced Report Design; Building a Query for a Complex Report; Creating the Basic Facility Occupancy by Date Report; Defining the Sorting and Grouping Criteria; Setting Section and Report Properties; Using Calculated Values; Creating and Embedding a Subreport; Adding a PivotChart to a Report; Part 4: Designing an Access Project; Chapter 17: Building Tables in an Access Project; Creating a New Project File; Creating a Table in Design View; Defining Columns; Defining a Primary Key; Adding Indexes; Creating Additional Tables in Contact Tracking; Defining Check Constraints; Defining Relationships; Setting Taaaaaable Design Options; Chapter 18: Building Queries in an Access Project; Building Queries Using the Query Designer; Building Queries Using a Text Editor; Chapter 19: Designing Forms in an Access Project; Understanding Form Differences in an Access Project; Setting Recordset Type; Understanding Max Records; Working with Server Filters; Setting Input Parameters; Chapter 20: Building Reports in an Access Project; Understanding Report Differences in an Access Project; Working with Server Filters; Working with Input Parameters; Part 5: Automating an Access Application; Chapter 21: Understanding Event Processing; Access as a Windows Event-Driven Application; Summary of Form and Report Events; Understanding Event Sequence and Form Editing; Summary of Macro Actions; The Macro Design FacilityAn Overview; Chapter 22: Understanding Visual Basic Fundamentals; The Visual Basic Development Environment; Variables and Constants; Declaring Constants and Variables; Collections, Objects, Properties, and Methods; Functions and Subroutines; Understanding Class Modules; Controlling the Flow of Statements; Running Macro Actions and Menu Commands; Trapping Errors; Some Complex Visual Basic Examples; Chapter 23: Automating Your Application with Visual Basic; Why Arent We Using Macros?; Assisting Data Entry; Validating Complex Data; Controlling Tabbing on a Multiple-Page Form; Automating Data Selection; Linking to Related Data in Another Form or Report; Automating Complex Tasks; Automating Reports; Chapter 24: The Finishing Touches; Creating Custom Menus and Toolbars; Fine-Tuning with the Performance Analyzer Wizard; Disabling Form Design View; Defining Switchboard Forms; Controlling How Your Application Starts and Runs; Performing a Final Visual Basic Compile; Part 6: Linking Access and the Web; Chapter 25: Publishing Data on the Web; Working with the Web; Maintaining Static Web Pages; Creating Dynamic Web Pages; Sharing Your Data with SharePoint; Discovering the Possibilities; Chapter 26: Creating Static and Dynamic Web Pages; Creating a Static HTML Document; Creating a Dynamic Active Server Page; Chapter 27: Building Data Access Pages; Introducing Data Access Pages; Designing Data Access Pages; Automating Data Access Pages; Updating Data Access Page Links and Connections; Uploading Your Pages to a Web Server; Chapter 28: Working with XML and SharePoint; Exploring XML; Using XML in Microsoft Access; Working with SharePoint; Part 7: After Completing Your Application; Chapter 29: Upsizing a Desktop Application to a Project; Benefits of the Client/Server Architecture; Deciding When to Upsize; Deciding on a Strategy; Preparing Your Desktop Database; Using the Upsizing Wizard; Correcting the Upsize Result; Chapter 30: Securing Your Database; Securing a Desktop Database; Security Considerations in a Project File; Understanding Macro Security; Chapter 31: Distributing Your Application; Using Linked Tables in a Desktop Database; Verifying Server Connection in a Project File; Understanding Runtime Mode; Creating an Execute-Only Database; Creating an Application Shortcut; Understanding the Visual Studio Tools for the Microsoft Office System; Part 8: Appendix; Appendix : Installing Microsoft Office; Installing Microsoft Office; Installing the Microsoft SQL Server Data Engine (MSDE); Managing ODBC Connections; Converting from a Previous Release of Microsoft Access; Creating an Office Toolbar in Windows XP; Appendix : Index to Troubleshooting Topics; Appendix : About the Author;