Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Microsoft® Access® 2010 Inside Out
Dedication
Acknowledgments
About the CD
What’s on the CD
Sample Applications
System Requirements
Support Information
Conventions and Features Used in This Book
Text Conventions
Design Conventions
Syntax Conventions
Introduction
Getting Familiar with Access 2010
About This Book
I. Understanding Access
1. What Is Access?
What Is a Database?
Relational Databases
Database Capabilities
Access as an RDBMS
Data Definition and Storage
Data Manipulation
Data Control
Access as an Application Development System
Deciding to Move to Database Software
Extending the Power of Access to the Web
2. Exploring the Access 2010 Interface
Opening Access for the First Time
Getting Started with Access 2010
Opening an Existing Database
Exploring the Microsoft Office Backstage View
Info Tab
Recent Tab
New Tab
Print Tab
Save & Publish Tab
Help Tab
Taking Advantage of the Quick Access Toolbar
Understanding Content Security
Enabling a Database That Is Not Trusted
Understanding the Trust Center
Enabling Content by Defining Trusted Locations
Understanding the Office Fluent Ribbon
Home Tab
Create Tab
External Data Tab
Database Tools Tab
Customizing the Ribbon
Understanding the Navigation Pane
Exploring Navigation Pane Object Views
Working with Custom Categories and Groups
Exploring the Navigation Options Dialog Box
Creating and Modifying a Custom Category
Creating and Modifying Groups in a Custom Category
Creating Object Shortcuts in Custom Groups
Hiding Custom Groups in a Category
Hiding and Renaming Object Shortcuts
Revealing Hidden Shortcuts
Sorting and Selecting Views in the Navigation Pane
Manually Sorting Objects in the Navigation Pane
Searching for Database Objects
Using the Single-Document vs. the Multiple-Document Interface
Modifying Global Settings via the Access Options Dialog Box
3. Access 2010 Overview
The Architecture of Access
Exploring a Desktop Database—Housing Reservations
Tables
Table Window in Design View
Table Window in Datasheet View
Queries
Query Window in Design View
Query Window in Datasheet View
Forms
Form Window in Design View
Form Window in Layout View
Form Window in Form View
Reports
Report Window in Design View
Report Window in Print Preview
Report Window in Layout View
Report Window in Report View
Macros
Modules
What Happened to Project Files (ADP)?
The Many Faces of Access
II. Creating a Database and Tables
4. Designing Client Tables
Creating a New Database
Using a Database Template to Create a Database
Creating a New Empty Database
Creating Your First Simple Table by Entering Data
Creating a Table Using Application Parts
Creating a Table Using Data Type Parts
Creating a Table in Design View
Defining Fields
Understanding Field Data Types
Setting Field Properties
Completing the Fields in the Companies Table
Defining Simple Field Validation Rules
Defining Input Masks
Defining a Primary Key
Defining a Table Validation Rule
Understanding Other Table Properties
Defining Relationships
Defining Your First Relationship
Creating a Relationship on Multiple Fields
Adding Indexes
Single-Field Indexes
Multiple-Field Indexes
Setting Table Design Options
Creating a Default Template for New Databases
Printing a Table Definition
Database Limitations
5. Modifying Your Table Design
Before You Get Started
Making a Backup Copy
Checking Object Dependencies
Deleting Tables
Renaming Tables
Changing Field Names
Moving Fields
Inserting Fields
Copying Fields
Deleting Fields
Changing Data Attributes
Changing Data Types
Changing Data Lengths
Dealing with Conversion Errors
Changing Other Field Properties
Reversing Changes
Using the Table Analyzer Wizard
Taking a Look at Lookup Properties
Working with Multi-Value Lookup Fields
Changing the Primary Key
Compacting Your Database
6. Designing Web Tables
Working with the Web
Creating a New Web Database
Using a Database Template to Create a Web Database
Creating a New Empty Web Database
Creating Your First Simple Web Table by Entering Data
Creating a Web Table Using Application Parts
Using Data Type Parts
Creating Web Tables in Datasheet View
Defining Web Fields
Understanding Web Field Data Types
Setting Field Properties for Web Databases
Completing the Fields in the Vendors Web Table
Creating Calculated Fields
Defining Field Validation Rules for Web Databases
Defining a Table Validation Rule for Web Databases
Defining a Primary Key for Web Databases
Understanding Other Web Table Properties
Creating Lookup Fields in a Web Database
Creating Relationships Using Lookup Fields
Defining a Restrict Delete Relationship
Defining a Cascade Delete Relationship
Using the Web Compatibility Checker
Analyzing the Web Compatibility Issues Table
Preparing a Client Database for the Web
7. Creating Table Data Macros
Uses of Data Macros
The Data Macro Design Facility—An Overview
Redesigning the Macro Window from Previous Versions of Access
Touring the New Logic Designer
Working with Before Events
Before Change
Including Comments
Grouping Macros
Using If Blocks to Create Conditional Expressions
Raising Errors in Data Macros to Cancel Events
Testing Your Data Macro
Defining Multiple Actions
Collapsing and Expanding Actions
Moving Actions
Preventing Duplicate Records Across Multiple Fields
Before Delete
Working with After Events
After Insert
After Update
After Delete
Working with Named Data Macros
Creating Named Data Macros
Saving Named Data Macros
Calling Named Data Macros
Renaming and Deleting Named Data Macros
Analyzing Errors in the USysApplicationLog Table
Using Parameters
Using Local Variables
Working with Return Variables
Debugging Data Macros
Understanding Recursion in Data Macros
Sharing Data Macro Logic
8. Importing and Linking Data
A Word About Open Database Connectivity (ODBC)
Creating a Data Source to Link to an ODBC Database
Importing vs. Linking Database Files
Importing Data and Databases
Importing dBASE Files
Importing SQL Tables
Importing Access Objects
Importing Spreadsheet Data
Preparing a Spreadsheet
Importing a Spreadsheet
Fixing Errors
Importing Text Files
Preparing a Text File
Setting Up Delimited Data
Setting Up Fixed-Width Data
Importing a Text File
Fixing Errors
Modifying Imported Tables
Linking Files
Security Considerations
Performance Considerations
Linking Access Tables
Linking dBASE Files
Linking Text and Spreadsheet Files
Linking SQL Tables
Modifying Linked Tables
Unlinking Linked Tables
Using the Linked Table Manager
Collecting Data via Email
Collecting Data via HTML Forms
Filling Out the HTML Form
Having Outlook Automatically Process the Replies
Collecting Data Using InfoPath Forms
Filling Out the InfoPath Form
Manually Processing the Replies
Managing and Resending Data Collection Messages from Access
Importing and Linking SharePoint Data
Importing a List from a SharePoint Site
Linking a SharePoint List into Access
Saving Import Procedures
III. Building Queries
9. Creating and Working with Simple Queries
Selecting Data from a Single Table
Specifying Fields
Setting Field Properties
Entering Selection Criteria
Working with Dates and Times in Criteria
AND vs. OR
Between, In, and Like
Using Expressions
Creating Text Expressions
Defining Arithmetic Expressions
Using the Expression Builder
Specifying Field Names
Sorting Data
Testing Validation Rule Changes
Checking a New Field Validation Rule
Checking a New Table Validation Rule
Working in Query Datasheet View
Moving Around and Using Keyboard Shortcuts
Working with Subdatasheets
Changing Data
Understanding Record Indicators
Adding a New Record
Selecting and Changing Data
Replacing Data
Copying and Pasting Data
Deleting Rows
Working with Hyperlinks
Activating a Hyperlink
Inserting a New Hyperlink
Editing an Existing Hyperlink
Sorting and Searching for Data
Sorting Data
Searching for and Filtering Data
Using Find
Filtering by Selection
Using the Filter Window
Using Filter by Form
10. Building Complex Queries
Selecting Data from Multiple Tables
Creating Inner Joins
Building a Query on a Query
Using Outer Joins
Building a Simple Outer Join
Solving a Complex “Unmatched” Problem
Using a Query Wizard
Summarizing Information with Totals Queries
Totals Within Groups
Selecting Records to Form Groups
Selecting Specific Groups
Building Crosstab Queries
Creating a Simple Crosstab Query
Partitioning Data in a Crosstab Query
Using Query Parameters
Customizing Query Properties
Controlling Query Output
Working with Unique Records and Values
Defining a Subdatasheet
Other Query Properties
Editing and Creating Queries in SQL View
Limitations on Using Select Queries to Update Data
Creating PivotTables and PivotCharts from Queries
Building a Query for a PivotTable
Designing a PivotTable
Designing a PivotChart
Creating Queries for the Web
11. Modifying Data with Action Queries
Updating Groups of Rows
Testing with a Select Query
Converting a Select Query to an Update Query
Running an Update Query
Updating Multiple Fields
Creating an Update Query Using Multiple Tables or Queries
Creating a New Table with a Make-Table Query
Creating a Make-Table Query
Running a Make-Table Query
Inserting Data from Another Table
Creating an Append Query
Running an Append Query
Deleting Groups of Rows
Testing with a Select Query
Using a Delete Query
Deleting Inactive Data
Troubleshooting Action Queries
Solving Common Action Query Errors and Problems
Looking at an Error Example
IV. Creating Forms
12. Using Forms in an Access Application
Uses of Forms
A Tour of Forms
Headers, Detail Sections, and Footers
Multiple-Page Forms
Continuous Forms
Split Forms
Subforms
Pop-Up Forms
Modal Forms
Special Controls
Option Buttons, Check Boxes, Toggle Buttons, and Option Groups
List Boxes and Combo Boxes
Tab Controls
Attachment Controls
ActiveX Objects
Command Buttons
Navigational Control
Web Browser Control
PivotTables and PivotCharts
Understanding Web Form Limitations
Moving Around on Forms and Working with Data
Viewing Data
Moving Around
Keyboard Shortcuts
Adding Records and Changing Data
Adding a New Record
Changing and Deleting Data
Searching for and Sorting Data
Performing a Simple Search
Using the Search Box
Performing a Quick Sort on a Form Field
Adding a Filter to a Form
Printing Forms
13. Building a Form
Forms and Object-Oriented Programming
Starting from Scratch—A Simple Input Form
Building a New Form with Design Tools
The Form Design Tools Contextual Ribbon Tabs
The Field List
The Property Sheet
Building a Simple Input Form for the tblCompanies Table
Moving and Sizing Controls
The Font Group
The Control Formatting Group
Setting Text Box Properties
Setting Label Properties
Setting Form Properties
Customizing Colors and Checking Your Design Results
Working with Quick Create and the Form Wizard
Creating a Form with the Quick Create Commands
Creating the Basic Products Form with the Form Wizard
Modifying the Products Form
Simplifying Data Input with a Form
Taking Advantage of Combo Boxes and List Boxes
Using Toggle Buttons, Check Boxes, and Option Buttons
Working with Application Part Forms
14. Customizing a Form
Aligning and Sizing Controls in Design View
Sizing Controls to Fit Content
Adjusting the Layout of Controls
“Snapping” Controls to the Grid
Lining Up Controls
Enhancing the Look of a Form
Lines and Rectangles
Colors and Special Effects
Fonts
Setting Control Properties for Client Forms
Formatting Properties
Specifying a Format for Numbers and Currency
Specifying a Format for Text
Specifying a Format for Date/Time
Specifying a Format for Yes/No Fields
Adding a Scroll Bar
Enabling and Locking Controls
Setting the Tab Order
Adding a Smart Tag
Understanding Other Control Properties for Client Forms
Setting Client Form Properties
Allowing Different Views
Setting Navigation Options
Defining a Pop-Up and/or Modal Form
Controlling Edits, Deletions, Additions, and Filtering
Defining Window Controls
Setting the Border Style
Understanding Other Client Form Properties
Setting Client Form and Control Defaults
Changing Control Defaults
Defining a Template Form
Working with Web Forms in Layout View
Starting from Scratch—A Simple Input Web Form
Understanding Control Layouts and Control Anchoring
Lining Up Controls
Moving Controls Within a Control Layout
Formatting a Column of Controls
Resizing Controls
Removing a Control Layout for Client Forms
Splitting and Merging Cells
Inserting Rows and Columns
Using Web-Compatible Controls
Adding Gridlines to Web Forms
Adding Some Space with Control Padding
Creating a Title
Moving Controls to Different Sections on Web Forms
Setting Control Properties for Web Forms
Setting Web Form Properties
Using Themes
Working with Shared Resources
15. Advanced Form Design
Basing a Form on a Multiple-Table Query
Creating a Many-to-One Form
Designing a Many-to-One Query
Designing a Many-to-One Form
Creating and Embedding Subforms
Specifying the Subform Source
Designing the Innermost Subform
Designing the First Level Subform
Embedding a Subform
Specifying the Main Form Source
Creating the Main Form
Creating a Subdatasheet Subform
Displaying Values in an Option Group
Using Conditional Formatting in Client Forms
Working with the Tab Control
Creating Multiple-Page Client Forms
Working with Client PivotChart Forms
Building a Client PivotChart Form
Embedding a Linked PivotChart
Working with Navigation Controls
Using Web Browser Controls
V. Working with Reports
16. Using Reports
Uses of Reports
A Tour of Reports
Print Preview—A First Look
Headers, Detail Sections, Footers, and Groups
Subreports
Objects in Reports
Report View—A First Look
Printing Reports
Print Setup
17. Constructing a Report
Starting from Scratch—A Simple Report
Building the Report Query
Designing the Report
Grouping, Sorting, and Totaling Information
Completing the Report
Using the Report Command
Using the Report Wizard
Specifying Report Wizard Options
Viewing the Result
Working with Web Reports in Layout View
Modifying a Report Command-Created Web Report in Layout View
Completing the Web Report
Building a Web Report in Layout View
Starting with a Blank Web Report
Adding Grouping and Sorting
Working with Control Layouts
Adding Totals to Records
Using Gridlines
Adding the Final Formatting Touches
Understanding Web Report Limitations
18. Advanced Report Design
Building a Query for a Complex Report
Creating the Basic Facility Occupancy By Date Report
Defining the Grouping and Sorting Criteria
Setting Section and Report Properties
Section Properties for Reports
Report Properties
Using Calculated Values
Adding the Print Date and Page Numbers
Performing Calculations
Performing a Calculation on a Detail Line
Adding Values Across a Group
Creating a Grand Total
Hiding Redundant Values and Concatenating Text Strings
Calculating Percentages
Using Running Sum
Taking Advantage of Conditional Formatting
Creating and Embedding a Subreport
Understanding Subreport Challenges
Building a Client Report with a Subreport
Building the Subreport Query
Designing the Subreport
Embedding a Subreport
Adding a PivotChart to a Client Report
Designing the PivotChart Form
Embedding a PivotChart in a Client Report
VI. Automating an Access Application Using Macros
19. Understanding Event Processing
Access as a Windows Event-Driven Application
Understanding Events in Windows
Using Access Events to Build an Application
Summary of Form and Report Events
Understanding Event Sequence and Form Editing
20. Automating a Client Application Using Macros
Uses of Macros
The Macro Design Facility—An Overview
Working with the Logic Designer
Saving Your Macro
Testing Your Macro
Defining Multiple Actions
Working with Submacros
Understanding Conditional Expressions
Using Embedded Macros
Editing an Embedded Macro
Creating an Embedded Macro
Deleting an Embedded Macro
Using Temporary Variables
Trapping Errors in Macros
Understanding Macro Actions That Are Not Trusted
Making Your Application Come Alive with Macros
Referencing Form and Report Objects
Rules for Referencing Forms and Reports
Rules for Referencing Form and Report Properties
Rules for Referencing Form and Report Controls and Their Properties
Rules for Referencing Subforms and Subreports
Opening a Secondary Form
Creating the SeeCityInformation Macro
Synchronizing Two Related Forms
Creating the SyncWeddingListAndCity Macro
Validating Data and Presetting Values
Validating Data
Understanding the ValidateCitySetStateAndZip Macro
Passing Status Information Between Linked Forms
Presetting Values
21. Automating a Web Application Using Macros
Creating Web Macros
Using Macro Objects for Common Functionality
Working with Web Form and Control Events
Passing Parameters to Forms and Reports
Exploring the Invoice Audit Web Form Macros
Using the SetProperty Action with Web Form Controls
Calling Named Data Macros and Using Return Variables
Using BrowseTo Macro Actions to Browse to Forms and Reports
Trapping Error Messages
Checking SharePoint User Permission Group Levels
Performing Different Actions When Opening a Web Form in a Browser
Avoiding Type Coercion Issues
VII. Working with the Web
22. Using Web Applications in a Browser
Working with SharePoint
Publishing Your Database to an Access Services Site
Assigning a Web Display Form
Understanding the Publish Process
Analyzing Publish Errors
Working with Your Application in a Web Browser
Using Forms
Using Reports
Using Datasheet Forms
Waiting for Server Processing
Understanding Session Management
Exploring the Access Services Shell
Downloading a Web Application Back into Access
Setting Site Permissions
Reviewing the Modify Application Page
Working with the Recycle Bin
Extending Your Access Services Application
Using Your Published Web Database in Access
Making Changes to a Published Web Application
Resolving Synchronization Conflicts
Working Offline
Saving a Web Application as a Local Database
Instantiating an Access Services Template
Using an Installed Web Template
Instantiating a Custom Template
23. Using Business Connectivity Services
Understanding Web Services
Introducing Business Connectivity Services
Using XML
Exploring XML
Well-Formed XML
Working with BDC Model Definition Files
Generating Entities
Connecting Data Services in Access
A. Installing Your Software
Installing the Office System
Choosing Options When You Have No Previous Version of the Office System
Choosing Options to Upgrade a Previous Version of the Office System
Converting from a Previous Version of Access
Conversion Issues
Installing the Office 64-Bit Version
Installing the Sample Files
B. About the Authors
Index
VIII. Automating an Access Application Using Visual Basic
24. Understanding Visual Basic Fundamentals
The Visual Basic Development Environment
Modules
Module Objects
Form and Report Modules
The Visual Basic Editor Window
Working with Visual Basic Debugging Tools
Setting Breakpoints
Using the Immediate Window
Executing Visual Basic Commands in the Immediate Window
Using Breakpoints
Working with the Watch Window
Examining the Procedure Call Sequence (Call Stack)
Variables and Constants
Data Types
Variable and Constant Scope
Declaring Constants and Variables
Const Statement
Syntax
Notes
Example
Dim Statement
Syntax
Notes
Examples
Enum Statement
Syntax
Notes
Example
Event Statement
Syntax
Notes
Example
Private Statement
Syntax
Notes
Example
Public Statement
Syntax
Notes
Example
ReDim Statement
Syntax
Notes
Example
Static Statement
Syntax
Notes
Examples
Type Statement
Syntax
Notes
Example
Collections, Objects, Properties, and Methods
The Access Application Architecture
The DAO Architecture
The ADO Architecture
Referencing Collections, Objects, and Properties
When to Use “!” and “.”
Assigning an Object Variable—Set Statement
Syntax
Notes
Examples
Object Methods
Working with DAO Recordsets
Manipulating Complex Data Types Using DAO
Working with ADO Recordsets
Other Uses for Object Methods
Functions and Subroutines
Function Statement
Syntax
Notes
Example
Sub Statement
Syntax
Notes
Example
Understanding Class Modules
Property Get
Syntax
Notes
Examples
Property Let
Syntax
Notes
Examples
Property Set
Syntax
Notes
Examples
Controlling the Flow of Statements
Call Statement
Syntax
Notes
Examples
Do...Loop Statement
Syntax
Notes
Example
For...Next Statement
Syntax
Notes
Example
For Each...Next Statement
Syntax
Notes
Example
GoTo Statement
Syntax
Notes
Example
If...Then...Else Statement
Syntax
Notes
Example
RaiseEvent Statement
Syntax
Notes
Example
Select Case Statement
Syntax
Notes
Example
Stop Statement
Syntax
Notes
While...Wend Statement
Syntax
Notes
Example
With...End Statement
Syntax
Example
Running Macro Actions and Menu Commands
DoCmd Object
Syntax
Notes
Examples
Executing an Access Command
Syntax
Notes
Examples
Actions with Visual Basic Equivalents
Trapping Errors
On Error Statement
Syntax
Notes
Examples
Some Complex Visual Basic Examples
A Procedure to Randomly Load Data
A Procedure to Examine All Error Codes
Working with 64-Bit Access Visual Basic for Applications
Using Declare Statements
Using LongPtr Data Types
Using PtrSafe Attributes
Supporting Older Versions of Access
Understanding Pointer Valued Functions and LongPtr Type Coercion
Using LongLong Data Types
Working with .MDE and .ACCDE files in 64-Bit Environments
25. Automating Your Application with Visual Basic
Why Aren’t We Using Macros?
When to Use Macros
When to Use Visual Basic
Assisting Data Entry
Filling In Related Data
Handling the NotInList Event
Fixing an E-Mail Hyperlink
Providing a Graphical Calendar
Working with Linked Photos
Deleting and Updating an Image Path
Validating Complex Data
Checking for Possible Duplicate Names
Testing for Related Records When Deleting a Record
Verifying a Prerequisite
Maintaining a Special Unique Value
Checking for Overlapping Data
Controlling Tabbing on a Multiple-Page Form
Automating Data Selection
Working with a Multiple-Selection List Box
Providing a Custom Query By Form
Selecting from a Summary List
Filtering One List with Another
Linking to Related Data in Another Form or Report
Linking Forms Using a Filter
Linking to a Report Using a Filter
Synchronizing Two Forms Using a Class Event
Automating Complex Tasks
Triggering a Data Task from a Related Form
Linking to a Related Task
Calculating a Stored Value
Automating Reports
Allowing for Used Mailing Labels
Drawing on a Report
Dynamically Filtering a Report When It Opens
Calling Named Data Macros
IX. After Completing Your Application
26. The Finishing Touches
Creating Custom Ribbons with XML
Creating a USysRibbons Table
Creating a Test Form
Building the Ribbon XML
Hiding Existing Ribbon Elements
Testing Your XML
Creating Tabs
Adding Built-In Groups to Tabs
Loading Ribbon XML
Syntax
Notes
Using Ribbon Attributes
Creating VBA Callbacks
Dynamically Updating Ribbon Elements
Loading Images into Custom Controls
Hiding Options on the Backstage View
Adding Options to the Backstage View
Creating a Custom Quick Access Toolbar
Setting Focus to a Tab
Disabling Layout View
Controlling How Your Application Starts and Runs
Setting Startup Properties for Your Database
Starting and Stopping Your Application
Creating an AutoKeys Macro
Performing a Final Visual Basic Compile
27. Distributing Your Application
Using Linked Tables in a Desktop Database
Taking Advantage of the Database Splitter Wizard
Creating Startup Code to Verify and Correct Linked Table Connections
Understanding Runtime Mode
Creating a Database Template
Creating Custom Data Type Parts
Creating an Execute-Only Database
Creating an Application Shortcut
Encrypting Your Database
Packaging and Signing Your Database
28. Article 1 Designing Your Database Application
Application Design Fundamentals
Step 1: Identifying Tasks
Step 2: Charting Task Flow
Step 3: Identifying Data Elements
Step 4: Organizing the Data
Step 5: Designing a Prototype and a User Interface
Step 6: Constructing the Application
Step 7: Testing, Reviewing, and Refining
An Application Design Strategy
Analyzing the Tasks
Selecting the Data
Organizing Tasks
Data Analysis
Choosing the Database Subjects
Mapping Subjects to Your Database
Database Design Concepts
Waste Is the Problem
Normalization Is the Solution
Field Uniqueness
Rule 1: Each field in a table should represent a unique type of information
Primary Keys
Rule 2: Each table must have a unique identifier, or primary key, that is made up of one or more fields in the table
Functional Dependence
Rule 3: For each unique primary key value, the values in the data columns must be relevant to, and must completely describe, the subject of the table
Field Independence
Rule 4: You must be able to make a change to the data in any field (other than to a field in the primary key) without affecting the data in any other field
Efficient Relationships Are the Result
Foreign Keys
One-to-Many and One-to-One Relationships
Creating Table Links
When to Break the Rules
Improving Performance of Critical Tasks
Capturing Point-in-Time Data
Creating Report Snapshot Data
29. Article 2 Understanding SQL
SQL SELECT Queries
Aggregate Functions: AVG, CHECKSUM_AGG, COUNT, MAX, MIN, STDEV, STDEVP, SUM, VAR, and VARP
BETWEEN Predicate
Syntax
Notes
Example
Column-Name
Syntax
Notes
Examples
Comparison Predicate
Syntax
Notes
Examples
EXISTS Predicate
Syntax
Notes
Example
Expression
Syntax
Notes
Examples
FROM Clause
Syntax
Notes
Example
GROUP BY Clause
Syntax
Notes
Example
HAVING Clause
Syntax
Notes
Example
IN Clause
Syntax
Notes
Example
IN Predicate
Syntax
Notes
Examples
LIKE Predicate
Syntax
Notes
Examples
NULL Predicate
Syntax
Example
ORDER BY Clause
Syntax
Notes
Examples
PARAMETERS Declaration
Syntax
Notes
Example
Quantified Predicate
Syntax
Notes
Examples
Search Condition
Syntax
Notes
Example
SELECT Statement
Syntax
Notes
Examples
Subquery
Syntax
Notes
Examples
TRANSFORM Statement
Syntax
Notes
Example
UNION Query Operator
Syntax
Notes
Example
WHERE Clause
Syntax
Notes
Examples
SQL Action Queries
DELETE Statement
Syntax
Notes
Examples
INSERT Statement (Append Query)
Syntax
Notes
Examples
SELECT . . . INTO Statement (Make-Table Query)
Syntax
Notes
Example
UPDATE Statement
Syntax
Notes
Example
30. Article 3 Exporting Data
Exporting to Another Access Database
Exporting to a Spreadsheet or to a dBASE File
Exporting to a Text File
Exporting to a Mail Merge Document in Word
Exporting to an ODBC Database
Exporting Data to SharePoint
31. Article 4 Function Reference
32. Article 5 Color Names and Codes
33. Article 6 Macro Actions
About the Authors
Copyright
← Prev
Back
Next →
← Prev
Back
Next →