Access 2003

Scott Barker has been involved with database development for 17 years since he graduated with a BS in Computer Science in 1986. On the original Microsoft Access team, Scott has worked with Access and SQL Server for over 11 years, written seven books, including F. Scott Barker's Microsoft Access Power Programming, and Database Programming with Visual Basic .NET and ADO.NET. He has trained thousands of developers, and is a frequent speaker at Microsoft conferences around the world. Scott is the father of five, and can be found in Woodinville, Washington, with his wife Diana. Scott is the owner of AppsPlus, a software development company specializing in database development for both the desktop and the Web. You can reach him at www appsplus.com.

HOW TO USE THIS BOOK. 1) ARCHITECT YOUR ACCESS DATABASE. Understanding Relational Databases. Overview of Access. Using the Access Database Wizard. Download Additional Database Templates. Create a Blank Database. Create a New Table Using Data. Create a New Table with the Designer. Create an Input Mask. Add a Validation Rule and Validation Text. Add the Default Value and Required Properties. Specify Lookup Values. Establish Relationships. Link Access Tables. Link SQL Server Tables 2) CREATING QUERIES TO VIEW YOUR INFORMATION. Understanding SQL. Types of Queries Found in Access. Create a Basic Query. Sort Columns. View and Modify SQL Directly. Add Simple Criteria to a Query. Add Complex Criteria to a Query. Create a Parameter Query. Display a Calculated Column. Using Multiple Tables. Update Existing Records. Append New Records. Make a New Table Using a Query. Delete Records. 3) ADVANCED QUERIES. Understanding Join Types. Create an Inner Join. Create Left and Right Outer Join. Summarize Data Using a Totals Query. Retrieve the Top Values. Create a Simple Crosstab Query. Control Order of Headings. Add Row Totals to Your Crosstab Query. Total Up Crosstab Columns. Create Data Definition Queries. 4) WORKING WITH FORMS. Form Basics. Create a Datasheet View Form Using an AutoForm. Move Through the Datasheet. Filter By Selection. Filter By Form. Find and Replace Data in Your Datasheet. Using the Form Wizard. Tools of Form Design View. Introducing Form Properties. Create a Single Page Form Using the Design View. Set Form Properties. Work with Multiple Controls. Create a Form in the Continuous Form View. 5) UTILIZING CONTROLS ON FORMS. Match the Control with the Correct Purpose. Display a Calculated Expression in a Text Box. Correct Control Errors. Create an Option Group Control. Add a Combo Box Control to Limit Data. Utilize Hidden Columns in a Combo Box. Add a List Box Control. Add Smart Tags to Controls. Add a Tab Control to a Form. Add Data to the Tab Control Pages. Add Graphics to a Form. Using a Subform to Display Main/Detail Data. Limit Data in a Subform with a Combo Box. Display a Summarized Subform Column in the Mainform. Using the ActiveX Calendar Control. 6) VBA FOR AUTOMATING YOUR APPLICATION. Understanding VBA Basics. Why Use VBA and Not Macros? Convert Your Macros. Set Up the Integrated Development Environment. Learn to Code from the Command Button Wizard. Using DoCmd to Open Forms and Queries. Using Variables and Constants. Using the MsgBox Statement. Control Branching. Loop Using For...Next. Loop Using Do While/Until. Add Error Handling. 7) USING VBA BEHIND YOUR FORMS. Using Code Behind Forms and Events. Work with Events for Forms and Controls. Syntax for Using Forms and Controls in VBA. Modify Form and Control Properties at Runtime. Using Form and Control Variables. Validate a Required Value Before Updating. Work with Data Behind a Form. Utilize a Combo Box to Locate Records. Toggle a Form's Viewing or Editing. Display or Hide Tab Control Pages. 8) CREATING REPORTS. Introducing Access Reports. Various Report Possibilities. Take Advantage of the Report Wizard. Create a New Report. Work with Calculated Expressions. Hide Rows Based on the Value of a Field. Sort Information on Reports. Add Groupings to a Report. Open a Report Based on a Form Filter. Supply a Parameter Using a Form. Display Different Views of the Same Report. 9) ANALYZING DATA USING PIVOTTABLE AND PIVOTCHART VIEWS. Introducing the Pivot Table and PivotChart. Using the PivotTable Wizard. Add a Filter to the Pivot Table. Using Top/Bottom Values and Other Filters. Display Summary/Detail Data. Create a Simple PivotChart Form. Drill, Filter, and Get Data on PivotCharts. 10) IMPORTING, LINKING, AND EXPORTING DATA. Import or Link Data. Export Data from Access. Using Windows SharePoint Services. Introducing XML. Split and Link an Access Database. Import Data from Microsoft Excel. Import Data from Text Files. Import Data from SQL Server. Import Lists from Windows SharePoint Services. Export, Analyze, and E--mail Data to Excel. Export Data as Text Files. Export Data as XML. Export a Table to Windows SharePoint Services. 11) ACCESSING DATA DIRECTLY WITH ADO. Introducing ActiveX Data Objects. View or Deselect Library References. Create an ADO Connection. Open an ADO Recordset. Move Around and Display Data from the Recordset. Loop Through a Recordset Using Criteria. Manage Records in Recordsets. Execute a Bulk Query Using the ADO Command. Using a Parameter with the ADO Command. 12) AUTOMATING OTHER OFFICE PRODUCTS. Using Automation to Control Other Office Products. Create a Word Document from Access. Add a Bookmark to a Word Document. Insert Access Data into a Bookmarked Word Document. Create an Excel Spreadsheet from Access. Load Recordset Data From Access into Excel. Using the Excel Chart Wizard from Access. Create Outlook E--mail from Access. 13) SECURING ACCESS DATABASES. Work with Security in Access. Using a Single Database Password. Create an Access MDE File. Encode and Decode a Database. Set the Password for VBA Code. Work with Workgroups. Create Groups. Create and Assign Users to Groups. Assign Permissions. Introducing the User--Level Security Wizard. 14) REPLICATING YOUR DATABASE. Introducing Replication. Create a Replica Using Menus. Create a New Briefcase to Replicate a Database. Synchronize Your Replicas. Resolve Data Conflicts. Create a Replica Using VBA. Synchronize Replicas Using VBA. 15) PUBLISHING DATA TO THE INTERNET. Access and the Internet. Set the Hyperlink Properties of Controls. Add and Use a Hyperlink Field in a Table. Using VBA to Follow a Hyperlink. Publish Access Data to HTML. Using the Data Access Page Wizard. Convert Forms and Reports to Data Access Pages. APPENDIX A). Leszynski Naming Conventions for Microsoft Access. APPENDIX B). What's on the CD--ROM. Using the E--Version of this Book. Wiley Publishing, Inc. End--User License Agreement.