did-you-know? rent-now

Rent More, Save More! Use code: ECRENTAL

did-you-know? rent-now

Rent More, Save More! Use code: ECRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

9780735615137

Microsoft Office Access 2003 Inside Out

by
  • ISBN13:

    9780735615137

  • ISBN10:

    0735615136

  • Edition: 1st
  • Format: Paperback
  • Copyright: 2003-10-29
  • Publisher: Microsoft Press
  • Purchase Benefits
  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $49.99

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

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program