Microsoft Office Access 2003 Inside Out

by Microsoft Corporation, CJ

• ISBN13: 9780735615137
• ISBN10: 0735615136
• Edition: 1st
• Format: Paperback
• Copyright: 2003-10-29
• Publisher: Microsoft Press

Summary

Microsoft Office Access 2003 - Inside Out - reference book - CD, English

Author Biography

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	xxiii
We'd Like to Hear from You!	xxv
About the CD	xxvii
What's on the CD	xxvii
Sample Applications	xxviii
Using the CD	xxiii
System Requirements	xxix
Support Information	xxix
Conventions and Features Used in This Book	xxxi
Text Conventions	xxxi
Design Conventions	xxxi
Syntax Conventions	xxxiii
Introduction	xxxv
Microsoft Access Today	xxxvi
About This Book	xxxvii
Part 1 Understanding Microsoft Access
Chapter 1 What Is Microsoft Access?	3	(14)
What Is a Database?	3	(3)
Relational Databases	4	(1)
Database Capabilities	5	(1)
Microsoft Access as an RDBMS	6	(5)
Data Definition and Storage	6	(2)
Data Manipulation	8	(3)
Data Control	11	(1)
Microsoft Access as an Application Development System	11	(2)
Deciding to Move to Database Software	13	(4)
Chapter 2 The Many Faces of Microsoft Access	17	(36)
The Architecture of Microsoft Access	17	(2)
Exploring a Desktop Database-Housing Reservations	19	(29)
Tables	23	(4)
Queries	27	(2)
Forms	29	(5)
Reports	34	(4)
Data Access Pages	38	(5)
Macros	43	(1)
Modules	44	(2)
Organizing Your Objects	46	(2)
Exploring a Project File-LawTrack Contacts	48	(3)
Tables	48	(2)
Views, Functions, and Stored Procedures	50	(1)
The Many Faces of Microsoft Access	51	(2)
Chapter 3 Designing Your Database Application	53	(32)
Application Design Fundamentals	53	(3)
Step 1: Identifying Tasks	54	(1)
Step 2: Charting Task Flow	54	(1)
Step 3: Identifying Data Elements	55	(1)
Step 4: Organizing the Data	55	(1)
Step 5: Designing a Prototype and a User Interlace	55	(1)
Step 6: Constructing the Application	55	(1)
Step 7: Testing, Reviewing, and Refining	56	(1)
An Application Design Strategy	56	(8)
Analyzing the Tasks	58	(3)
Selecting the Data	61	(2)
Organizing Tasks	63	(1)
Data Analysis	64	(3)
Choosing the Database Subjects	64	(2)
Mapping Subjects to Your Database	66	(1)
Database Design Concepts	67	(12)
Waste Is the Problem	67	(2)
Normalization Is the Solution	69	(8)
Efficient Relationships Are the Result	77	(2)
When to Break the Rules	79	(6)
Improving Performance of Critical Tasks	79	(1)
Capturing Point In Time Data	80	(1)
Creating Report Snapshot Data	81	(4)
Part 2 Building a Microsoft Access Desktop Application
Chapter 4 Creating Your Database and Tables	85	(54)
Creating a New Database	86	(6)
Using a Database Template to Create a Database	86	(4)
Creating a New Empty Database	90	(2)
Creating Your First Simple Table by Entering Data	92	(2)
Creating a Table Using the Table Wizard	94	(6)
Creating a Table in Design View	100	(1)
Defining Fields	100	(18)
Understanding Field Data Types	102	(2)
Setting Field Properties	104	(6)
Completing the Fields in the Companies Table	110	(1)
Defining Simple Field Validation Rules	111	(3)
Defining Input Masks	114	(4)
Defining a Primary Key	118	(1)
Defining a Table Validation Rule	118	(3)
Understanding Other Table Properties	121	(2)
Defining Relationships	123	(7)
Defining Your First Relationship	126	(2)
Creating a Relationship on Multiple Fields	128	(2)
Adding Indexes	130	(3)
Single Field Indexes	130	(1)
Multiple Field Indexes	131	(2)
Setting Table Design Options	133	(3)
Printing a Table Definition	136	(1)
Database Limitations	137	(2)
Chapter 5 Modifying Your Table Design	139	(40)
Before You Get Started	140	(3)
Making a Backup Copy	140	(2)
Checking Object Dependencies	142	(1)
Deleting Tables	143	(2)
Renaming Tables	145	(1)
Changing Field Names	146	(4)
Moving Fields	150	(2)
Inserting Fields	152	(2)
Copying Fields	154	(2)
Deleting Fields	156	(1)
Changing Data Attributes	157	(8)
Changing Data Types	157	(5)
Changing Data Lengths	162	(1)
Dealing with Conversion Errors	163	(1)
Changing Other Field Properties	163	(2)
Reversing Changes	165	(1)
Using the Table Analyzer Wizard	165	(6)
Taking a Look at Lookup Properties	171	(5)
Changing the Primary Key	176	(1)
Compacting Your Database	177	(2)
Chapter 6 Importing and Linking Data	179	(40)
A Word About Open Database Connectivity (ODBC)	179	(2)
Importing vs. Linking Database Files	181	(1)
Importing Data and Databases	182	(10)
Importing dBASE Files	182	(2)
Importing Paradox Files	184	(2)
Importing SQL Tables	186	(5)
Importing Access Objects	191	(1)
Importing Spreadsheet Data	192	(7)
Preparing a Spreadsheet	193	(1)
Importing a Spreadsheet	194	(3)
Fixing Errors	197	(2)
Importing Text Files	199	(9)
Preparing a Text File	199	(3)
Importing a Text File	202	(4)
Fixing Errors	206	(2)
Modifying Imported Tables	208	(1)
Linking Files	208	(11)
Security Considerations	209	(1)
Performance Considerations	209	(2)
Linking Access Tables	211	(2)
Linking dBASE and Paradox Files	213	(1)
Linking Text and Spreadsheet Files	213	(1)
Linking SQL Tables	214	(2)
Modifying Linked Tables	216	(1)
Unlinking Linked Tables	216	(1)
Using the Linked Table Manager	216	(3)
Chapter 7 Creating and Working with Simple Queries	219	(58)
Selecting Data from a Single Table	221	(28)
Specifying Fields	223	(1)
Setting Field Properties	224	(2)
Entering Selection Criteria	226	(7)
Using Expressions	233	(7)
Using the Expression Builder	240	(5)
Specifying Field Names	245	(2)
Sorting Data	247	(2)
Testing Validation Rule Changes	249	(3)
Checking a New Field Validation Rule	249	(1)
Checking a New Table Validation Rule	250	(2)
Working in Query Datasheet View	252	(25)
Moving Around and Using Keyboard Shortcuts	252	(2)
Working with Subdatasheets	254	(3)
Changing Data	257	(7)
Working with Hyperlinks	264	(5)
Sorting and Searching for Data	269	(8)
Chapter 8 Building Complex Queries	277	(60)
Selecting Data from Multiple Tables	277	(16)
Creating Inner Joins	278	(6)
Building a Query on a Query	284	(3)
Using Outer Joins	287	(6)
Using a Query Wizard	293	(3)
Summarizing Information with Totals Queries	296	(12)
Totals Within Groups	296	(5)
Selecting Records to Form Groups	301	(1)
Selecting Specific Groups	302	(1)
Building Orosstab Queries	302	(4)
Partitioning Data in a Orosstab Query	306	(2)
Using Query Parameters	308	(2)
Customizing Query Properties	310	(9)
Controlling Query Output	311	(1)
Working with Unique Records and Values	312	(3)
Defining a Subdatasheet	315	(3)
Other Query Properties	318	(1)
Editing and Creating Queries in SQL View	319	(4)
Limitations on Using Select Queries to Update Data	323	(1)
Creating PivotTables and PivotCharts from Queries	324	(13)
Building a Query for a PivotTable	325	(3)
Designing a PivotTable	328	(4)
Designing a PivotChart	332	(5)
Chapter 9 Modifying Data with Action Queries	337	(28)
Updating Groups of Rows	337	(9)
Testing with a Select Query	338	(1)
Converting a Select Query to an Update Query	339	(1)
Running an Update Query	340	(2)
Updating Multiple Fields	342	(4)
Creating a New Table with a Make-Table Query	346	(6)
Creating a Make Table Query	346	(4)
Running a Make-Table Query	350	(2)
Inserting Data from Another Table	352	(4)
Creating an Append Query	353	(2)
Running an Append Query	355	(1)
Deleting Groups of Rows	356	(4)
Testing with a Select Query	356	(2)
Using a Delete Query	358	(1)
Deleting Inactive Data	359	(1)
Troubleshooting Action Queries	360	(5)
Solving Common Action Query Errors and Problems	360	(1)
Looking at an Error Example	361	(4)
Part 3 Creating Forms and Reports in a Desktop Application
Chapter 10 Using Forms	365	(32)
Uses of Forms	365	(1)
A Tour of Forms	366	(14)
Headers, Detail Sections, and Footers	366	(1)
Multiple-Page Forms	367	(1)
Continuous Forms	368	(1)
Subforms	369	(1)
Pop-Up Forms	370	(1)
Modal Forms	371	(1)
Special Controls	372	(7)
PivotTables and PivotCharts	379	(1)
Moving Around on Forms and Working with Data	380	(11)
Viewing Data	381	(3)
Adding Records and Changing Data	384	(7)
Searching for and Sorting Data	391	(3)
Performing a Simple Search	392	(1)
Performing a Quick Sort on a Form Field	392	(1)
Adding a Filter to a Form	392	(2)
Printing Forms	394	(3)
Chapter 11 Building a Form	397	(36)
Forms and Object-Oriented Programming	397	(3)
Starting from Scratch-A Simple Input Form	400	(20)
Building a New Form with Design Tools	400	(11)
Building a Simple Input Form for the tblCompanies Table	411	(7)
Customizing Colors and Checking Your Design Results	418	(2)
Working with Form Wizards	420	(6)
Creating the Basic Products Form with a Form Wizard	420	(4)
Modifying the Products Form	424	(2)
Simplifying Data Input with a Form	426	(7)
Taking Advantage of Combo Boxes and List Boxes	426	(4)
Using Toggle Buttons, Check Boxes, and Option Buttons	430	(3)
Chapter 12 Customizing a Form	433	(48)
Aligning and Sizing Controls	433	(11)
Sizing Controls to Fit Content	435	(4)
Adjusting Control Layout	439	(1)
"Snapping" Controls to the Grid	440	(1)
Lining Up Controls	441	(3)
Enhancing the Look of a Form	444	(7)
Lines and Rectangles	444	(3)
Colors and Special Effects	447	(2)
Fonts	449	(2)
Setting Control Properties	451	(18)
Formatting Properties	451	(10)
Adding a Scroll Bar	461	(1)
Enabling and Locking Controls	462	(1)
Setting the Tab Order	462	(1)
Adding a Smart Tag	463	(2)
Understanding Other Control Properties	465	(4)
Setting Form Properties	469	(8)
Allowing Different Views	469	(1)
Setting Navigation Options	470	(1)
Defining a Pop-Up and/or Modal Form	471	(1)
Controlling Edits, Deletions, Additions, and Filtering	472	(1)
Defining Window Controls	472	(1)
Setting the Border Style	473	(1)
Understanding Other Form Properties	474	(3)
Setting Form and Control Defaults	477	(4)
Changing Control Defaults	477	(1)
Working with AutoFormat	478	(1)
Defining a Template Form	479	(2)
Chapter 13 Advanced Form Design	481	(42)
Basing a Form on a Multiple-Table Query	482	(5)
Creating a Many-to-One Form	482	(5)
Creating and Embedding Subforms	487	(17)
Specifying the Subform Source	488	(2)
Designing the Innermost Subform	490	(4)
Designing the First Level Subform	494	(1)
Embedding a Subform	495	(4)
Specifying the Main Form Source	499	(1)
Creating the Main Form	499	(3)
Creating a Subdatasheet Subform	502	(2)
Displaying Values in an Option Group	504	(2)
Using Conditional Formatting	506	(3)
Working with the Tab Control	509	(4)
Creating Multiple-Page Forms	513	(2)
Introducing ActiveX Controls-The Calendar Control	515	(3)
Working with PivotChart Forms	518	(5)
Building a PivotChart Form	519	(1)
Embedding a Linked PivotChart	520	(3)
Chapter 14 Using Reports	523	(14)
Uses of Reports	523	(1)
A Tour of Reports	524	(8)
Print Preview-A First Look	525	(1)
Headers, Detail Sections, Footers, and Groups	526	(2)
Subreports	528	(2)
Objects in Reports	530	(2)
Printing Reports	532	(5)
Print Setup	532	(5)
Chapter 15 Constructing a Report	537	(18)
Starting from Scratch-A Simple Report	537	(9)
Building the Report Query	538	(1)
Designing the Report	539	(2)
Sorting and Grouping Information	541	(1)
Completing the Report	542	(4)
Using a Report Wizard	546	(9)
Selecting a Report Type	546	(1)
Specifying Wizard Options	547	(5)
Viewing the Result	552	(3)
Chapter 16 Advanced Report Design	555	(44)
Building a Query for a Complex Report	556	(1)
Creating the Basic Facility Occupancy by Date Report	557	(2)
Defining the Sorting and Grouping Criteria	559	(3)
Setting Section and Report Properties	562	(10)
Section Properties	562	(2)
Report Properties	564	(8)
Using Calculated Values	572	(13)
Adding the Print Date and Page Numbers	572	(1)
Performing Calculations	573	(5)
Hiding Redundant Values and Concatenating Text Strings	578	(2)
Calculating Percentages	580	(1)
Using Running Sum	581	(3)
Taking Advantage of Conditional Formatting	584	(1)
Creating and Embedding a Subreport	585	(7)
Understanding Subreport Challenges	586	(3)
Building a Report with a Subreport	589	(3)
Adding a PivotChart to a Report	592	(7)
Designing the PivotChart Form	592	(1)
Embedding a PivotChart in a Report	593	(6)
Part 4 Designing an Access Project
Chapter 17 Building Tables in an Access Project	599	(38)
Creating a New Project File	600	(7)
Building a New SQL Server Database	600	(3)
Connecting to an Existing SQL Server Database	603	(4)
Creating a Table in Design View	607	(1)
Defining Columns	608	(10)
Column Data Types	610	(4)
Completing the Columns in the Companies Table	614	(2)
Understanding Column Properties	616	(2)
Defining a Primary Key	618	(1)
Adding Indexes	619	(4)
Creating Additional Tables in Contact Tracking	623	(2)
Defining Check Constraints	625	(4)
Creating Additional Constraint Expressions	628	(1)
Defining Relationships	629	(6)
Defining Relationships in Table Design View	629	(3)
Defining Relationships Using Database Diagrams	632	(3)
Setting Table Design Options	635	(2)
Chapter 18 Building Queries in an Access Project	637	(48)
Building Queries Using the Query Designer	640	(25)
Understanding the Query Designer	640	(10)
Working with Views	650	(5)
Working with In Line Functions	655	(6)
Working with Stored Procedures	661	(4)
Building Queries Using a Text Editor	665	(20)
Building a Text Stored Procedure	667	(14)
Building a Text Scalar Function	681	(2)
Building a Text Table Valued Function	683	(2)
Chapter 19 Designing Forms in an Access Project	685	(16)
Understanding Form Differences in an Access Project	685	(7)
Choosing Option Settings	687	(2)
Setting Project Form Properties	689	(3)
Setting Recordset Type	692	(1)
Understanding Max Records	692	(2)
Working with Server Filters	694	(3)
Setting Input Parameters	697	(4)
Chapter 20 Building Reports in an Access Project	701	(12)
Understanding Report Differences in an Access Project	701	(12)
Setting Project Report Properties	702	(11)
Working with Server Filters 7O	O3
Working with Input Parameters 7D	D5
Part 5 Automating an Access Application
Chapter 21 Understanding Event Processing	713	(44)
Access as a Windows Event-Driven Application	713	(2)
Understanding Events in Windows	713	(1)
Leveraging Access Events to Build an Application	714	(1)
Summary of Form and ReporEvents	715	(13)
Opening and Closing Forms and Reports	716	(1)
Changing Data	717	(3)
Detecting Focus Changes	720	(2)
Detecting Filters Applied to Forms	722	(1)
Trapping Keyboard and Mouse Events	722	(3)
Detecting Changes in PivotTables and PivotCharts	725	(2)
Printing	727	(1)
Trapping Errors	728	(1)
Detecting Timer Expiration	728	(1)
Understanding Event Sequence and Form Editing	728	(3)
Summary of Macro Actions	731	(14)
Opening and Closing Access Objects	732	(3)
Printing Data	735	(3)
Executing a Query	738
Testing Conditions and Controlling Action Flow	737	(1)
Setting Values	738	(1)
Searching for Data	739	(1)
Building a Custom Menu and Executing Menu Commands	740	(1)
Controlling Display and Focus	741	(2)
Informing the User of Actions	743	(1)
Rema Renaming, Copying, Deleting, Saving, Importing, and Exporting Objects	743	(2)
Running Another Application	745	(1)
The Macro Design Facility-An Overview	745	(12)
Working with the Macro Design Window	745	(1)
Defining Multiple Action	745	(6)
Grouping Macros	751	(2)
Conditional Expressions	753	(4)
Converting Your Macros to Visual Basic 75S
Chapter 22 Understanding Visual Basic Fundamentals	757	(100)
The Visual Basic Development Environment	758	(16)
Modules	758	(2)
The Visual Basic Editor Window	760	(6)
Working with Visual Basic Debugging Tools	766	(8)
Variables and Constants	774	(4)
Data Types	775	(2)
Variable and Constant Scope	777	(1)
Declaring Constants and Variables	778	(13)
Const Statement	778	(1)
Dim Statement	779	(3)
Enum Statement	782	(1)
Event Statement	783	(1)
Private Statement	784	(2)
Public Statement	786	(1)
ReDim Statement	787	(1)
Static Statement	788	(1)
Type Statement	789	(2)
Collections, Objects, Properties, and Methods	791	(21)
The Access Application Architecture	791	(2)
The Data Access Objects (DAO) Architecture	793	(2)
The ActiveX Data Objects (ADO) Architecture	795	(3)
Referencing Collections, Objects, and Properties	798	(3)
Assigning an Object Variable-Set Statement	801	(2)
Object Methods	803	(9)
Functions and Subroutines	812	(3)
Function Statement	812	(2)
Sub Statement	814	(1)
Understanding Class Modules	815	(8)
Property Get	816	(2)
Property Let	818	(2)
Property Set	820	(3)
Controlling the Flow of Statements	823	(9)
Call Statement	823	(1)
Do...Loop Statement	824	(1)
For...Next Statement	825	(1)
For Each...Next Statement	826	(1)
Go To Statement	826	(1)
If...Then...Else Statement	827	(1)
RaiseEvent Statement	828	(1)
Select Case Stateurent	829	(1)
Stop Statement	830	(1)
While...Wend Statement	830	(1)
With...End With Statement	831	(1)
Running Macro Actions and Menu Commands	832	(2)
DoCmd Object	832	(1)
Executing a Menu Command	833	(1)
Actions with Visual Basic Equivalents	834	(1)
Trapping Errors	834	(2)
On Error Statement	834	(2)
Some Complex Visual Basic Examples	836	(21)
A Procedure to Randomly Load Data	836	(14)
A Procedure to Examine All Error Codes	850	(7)
Chapter 23 Automating Your Application with Visual Basic	857	(70)
Why Aren't We Using Macros?	857	(2)
When to Use Macros	858	(1)
When to Use Visual Basic	858	(1)
Assisting Data Entry	859	(19)
Filling In Related Data	859	(4)
Handling theNotInListEvent	863	(4)
Fixing an EMail Hyperlink	867	(1)
Providing a Graphical Calendar	867	(5)
Working with Linked Photos	872	(6)
Validating Complex Data	878	(8)
Checking for Possible Duplicate Names	878	(2)
Testing for Related Records When Deleting a Record	880	(1)
Verifying a Prerequisite	881	(2)
Maintaining a Special Unique Value	883	(1)
Checking for Overlapping Data	884	(2)
Controlling Tabbing on a Multiple-Page Form	886	(1)
Automating Data Selection	887	(15)
Working with a Multiple-Selection List Box	888	(3)
Providing a Custom Query By Form	891	(7)
Selecting from a Summary List	898	(1)
Filtering One List with Another	899	(3)
Linking to Related Data in Another Form or Report	902	(7)
Linking Forms Using a Filter	902	(1)
Linking to a Report Using a Filter	903	(3)
Synchronizing Two Forms Using a Class Event	906	(3)
Automating Complex Tasks	909	(8)
Triggering a Data Task from a Related Form	909	(4)
Linking to a Related Task	913	(4)
Calculating a Stored Value	917	(1)
Automating Reports	917	(10)
Allowing for Used Mailing Labels	917	(3)
Drawing on a Report	920	(3)
Dynamically Filtering a Report When It Opens	923	(4)
Chapter 24 The Finishing Touches	927	(34)
Creating Custom Menus and Toolbars	927	(17)
Understanding the Customize Toolbar Facility	928	(3)
Creating a Custom Form Toolbar	931	(5)
Creating a Custom Form Menu Bar	936	(4)
Creating Custom Shortcut Menus	940	(2)
Setting Form, Form Control, and Report Menu and Toolbar Properties	942	(2)
Fine-Tuning with the Performance Analyzer Wizard	944	(2)
Disabling Form Design View	946	(1)
Defining Switchboard Forms	947	(5)
Designing a Switchboard Form from Scratch	947	(2)
Using the Switchboard Manager to Design Switchboard Forms	949	(3)
Controlling How Your Application Starts and Runs	952	(5)
Setting Startup Properties for Your Database	952	(1)
Starting and Stopping Your Application	953	(3)
Creating an AutoKeys Macro	956	(1)
Performing a Final Visual Basic Compile	957	(4)
Part 6 Linking Access and the Web
Chapter 25 Publishing Data on the Web	961	(24)
Working with the Web	961	(10)
Understanding HTML	962	(7)
Introducing XML	969	(2)
Maintaining Static Web Pages	971	(2)
Creating Dynamic Web Pages	973	(5)
Delivering Dynamic Query Results	973	(2)
Processing Live Data with HTML Forms	975	(3)
Sharing Your Data with SharePoint	978	(1)
Introducing SharePoint	978	(1)
Office and SharePoint	979	(1)
Discovering the Possibilities	979	(6)
Viewing Static HTML Pages	979	(2)
Exploring Active Server Pages	981	(1)
Looking at Data Access Pages	982	(3)
Chapter 26 Creating Static and Dynamic Web Pages	985	(30)
Creating a Static HTML Document	985	(16)
Improving the Look of Exported Data in HTML	988	(7)
Generating an HTML Page from an Access Report	995	(2)
Writing HTML from Visual Basic	997	(4)
Creating a Dynamic Active Server Page	1001	(14)
Defining a System Data Source	1001	(3)
Exporting Access Data to an Active Server Page	1004	(2)
Programming Active Server Pages	1006	(9)
Chapter 27 Building Data Access Pages	1015	(80)
Introducing Data Access Pages	1016	(5)
Underlying Structure of a Data Access Page	1016	(1)
Usefulness and Limitations	1017	(1)
Types of Pages You Can Create	1018	(3)
Designing Data Access Pages	1021	(44)
Setting Options for Data Access Pages	1021	(2)
Creating Pages Using the Wizards	1023	(5)
Understanding the Data Access Page Design Facility	1028	(10)
Modifying a Wizard-Generated Data Access Page	1038	(9)
Generating Data Access Pages from Forms and Reports	1047	(8)
Creating a Data Access Page in Design View	1055	(10)
Automating Data Access Pages	1065	(16)
Using the Microsoft Script Editor with Data Access Pages	1065	(3)
Creating Scripts for Data Access Pages	1068	(13)
Updating Data Access Page Links and Connections	1081	(9)
Updating Links from Access to Data Access Pages	1081	(1)
Updating Connections	1082	(6)
Updating Links and Connections from Within Visual Basic	1088	(2)
Uploading Your Pages to a Web Server	1090	(5)
Copying Pages Using the Windows XP My Web Sites	1091	(2)
Publishing Pages Using FTP	1093	(2)
Chapter 28 Working with XML and SharePoint	1095	(38)
Exploring XML	1095	(10)
Well-Formed XML	1096	(1)
Understanding XML File Types	1097	(8)
Using XML in Microsoft Access	1105	(14)
Exporting and Importing XML from the User Interface	1105	(10)
Importing and Exporting XML in Visual Basic	1115	(4)
Working with SharePoint	1119	(14)
Using SharePoint from Access	1121	(5)
Using Access from SharePoint	1126	(7)
Part 7 After Completing Your Application
Chapter 29 Upsizing a Desktop Application to a Project	1133	(30)
Benefits of the Client/Server Architecture	1134	(1)
Deciding When to Upsize	1135	(2)
Deciding on a Strategy	1137	(1)
Upsizing Using the Import Facility	1137	(1)
Using the Upsizing Wizard	1138	(1)
Preparing Your Desktop Database	1138	(9)
General Upsizing Considerations	1138	(1)
Preparing Your Tables	1139	(2)
Modifying Queries	1141	(1)
Changing Forms and Reports	1142	(1)
Modifying Your Code	1143	(4)
Using the Upsizing Wizard	1147	(8)
Ensuring That Your Server Is Started	1148	(1)
Running the Wizard	1149	(5)
Starting Over If the Wizard Fails	1154	(1)
Correcting the Upsize Result	1155	(8)
Adding Relationships and Constraints and Fixing Indexes	1155	(1)
Correcting Query Problems	1156	(3)
Fixing Parameters in Forms and Reports	1159	(2)
Fixing Combo Boxes and List Boxes That Use a Large Row Source	1161	(2)
Chapter 30 Securing Your Database	1163	(40)
Securing a Desktop Database	1163	(32)
Access Security Architecture	1164	(1)
Users, Groups, and Permissions	1165	(5)
Using the Security Wizard	1170	(12)
Setting Up Your Secured Database	1182	(13)
Security Considerations in a Project Fi1e	1195	(2)
Understanding Macro Security	1197	(6)
Chapter 31 Distributing Your Application	1203	(20)
Using Linked Tables in a Desktop Database	1204	(9)
Taking Advantage of the Database Splitter Utility	1204	(2)
Creating Startup Code to Verify and Correct Linked Table Connections	1206	(4)
Verifying Server Connection in a Project File	1210	(3)
Understanding Runtime Mode	1213	(1)
Creating an Execute-Only Database	1214	(1)
Creating an Application Shortcut	1215	(3)
Understanding the Visual Studio Tools for the Microsoft Office System	1218	(5)
Part 8 Appendix
Appendix Installing Microsoft Office	1223	(24)
Installing Microsoft Office	1224	(6)
Choosing Options When You Have No Previous Version of Office	1224	(4)
Choosing Options to Upgrade a Previous Version of Office	1228	(2)
Installing the Microsoft SQL Server Data Engine (MSDE)	1230	(3)
Managing ODBC Connections	1233	(8)
Creating an ODBC System Data Source Name for Microsoft Access	1235	(2)
Using ODBC for Connecting to Microsoft SQL Server	1237	(4)
Converting from a Previous Release of Microsoft Access	1241	(2)
Conversion Issues	1242	(1)
Creating an Office Toolbar in Windows XP	1243
Part 9 Articles
Article 1 Understanding SQL	A1
Article 2 Exporting Data	A45
Article 3 Visual Basic Function Reference	A49
Article 4 Internet Explorer Web Page Color Names	A59
Index of Troubleshooting Topics	1247	(2)
Index	1249