documentation.HELP! Microsoft Office Access 2003 Documentation

Create a join in a query

Microsoft Office Access 2003

previous page next page

Create a join in a query

Enable or disable automatic joins in queries (MDB)
Join tables and queries in a query (MDB)
Create a join between tables on multiple columns in a query (ADP)
Create a join between tables, views, or functions in a query manually (ADP)
previous page start next page

Menu

  • Homepage

Table of contents

  • Startup and Settings
    • What's new in Microsoft Office Access 2003
    • Get started with Access 2003
    • Ways to get started if you've used other database or spreadsheet applications
    • Ways to get started if you're using a database for the first time
    • Access Glossary
    • Access specifications
    • About product activation in Microsoft Office System products
    • What's new in Microsoft Office 2003
    • Disclaimer: Use of Fictitious Names
    • Terms of Use
    • Getting Help
      • Ways to get help on writing code
      • About getting help while you work
      • Get Help for Visual Basic for Applications
      • Get help on Access events and properties
      • About getting Access product help while in the Visual Basic Editor
      • Icons in the Search Results task pane
      • About getting help on SQL Server (ADP)
      • About getting Help on Microsoft Jet SQL
      • Change the appearance of a Help topic
      • Get Script Editor help in a data access page
      • Print a Help topic
      • Sample databases included with Access
      • About the sample XSL transforms that come with Access
      • Troubleshoot Help
      • Tips for better search results
      • The Office Assistant
        • About tips and messages from the Office Assistant
        • Select a different Office Assistant
        • Display tips and messages through the Office Assistant
        • Hide or show the Office Assistant
        • Turn the Office Assistant sound on or off
        • Show or hide the Office Assistant in wizards
      • Other Resources
        • Complete an Office Web-based training course
        • Get help from Microsoft Product Support services
        • Automatically update this list from the Web
        • Microsoft Office Online
          • About Office Communities
          • Search for help, templates, and additional online content on Microsoft Office Online
          • Give feedback for Microsoft Office Online or an Office program
    • Accessibility
      • About accessibility for people with disabilities
      • About creating accessible Office documents
      • Accessibility features in Office Help
      • Using accessibility features in Access
      • Using screen readers with Help
      • Keyboard Shortcuts
        • Keyboard Shortcuts
        • Assign or change a keyboard accelerator
    • Installing and Customizing
      • What's installed with Access 2003
      • Which wizards are installed in Access 2003
      • Change Office's appearance
      • Components and Add-Ins
        • Install or remove individual components in Office
        • Install or uninstall menu add-ins
        • Wizards, builders, and add-ins in Access 2003
        • Register an ActiveX control (OLE custom control)
        • Warn about installed templates and add-ins
      • Customizing the Desktop
        • Show or hide actual fonts in the font list
        • Show or hide the Type a question for help box
        • Show or hide multiple program buttons on the Windows Taskbar
        • Change the screen resolution
        • Show or hide toolbar ScreenTips
        • Show or hide shortcut keys in ScreenTips
        • Show the Tip of the Day when an Office program starts
      • Customizing Access
        • Customize the Access environment by setting defaults
        • Set command-line options for starting Access
        • Startup command-line options
        • Show or hide the task pane at Access startup
        • Show or hide the status bar
        • Turn Microsoft Office Online featured links on or off
        • Change the default folder for new Access databases, Access projects, or pages
        • Change the default behavior for selecting or opening database objects
        • Change default behavior for find or replace operations
        • Set OLE/DDE preferences
        • Specify how the insertion point behaves
        • Turn confirmation messages on or off
        • Specify the default language sort order (MDB)
        • Display four-digit years in all fields and controls containing dates
        • Create your own wizards, builders, and add-ins
        • Set Access run-time options
        • Change the font in SQL and query Design View (MDB)
        • Set the number of files shown in the list of recently used files
        • Tips for improving the performance of Microsoft Access and your system
      • Toolbars and Commands
        • About menus and toolbars
        • Designate a global menu bar or shortcut menu
        • Create a toolbar
        • Add a button, menu, or command
        • Assign a hyperlink to a toolbar button or menu command
        • Delete a toolbar, button, or command
        • Add or delete a shortcut from the My Places bar
        • Move or copy a button, menu, or menu command
        • Rename a toolbar, command, or button
        • Add a submenu to a menu
        • Show only Web toolbar buttons
        • Customize a shortcut menu
        • Group related buttons and menus on a toolbar
        • Move a submenu anywhere on the screen
        • Show or hide a toolbar
        • Add a function to a button or command
        • Add an access key to a menu, command, or button
        • Convert a previous-version menu macro to a menu
        • Import menus and toolbars
        • Move a toolbar
        • Restore original toolbar, button, and command settings
        • Show all buttons or commands
        • Animate menus
        • Resize a toolbar
        • Add, change, or delete sounds used with buttons and menu commands
        • Change a picture on a button
        • Change the size of a toolbar button or drop-down list box
        • Create a custom toolbar
        • Display an icon, text or both on a menu command or button
        • Attach a menu or toolbar to a form or report
        • Display palettes permanently while designing a form or report
        • Add a button to dial a selected phone number
        • Control the display of all built-in toolbars and menus
        • Control whether some or all of the built-in menus are displayed
        • Prevent or allow the changing of toolbars, buttons, or commands
        • Troubleshoot toolbars
      • Customizing an Access Application
        • About startup options
        • Ignore startup options
        • Control how an Access file looks and behaves when it opens
        • Display a form or data access page at startup
        • Control the display of the Database window
        • Display a specific title in the application window title bar
        • Display a custom icon for an application
        • Turn on or off Windows theming for form controls
        • Set ANSI SQL query mode (MDB)
        • Change the default data type and text size (ADP)
        • Specify the default language sort order (MDB)
        • Display four-digit years in all fields and controls containing dates
        • Restricting Special Keys
          • Special keys that can be turned on or off at startup
          • Prevent users from stopping the retrieval of records from the server (ADP)
          • Prevent or allow access to the Visual Basic Editor or the Immediate window
        • User Profiles
          • About customizing your application's environment with user profiles and run-time options
          • Create an Access user profile
      • Windows Registry Settings
        • Customize driver settings
        • Customize Jet database settings (MDB)
      • Adding Custom Help
        • About creating custom Help
        • Create custom Help
        • Create help text for a button or command
      • Troubleshooting Installing Office
        • I can't activate Microsoft Office
        • About Office Safe Mode
        • Enable items that were disabled by Office Safe Mode
        • Automatically repair Office programs
        • Troubleshoot installing an Office program
    • Using Microsoft Office
      • About the default working folder
      • Office programs you can use to create an online or printed form
      • Get information about your program and computer
      • Set the default working folder
      • Automatically start an Office program when you turn on your computer
      • Change the program that starts when you open a file
      • Office programs you can use to create a table
      • Connect to a network drive
      • Create a network place
      • What happened to the Office Shortcut Bar?
      • Minimize a window
      • Minimize all program windows on the Windows desktop
      • Restore a minimized window
      • Show all windows on the Windows desktop
      • Format a disk
      • Office Clipboard
        • Move or copy information between programs
        • About collecting and pasting multiple items
        • Collect and paste among programs
        • Copy the window or screen contents
        • Display the contents of the Office Clipboard
        • Clear items from the Office Clipboard
        • Turn off the Office Clipboard
        • Turn Office Clipboard command options on or off
        • Troubleshoot collecting and pasting
      • Using Microsoft Outlook to Enhance Office Applications
        • About sending e-mail messages
        • About tracking work and finding files with Microsoft Outlook
        • Track work and find files with Outlook
    • Managing Files
      • Working with Files
        • About places to save files
        • About finding files
        • Save a file
        • Find a file
        • Select multiple files
        • Save an Office document as a TIFF file
        • Copy a file
        • Delete a file
        • Move a file
        • Rename a file
        • Troubleshoot saving files
        • Prompt to open a file as read-only
      • File Properties
        • About file properties
        • View file properties
        • Change file properties
        • Create custom file properties for the active document
        • Remove personal or hidden information
        • View all hidden file types and file name extensions
    • Handwriting and Speech
      • Handwriting Recognition
        • About handwriting recognition
        • Install handwriting recognition
        • Use handwriting recognition
        • Handwriting recognition toolbars
        • Change handwriting recognition options
        • Change the handwriting recognition language
        • Correct handwriting
        • Troubleshoot handwriting recognition
        • Handwriting in East Asian Languages
          • About handwriting recognition in East Asian languages
          • Use handwriting recognition in East Asian languages
          • Change handwriting recognition options in East Asian languages
          • Handwriting recognition toolbars in East Asian languages
          • Troubleshoot handwriting recognition in East Asian languages
      • Speech Recognition
        • About speech recognition
        • Show or hide the Language bar
        • Getting started with speech recognition
        • Things you can do and say with speech recognition
        • Use speech recognition
        • How to speak to a computer
        • Position the speech recognition microphone
        • Turn on or off the speech recognition microphone
        • Switch between using Dictation and Voice Command modes
        • Change speech recognition engines
        • Language bar speech recognition messages
        • Troubleshoot speech recognition
        • Installing and Training
          • Install and train speech recognition
          • Create and use speech recognition user profiles
          • Add to or delete from the speech recognition dictionary
          • Correct speech recognition errors
  • Printing
    • Print a record, datasheet, or database object
    • Print mailing labels
    • Print the design of a database or a database object (MDB)
    • Print part of a string as group header
    • Print and preview a database diagram (ADP)
    • Print a Help topic
    • Printer Setup
      • Set up a new printer
      • Set the default printer
    • Print Options
      • Select a paper source
      • Set page setup options for printing
      • Set default print margins
      • Cancel printing
      • Check the progress of your print job
      • Don’t print page header and footer on first and last pages of a report
      • Cancel printing if a report doesn't contain any records
      • Print the group header on the same line as the first detail record
      • Repeat a group header on another page
      • Set the option to print each record, group, or section on a separate page
  • Creating and Working with Databases and Objects
    • About Access databases
    • About designing a database
    • Create an Access database
    • Improve performance of an Access database
    • Use the Performance Analyzer to optimize an Access database
    • Working with Access Files
      • Open an Access database
      • Open a sample database or project
      • Troubleshoot opening files
      • Create a shortcut to open an Access file or database object
      • Open a file
      • Copy or move an Access file
      • Change the default file format
      • Delete an Access file
      • Rename an Access file
      • Troubleshoot finding files
      • About setting a hyperlink base for an Access file
      • Set a hyperlink base for an Access file
      • View the attributes of an Access file
      • Remove personal or hidden information
      • Document the summary information of an Access file or page
      • Create custom properties for use in finding an Access file
      • Modify or delete custom properties of an Access file
      • Graphic filters and file formats Microsoft Access can use
      • About how Access searches for reference libraries
      • Back up and restore an Access database (MDB)
      • Set the number of files shown in the list of recently used files
      • Compacting and Repairing an Access File
        • About compacting and repairing an Access file
        • Compact and repair an Access file
        • Troubleshoot compacting, repairing or recovering an Access file
    • Converting Access Databases
      • About converting an Access file
      • Convert an Access file
      • Access 2002 or later features that aren't available in Access 2000
      • About using an Access file with multiple versions of Access
      • Use an Access file with multiple versions of Access
      • Change the default file format
      • About the Conversion Errors table
      • Troubleshoot using an Access 2000 file with multiple versions of Access
    • Database Objects
      • Tables
        • Troubleshoot tables and field properties (MDB)
        • About tables (MDB)
        • Opening and Viewing Tables
          • Open a database object
          • Switch between views of a database object
        • Creating Tables
          • About creating a table (MDB)
          • About customizing a table (MDB)
          • Create a table (MDB)
          • About the Table Analyzer's query (MDB)
          • Convert a linked table to a local table
          • Split a table into related tables (MDB)
        • Adding and Deleting Fields
          • Add a field to a table (MDB)
          • Guidelines for naming fields, controls, and objects
          • Copy a field and its properties (MDB)
          • Delete a field from a table (MDB)
          • Field Data Types
            • About data types and field sizes (MDB)
            • Field data types available in Access (MDB)
            • About changing a field's data type (MDB)
            • Set or change a field's data type or size (MDB)
          • Fields That Look Up Values
            • About creating a field that looks up or lists values in tables (MDB)
            • Create a field that looks up or lists values in tables (MDB)
        • Customizing Fields
          • Move a column (MDB)
          • About renaming a field in a table (MDB)
          • Rename a field in a table or datasheet (MDB)
          • Set the display format for data in a field or control (MDB)
          • Set the default control type for a field (MDB)
          • About setting the number of decimal places to display in a field or control (MDB)
          • About property sheets
          • Set the number of decimal places to display in a field or control (MDB)
          • Change the starting value of an AutoNumber field (MDB)
          • Set a property in Design view
          • Default Values in Fields
            • About defining a default value that is automatically entered in a field or control (MDB)
            • Set a default value for a field or control (MDB)
            • Examples of default values in fields (MDB)
          • Fields With Blank Values
            • Distinguish between Null values and zero-length strings (MDB)
            • About blank values in fields
            • Make a field accept zero-length strings (MDB)
            • Set properties that control blank values (MDB)
          • Restricting or Validating Data
            • About restricting or validating data (MDB)
            • Examples of field validation rules (MDB)
            • Validate or restrict data entry in tables (MDB)
            • Require users to enter data in a field (MDB)
            • About creating input masks to control how data is entered in a field or control (MDB)
            • Input mask syntax and examples
            • Create an input mask (MDB)
        • Primary Keys and Indexes
          • About primary keys (MDB)
          • Set or change the primary key (MDB)
          • Prevent entry of duplicate values (MDB)
          • Remove the primary key (MDB)
          • View or edit indexes (MDB)
          • About indexing fields and records in an Access database (MDB)
          • Create an index to find and sort records faster (MDB)
          • Delete an index (MDB)
        • Relationships and Referential Integrity
          • View existing relationships (MDB)
          • Edit an existing relationship (MDB)
          • Remove a table from the Relationships window (MDB)
          • Print the design of a database or a database object (MDB)
          • About relationships in an Access database (MDB)
          • About table relationships (ADP)
          • Define relationships between tables (MDB)
          • Create a relationship between tables (ADP)
          • Delete a relationship (MDB)
          • Set or change the join type (MDB)
      • Forms
        • About forms
        • Ways to work with data in a form
        • Troubleshoot forms
        • Opening and Viewing Forms
          • About views of a form
          • Open a database object
          • Switch between views of a database object
        • Creating Forms
          • Create a form
          • About using a template to create a form or report
          • Set the default template for forms and reports
          • Use a predefined format
          • Create, update, or delete an autoformat
          • Bind a blank form or report to one or more tables or queries
        • Customizing Forms
          • Ways to customize a form
          • Change the record source or connection information
          • About creating a form with tabs or page breaks
          • Examples of expressions for page numbers
          • Add a tab or page break control to a form
          • Display a Web page on a form
          • About themes
          • Apply, change, or remove a theme
          • Show title and other informational text
          • Show current date and time
          • Show page numbers
          • Set the size and position of a form or report
          • Customize a form or report window
          • Show or hide shortcut menu
          • Prevent a data-entry form or page from showing existing records
          • Working in Design View
            • Show or hide the field list
            • Show or hide the grid
            • Change the distance between dots on a grid
            • Open or close the toolbox
            • Lock or unlock a toolbox tool
            • About property sheets
            • Set a property in Design view
          • Form Sections
            • About sections of a form
            • Select a section
            • Add or remove a section
            • Show or hide a section
            • Resize a section
            • Keep the contents of a section together
            • Change the background color of a control or section
        • Creating Subforms
          • About subforms
          • Work with subforms
          • Create a subform
          • Change the layout of a subform
          • Make a subform look like a datasheet that displays a header and footer
          • Move between a main form and a subform in Form view
        • Calculating Totals
          • Calculate a total or other aggregate values
          • Calculate a value
          • About calculating a total in a subform and displaying it on a form
        • Validating Data or Restricting Data Access
          • Validate or restrict data in a form
          • Disable a view for a form
          • Make a form or data access page read-only
          • Specify whether a user can set form properties
          • Specify whether a user can add, edit, or delete a record
          • Specify whether a user can move or resize a form or report
          • Prevent a data-entry form or page from showing existing records
        • PivotTable Forms
          • About PivotTable forms
          • Edit a PivotTable form
          • Refresh the data in a PivotTable form
          • Save a copy of a PivotTable form's data
        • Switchboard Forms
          • Create, customize, and delete a switchboard form (MDB)
          • Specify the default switchboard
        • Pop-Up Forms and Custom Dialog Boxes
          • About pop-up forms and reports
          • Create a pop-up form or report
          • Create a dialog box
          • Property settings for pop-up forms and reports
          • Specify a border and title for a pop-up form or report
          • Temporarily open a form as a dialog box
      • Reports
        • About reports
        • Troubleshoot reports
        • Opening and Viewing Reports
          • About views of a report
          • Open a database object
          • Switch between views of a database object
        • Creating Reports
          • Create a report
          • About using a template to create a form or report
          • Set the default template for forms and reports
          • Use a predefined format
          • Create, update, or delete an autoformat
          • Bind a blank form or report to one or more tables or queries
        • Customizing Reports
          • Ways to customize a report
          • Change the record source or connection information
          • Use a predefined format
          • Create, update, or delete an autoformat
          • Specify whether a user can move or resize a form or report
          • Show title and other informational text
          • Show current date and time
          • Set the size and position of a form or report
          • Customize a form or report window
          • Working in Design View
            • Show or hide the field list
            • Show or hide the grid
            • Change the distance between dots on a grid
            • Open or close the toolbox
            • Lock or unlock a toolbox tool
            • About property sheets
            • Set a property in Design view
          • Report Sections
            • About sections of a report
            • Select a section
            • Add or remove a section
            • Show or hide a section
            • Resize a section
            • Keep the contents of a section together
            • Change the background color of a control or section
          • Page Breaks and Page Numbers
            • Add a page break to a report
            • Reset page numbers for each group in a report
            • Examples of expressions for page numbers
            • Show page numbers
        • Calculating Totals and Using Expressions
          • About combining and manipulating text values
          • Calculate a total or other aggregate values
          • Calculate a value
          • Count the number of records in each group or report
          • Example of a report that calculates running sums
          • Calculate a running sum
          • Number each detail record in a group or report
          • Print part of a string as group header
          • Combine text values
        • Creating Mailing and Other Labels
          • About creating and customizing mailing labels
          • Create mailing labels
          • Customize labels created with the Label Wizard
          • Print mailing labels
        • Advanced Reports
          • Create a form to enter report criteria
          • Display report criteria in a report
          • Hide duplicate data in a report
          • Examples of reports that start each group in a new row or column
          • Subreports
            • About subreports
            • Create a subreport
            • Work with subreports
          • Multiple-Column and Crosstab Reports
            • Create a crosstab report
            • Customize a multiple-column report
            • Create a multiple-column report
          • Pop-Up Reports
            • About pop-up forms and reports
            • Create a pop-up form or report
            • Property settings for pop-up forms and reports
            • Specify a border and title for a pop-up form or report
        • Report Snapshots
          • About report snapshots and Snapshot Viewer
          • Create a report snapshot
          • Open a report snapshot
          • Publish a report snapshot to the Web
          • Automate sending a report snapshot in e-mail
          • Troubleshoot report snapshots
      • Queries
        • Opening, Viewing, and Running Queries
          • About updating data
          • Open a database object
          • Switch between views of a database object
          • Set the default view of a database object
          • Stop a query (MDB)
          • Run a query (MDB)
          • When can I update data from a query? (MDB)
          • Troubleshoot queries (MDB)
        • Creating Queries
          • About designing a query (MDB)
          • About types of queries (MDB)
          • Show only the high or low values in a query (MDB)
          • Save the SQL statement for a form or report as a query (MDB)
          • About select and crosstab queries (MDB)
          • Select and Crosstab Queries
            • Create a select or crosstab query (MDB)
          • Action Queries
            • Update one table based on another table (MDB)
            • Create a table from another table with a query
            • Delete duplicate records from a table (MDB)
            • About action queries (MDB)
            • Create a delete query (MDB)
            • Create a table from another table with a query (MDB)
            • Create an append query (MDB)
            • Create an update query (MDB)
          • Parameter Queries
            • About parameter queries that prompt for criteria (MDB)
            • Create a parameter query (MDB)
        • Customizing Queries
          • Working in the Query Design Grid
            • Change a column's width in the design grid (MDB)
            • Move a column (MDB)
            • Add a column in the design grid (MDB)
            • Add all fields in a table to a query in the design grid (MDB)
          • Working with Tables or Queries
            • Add or remove a table or query in the query design grid (MDB)
            • Show or hide table names in the query design grid (MDB)
            • Customize the table and query names in a query (MDB)
            • Prevent showing duplicate records in a query (MDB)
          • Working with Fields
            • About using criteria to retrieve certain records (MDB)
            • About using wildcard characters
            • About working with blank fields in queries (MDB)
            • Select fields to add in the design grid (MDB)
            • Move a field in the design grid (MDB)
            • Show or hide a field in a query's results (MDB)
            • Change a field name in a query (MDB)
            • Customize the display of fields in a query (MDB)
            • Display a combo box from a table as a text box in a query (MDB)
            • Enter criteria to affect when calculations are performed (MDB)
            • Add or remove a field in the design grid (MDB)
          • Setting Properties and Default Options
            • Change a query's permissions (MDB)
            • Set multiuser query options (MDB)
            • About property sheets
            • Set a property in Design view
        • Using Multiple Tables in Queries
          • About joining tables or queries in a query (MDB)
          • Create a lookup column
          • About AutoLookup queries that automatically fill in data (MDB)
          • Enable or disable automatic joins in queries (MDB)
          • Join tables and queries in a query (MDB)
          • Create an AutoLookup query (MDB)
          • Delete a join line in a query (MDB)
          • Change the type of join in a query (MDB)
        • Using Criteria and Expressions to Retrieve Data
          • Enter criteria to retrieve certain records (MDB)
          • Examples of expressions
          • Use the asterisk (*) in the query design grid (MDB)
          • Insert or delete a criteria row in the design grid (MDB)
          • Use expressions in a query (ADP)
          • Where to enter expressions in queries and filters (MDB)
        • Performing Calculations
          • About calculations in a query (MDB)
          • Create a calculated field in a query (MDB)
          • Total records in a query (MDB)
          • Enter criteria to affect when calculations are performed (MDB)
        • SQL Queries
          • About SQL queries (MDB)
          • Create an SQL-specific query (MDB)
          • View, modify, or copy a query's SQL statement (MDB)
          • Create tables from the results of a pass-through query (MDB)
          • Examples of union queries (MDB)
          • Examples of data-definition queries (MDB)
        • ANSI SQL Query Mode
          • About ANSI SQL query mode (MDB)
          • About avoiding the mixing of queries created under different ANSI SQL query modes (MDB)
          • Set ANSI SQL query mode (MDB)
        • Microsoft Jet SQL Reference
          • Glossary
          • What's New
            • What's New in Microsoft Jet 4.0
            • What's New with Jet 4.0 Data Definition Language
            • What's New with Jet 4.0 Data Manipulation Language
            • What's New with Jet 4.0 Windows Registry Settings
            • About Microsoft Jet 4.0 Service Packs
          • Overview
            • SQL Aggregate Functions
            • SQL Expressions
            • SQL Reserved Words
            • SQL Data Types
            • SQL Subqueries
            • ODBC Scalar Functions
            • Calculating Fields in SQL Functions
            • Comparison of Microsoft Jet SQL and ANSI SQL
            • Equivalent ANSI SQL Data Types
            • Using Wildcard Characters in String Comparisons
          • Data Definition Language
            • CREATE TABLE Statement
            • CREATE INDEX Statement
            • CREATE PROCEDURE Statement
            • CREATE USER or GROUP Statement
            • CREATE VIEW Statement
            • ADD USER Statement
            • DROP USER or GROUP Statement
            • ALTER TABLE Statement
            • ALTER USER or DATABASE Statement
            • DROP Statement
            • GRANT Statement
            • REVOKE Statement
          • Data Manipulation Language
            • SELECT Statement
            • SELECT...INTO Statement
            • INSERT INTO Statement
            • UPDATE Statement
            • DELETE Statement
            • EXECUTE Statement
            • TRANSACTION Statement
            • TRANSFORM Statement
            • INNER JOIN Operation
            • LEFT JOIN, RIGHT JOIN Operations
            • UNION Operation
            • PARAMETERS Declaration
            • WITH OWNERACCESS OPTION Declaration
          • Clauses
            • CONSTRAINT Clause
            • FROM Clause
            • GROUP BY Clause
            • HAVING Clause
            • IN Clause
            • ORDER BY Clause
            • PROCEDURE Clause
            • WHERE Clause
          • Functions
            • Avg Function
            • Count Function
            • First, Last Functions
            • Min, Max Functions
            • StDev, StDevP Functions
            • Sum Function
            • Var, VarP Functions
          • Operators and Predicates
            • ALL, DISTINCT, DISTINCTROW, TOP Predicates
            • Between...And Operator
            • In Operator
            • Like Operator
          • Windows Registry Settings for External Data Sources
            • Customizing Windows Registry Settings for Microsoft Jet
            • Creating a Portion in Your Application's Registry Tree to Manage the Settings
            • Using Regedit.exe to Overwrite the Default Settings
            • Initializing the dBASE Database Driver
            • Initializing the Lotus Driver
            • Initializing the Microsoft Excel Driver
            • Initializing the Microsoft Exchange Data Source Driver
            • Initializing the Microsoft Jet 4.0 Database Engine Driver
            • Initializing the Microsoft Jet 3.5 Database Engine Driver
            • Initializing the Microsoft Jet 2.5 Database Engine Driver
            • Initializing the Paradox Database Driver
            • Initializing the Text Data Source Driver
            • Configuring the Microsoft Jet Database Engine for ODBC Access
            • Using the Connection Properties in the Microsoft OLE DB Provider for Jet
            • Using the SetOption Method from DAO
      • Data Access Pages
        • About data access pages
        • Troubleshoot data access pages
        • About securing a data access page
        • Differences between forms, reports, and data access pages
        • Differences in page support between Internet Explorer 5.01 with Service Pack 2 (SP2) and 5.5 or later
        • System requirements for sending and viewing a data access page
        • Publish Web pages
        • Default names for data access page supporting folders
        • About sending a data access page in e-mail
        • Data Access Page Basics
          • Creating Data Access Pages
            • Open a database object
            • Switch between views of a database object
            • Strategies for creating data access pages
            • Create a data access page
            • Convert an existing Web page into a data access page
            • Convert a previous-version data access page
          • Connecting to Data
            • About using connection files
            • Create a connection file
            • Specifying absolute path in the connection string of a page
            • Open a data access page on a Web server in Access
            • Open an Access data file on a network by using a UNC address
            • Set or change the connection information of a data access page
            • Set or change the record source of a data access page section
          • Working in Design View
            • About adding data to a data access page by using the field list
            • Show or hide the field list
            • Refresh the field list of a data access page
            • Show or hide the grid
            • About the data outline
            • Change the distance between dots on a grid
            • Open or close the data outline
            • Open or close the toolbox
            • Lock or unlock a toolbox tool
            • About property sheets
            • Set a property in Design view
          • Saving Data Access Pages
            • About saving an object as a data access page
            • About saving a password in a data access page
            • Save a copy of a data access page to a Web server
            • Save a copy of a data access page to a Web server in Windows Explorer
            • Work with FTP
        • Designing Data Access Pages
          • Changing a Page's Overall Appearance
            • Customize a data access page in Design view
            • Set alternate row color for a data access page
            • Set the section indent for a data access page
            • Show or hide the record selector
            • Remove the placeholder text at the top of a data access page
            • About themes
            • About working with graphics on a data access page
            • Format the body text of a data access page
            • Add or delete an expand control
            • Apply, change, or remove a theme
            • Change the background color of a control or section
            • Customize the expand control on a page
            • Add or delete a record navigation control
            • Customize a record navigation toolbar
          • Calculating Values and Totals
            • Calculate a total or other aggregate values
            • Change the aggregate function of a calculated control
            • Calculate a value
          • Working with Settings
            • Specify whether a group is expanded or collapsed by default on a page
            • Specify default settings for new data access pages
            • Make a form or data access page read-only
            • Set the default control type for a data access page
            • Set the bound span as the default control for a data access page
            • Specify whether a user can add, edit, or delete a record
            • Specify which record source of a page supports edits
            • Define or edit a relationship between record sources in a data access page
            • Set the encoding for a Web page
            • Prevent a data-entry form or page from showing existing records
        • Working with Data Access Pages in Page View
          • Work with data in Page view
          • Get help on working with a data access page in Page view
          • Add, change, or delete the path to a bound picture in Page view
          • Show or hide records in Page view
        • Using Microsoft Office Web Components
          • About Microsoft Office Web Components
          • About installing, licensing, and distributing Office Web Components
          • About View-only mode for Office Web Components
          • Create a PivotTable list on a data access page
          • Activate a PivotTable list, spreadsheet, or chart on a data access page
          • Change the external connection information for a PivotTable list
          • Create a chart for the Web on a data access page
          • Add a spreadsheet to a data access page
          • Make a spreadsheet look like a text box
        • Working with Offline Pages
          • About offline data (ADP)
          • Make a data access page available offline (ADP)
          • Make an offline data access page online (ADP)
          • Switch between offline and online modes of a page (ADP)
          • Synchronize an offline data access page with source data (ADP)
        • Working with Files and Links
          • Show or update the link to a data access page
          • About working with graphics on a data access page
        • Troubleshooting
          • I get a message when I attempt to enter data in Page view.
          • I get the message
          • Troubleshoot data access pages
          • I get the message
          • I get the message
          • Troubleshoot HTML formatted files
          • I get the message
          • I get the message
      • Working with Database Objects
        • Open a database object
        • Switch between views of a database object
        • Set the default view of a database object
        • About copying a database object
        • Copy a database object
        • Delete a database object
        • Rename a database object
        • Preview a database object
        • View a list of database objects
        • Save a database object
        • Save a database object as another object type
        • Show or change the general properties of a database object
        • Set or change the description of a database object
        • Show or hide shortcuts for creating new database objects
        • Show or hide database objects
        • Grouping Database Objects
          • About groups of database objects
          • Group database objects
          • Add a database object to a group
          • Remove a database object from a group
          • Rename a database object in a group
          • Delete or rename a group of database objects
    • Controls and Charts
      • About types of controls in Access
      • Add a field to a form, report, or data access page
      • Troubleshoot controls
      • Labels and Text Boxes
        • Create a label
        • About blank values in fields
        • Create a text box
        • Attach a label to a control
        • Set defaults for labels attached to new controls
        • Change text in a label or command button
        • Set the margins within a label or text box
        • Display text vertically on a form or report
        • Create and customize a scrolling text control
        • Examples of text boxes that grow or shrink when printing forms and reports
        • Make a text box grow or shrink to fit data when printing a form or report
      • Check Boxes, Option Buttons, and Option Groups
        • Create a check box, toggle button, or option button
        • Create an option group
        • Move a control to an option group
      • List Boxes, Combo Boxes, and Drop-Down List Boxes
        • About creating a list box, combo box, or drop-down list box that looks up values
        • Create a list box, combo box, or drop-down list box
        • Specify which row is the default value in a list box or combo box
        • Find a record by selecting a value from a list
        • Properties of list boxes, combo boxes, drop-down list boxes, and Lookup fields
        • Customize a list box, combo box, or drop-down list box
      • Command Buttons
        • Work with command buttons
        • About command buttons
        • Create or modify a command button
        • Create a script for a command button on a data access page
        • Change text in a label or command button
        • Make a command button the default button in a form or custom dialog box
        • Make a command button the Cancel button
      • Tab Controls
        • Customize a tab control
      • Creating Controls
        • About creating controls
        • About setting defaults for a control type
        • Guidelines for naming fields, controls, and objects
        • Bind a control to a field
        • Create a bound span control
        • Set tab order
        • Assign an access key to a control
        • Add an ActiveX control (OLE custom control)
        • HTML elements and classes for controls on a page
        • Draw a rectangle or line
        • Use a grid of grouped lines as a table for displaying data
        • How control properties relate to properties in their underlying fields
        • Show or hide the Property Update Options button
        • Propagate changes in field properties to bound controls
      • Customizing Controls
        • About customizing a control
        • About display formats for fields or controls (MDB)
        • Add or remove scroll bars
        • Move a control to an option group
        • Align controls to each other
        • Change the appearance of the border of a control
        • Change a control to another control type
        • Show or hide a control
        • Change the background color of a control or section
        • Turn on or off Windows theming for form controls
        • Make a control transparent
        • Show a tip when the pointer moves over a control
        • Show instructions for a control in the status bar
        • Select one or more controls
        • Customize the appearance of text in a control
        • Move one or more controls
        • Make a control appear raised, sunken, shadowed, chiseled, or etched
        • Make a control read-only
        • Change default properties for a control type
        • Change the spacing between controls
        • Resize a control
        • Copy formatting from one control to another
        • Base the value of a control on another control
        • Create custom colors
        • Turn Snap To Grid behavior on or off
        • Set a color property to a system color
      • Groups of Controls
        • Group or ungroup controls
        • Select a control that is part of a group
        • Add or remove a control in a group
        • Move or resize a control in a group
      • Pictures and Objects
        • About adding a picture or object
        • Add a picture or object
        • Delete a picture or object
        • Edit a picture or object
        • Make a picture or object read-only
        • Show an icon in place of a picture or object
        • Resize a picture
        • Show alternate text for a picture
        • Update a link to a picture or object
        • Add a picture to a command or toggle button
        • Convert an OLE object to a different version
      • Using Charts in Forms and Reports
        • About charts
        • Add a chart to a form or report
        • About making changes to a chart in a form or report
        • Change the data for a chart in a form or report
        • Change the look of a chart in a form or report
        • Add the Chart button to a toolbar
        • Save disk space with a chart in a form or report
        • Troubleshoot charts in a form or report
      • Conditional Formatting
        • Apply or change conditional formatting on a control
        • Copy the conditional formatting of a control
        • About applying conditional formatting to a control
    • Viewing Dependency Information
      • About object dependencies (MDB)
      • About ignored objects (MDB)
      • View dependency information (MDB)
      • About using Name AutoCorrect to fix errors caused by renaming (MDB)
      • Automatically repair errors caused by renaming (MDB)
      • Troubleshoot Name AutoCorrect (MDB)
      • Troubleshoot viewing dependency information (MDB)
    • Checking for Errors in Forms and Reports
      • About error checking in forms and reports
      • Turn error checking on or off
      • Circular reference
      • Duplicate keyboard shortcut
      • Duplicate option value
      • Expressions must begin with an equal sign (=)
      • Invalid sorting and grouping
      • New unassociated label
      • No such field in the field list
      • Report width is greater than page width
      • Spacebar is not a valid keyboard shortcut
      • Unassociated label and control
      • Unassociated label with keyboard shortcut
    • Working in the Database Window
      • About ways to use the Database window
      • Refresh the Database window
      • Change the appearance of objects in the Database window
      • Display multiple database objects on the Windows taskbar
      • Control the display of the Database window
    • Troubleshooting Databases
      • Troubleshoot converting an Access file
      • Troubleshoot undefined functions and references to projects or libraries
      • Fix a reference to a library
  • Working with Data
    • About analyzing data
    • Adding and Modifying Data
      • Add or edit data
      • Save a record
      • Delete a record
      • Undo changes
      • About compressing the data in a Text, Memo, or Hyperlink field (MDB)
      • Expand a field, property box or text box to make it easier to edit
      • Insert a default value in a field
      • Repeat the value from the previous record
      • Indicate nonexistent data with a zero-length string
      • Turn on or off automatic correction of text and data
      • Type ¢, £, Â¥, & ®, and other characters not on the keyboard
      • I can't display my records again after using the Data Entry command. (MDB)
      • Move between records or fields
      • Record selector symbols
      • About working with data in a datasheet
      • Troubleshoot editing data in a field in Datasheet or Form view
      • Select fields and records
    • Cutting and Copying Data
      • Copy or move data
      • Copy or move a control or other item
      • About pasting data from another application
      • Delete a control or another item
      • Troubleshoot problems when pasting data
    • Finding, Sorting, and Grouping Data
      • Finding and Replacing Data
        • About finding or replacing data
        • Find or replace a value in a field
        • Find a record in a datasheet or form
        • Troubleshoot finding and replacing data
      • Filtering Data
        • About Filters (MDB)
        • Apply a filter (MDB)
        • Create a filter (MDB)
        • Modify a filter (MDB)
        • Remove a filter (MDB)
        • Delete or remove a filter (MDB)
        • Switch between filter windows (MDB)
        • Create a database object from filtered records (MDB)
        • Enable or disable filtering records in a form (MDB)
        • Troubleshoot filters (MDB)
      • Sorting Data
        • About sorting records (MDB)
        • Sort records (MDB)
        • Delete a sort (MDB)
        • Troubleshoot sort (MDB)
      • Grouping Data
        • About grouping records
        • Group records
        • Promote or demote a field, table, or query
        • Merge groups
        • Set the number of records to display in a group
        • Keep a group of records together on a page
        • Change sorting and grouping levels
        • Examples of grouped reports
    • Hyperlinks
      • About hyperlinks
      • Change a hyperlink
      • Change the default formatting of hyperlinks
      • Create a field to store hyperlinks (MDB)
      • Create a hyperlink
      • Create a picture or command button that works as a hyperlink
      • Delete a hyperlink
      • Enter a hyperlink into an existing hyperlink address
      • Troubleshoot hyperlinks
    • Check Spelling
      • Check spelling
      • Choose a custom dictionary for checking spelling
      • Set spelling options
      • Set the language for checking spelling
      • Troubleshoot spelling
    • Viewing Data
      • Datasheets
        • Changing the Appearance of a Datasheet
          • Set defaults for the appearance of datasheets
          • Change font, or font style, size, and color in a datasheet
          • Change the gridline style and background color in a datasheet
          • Freeze and unfreeze columns in a datasheet
          • Show or hide columns in a datasheet
          • Resize a column or row
          • Troubleshoot datasheets and subdatasheets
        • Subdatasheets
          • About subdatasheets
          • Insert or modify a subdatasheet
          • Remove a subdatasheet
          • Expand or collapse a subdatasheet
          • Show or hide the foreign key in a subdatasheet
      • PivotTable and PivotChart Views
        • About designing a PivotTable or PivotChart view
        • Examples of chart types in PivotChart view
        • Elements of a PivotTable or PivotChart view
        • Select an element in PivotTable or PivotChart view
        • Show or hide the Properties dialog box in PivotTable or PivotChart view
        • Troubleshoot PivotTable or PivotChart view
        • Customizing the Layout
          • About customizing the layout of a PivotTable or PivotChart view
          • View information about a field or item in PivotTable view
          • Add, move, or remove a field in PivotTable or PivotChart view
          • Change the chart type in PivotChart view
          • Display multiple charts in PivotChart view
          • Change PivotChart view series to categories, or categories to series
          • Show or hide elements of a PivotTable or PivotChart view
          • Add or change captions, labels, and titles in PivotTable or PivotChart view
        • Formatting a PivotTable or PivotChart View
          • About formatting a PivotTable or PivotChart view
          • Format an element in PivotTable or PivotChart view
          • Format the contents of a PivotTable view to read right to left or left to right
          • Add, remove, or change axes in PivotChart view
          • Add, remove, or change error bars in PivotChart view
          • Add, remove, or change a trendline in PivotChart view
          • Add, remove, or change a legend in PivotChart view
          • Number formats available in PivotTable or PivotChart view
        • Working with Settings
          • Allow multiple selection in a filter field
          • Automatically show items or details in PivotTable view
          • Prevent users from making changes in PivotChart view
        • Working with Data
          • About calculating totals in PivotTable view
          • Customize a total field in PivotTable view
          • Functions available in PivotTable or PivotChart view of a form
          • Summary functions available in PivotTable or PivotChart view
          • Edit a calculated field in PivotTable view
          • Show data as hyperlinks in PivotTable view
          • Plot direct record values in PivotChart view
    • Sharing Data
      • About sharing an Access database on a network (MDB)
      • About saving design changes to a shared Access database (MDB)
      • Share a database (MDB)
      • Split an Access database (MDB)
      • Refresh or requery data
      • Set options for a shared Access database (MDB)
      • Troubleshoot a shared database (MDB)
      • Set OLE/DDE preferences
    • External Data
      • Automate importing, exporting, or linking data
      • About XML data and Access
      • About connections
      • Exporting Data or Objects
        • About exporting data and database objects
        • Export data or database objects
        • Merge tables or queries into Word mail merge files
        • Set options and send objects in electronic mail
        • Data formats you can export to
        • Troubleshoot exporting in Access
        • Export Access data as XML
        • About XSL transformation files
      • Importing and Linking Data or Objects
        • About importing and linking data and database objects
        • Data sources you can import or link
        • Import or link data and objects
        • About using the MSysConf table to optimize your linked SQL database (MDB)
        • View, refresh, or change the file name and path for linked tables (MDB)
        • Create a field to store paths to pictures
        • Refresh the data in a linked picture or object
        • Update a link to a picture or object
        • Use custom colors from another application
        • Delete the link to a linked table in an Access database
        • Troubleshoot importing and linking
      • ODBC and Built-in Drivers
        • About ODBC data sources
        • Set up or change ODBC data sources
        • Differences between ODBC drivers and built-in drivers for external data
  • Expressions
    • About the Expression Builder
    • About expressions
    • About Microsoft Jet Expression Service sandbox mode
    • Functions that are blocked in sandbox mode
    • Troubleshoot expressions
    • Glossary
    • Creating Expressions
      • Create an expression
      • Refer to objects in expressions
      • About referring to an object or its properties in expressions
      • Enable the use of an ActiveX control in expressions
    • Examples of Expressions
      • Examples of expressions
      • Examples of referring to controls in expressions
      • Examples of expressions for page numbers
    • Functions
      • Arrays
        • LBound Function
        • UBound Function
      • Conversion
        • Asc Function
        • Chr Function
        • DateSerial Function
        • DateValue Function
        • Day Function
        • FormatCurrency Function
        • FormatDateTime Function
        • FormatNumber Function
        • FormatPercent Function
        • GUIDFromString Function
        • Hex Function
        • Hour Function
        • Minute Function
        • Month Function
        • Nz Function
        • Oct Function
        • Second Function
        • Str Function
        • StrConv Function
        • TimeSerial Function
        • TimeValue Function
        • Type Conversion Functions
        • Val Function
        • Weekday Function
        • Year Function
      • Database
        • CodeDb Method
        • CreateControl Method
        • CreateForm Method
        • CreateGroupLevel Method
        • CreateObject Function
        • CreateReport Method
        • CreateReportControl Method
        • CurrentDb Method
        • CurrentUser Method
        • DeleteControl Method
        • DeleteReportControl Method
        • GetObject Function
        • HyperlinkPart Method
        • IMEStatus Function
        • Partition Function
        • SysCmd Method
      • Date/Time
        • Date Function
        • DateAdd Function
        • DateDiff Function
        • DateSerial Function
        • DatePart Function
        • DateValue Function
        • Day Function
        • IsDate Function
        • MonthName Function
        • Now Function
        • Time Function
        • Timer Function
        • WeekdayName Function
        • Hour Function
        • Minute Function
        • Month Function
        • Second Function
        • TimeSerial Function
        • TimeValue Function
        • Weekday Function
        • Year Function
      • DDE/OLE
        • DDE Function
        • DDEInitiate Function
        • DDERequest Function
        • CreateObject Function
        • LoadPicture Method
        • GetObject Function
      • Domain Aggregate
        • DAvg Function
        • DCount Function
        • DFirst, DLast Functions
        • DLookup Function
        • DMin, DMax Functions
        • DStDev, DStDevP Functions
        • DSum Function
        • DVar, DVarP functions
      • Error Handling
        • CVErr Function
        • Err Object
        • Error Function
        • IsError Function
      • Financial
        • DDB Function
        • FV Function
        • IPmt Function
        • IRR Function
        • MIRR Function
        • NPer Function
        • Pmt Function
        • PPmt Function
        • PV Function
        • Rate Function
        • SLN Function
        • SYD Function
      • General
        • CodeDb Method
        • Command Function
        • DeleteSetting Statement
        • DoEvents Function
        • Environ Function
        • FileDateTime Function
        • FileLen Function
        • FreeFile Function
        • GetAllSettings Function
        • GetSetting Function
        • QBColor Function
        • RGB Function
        • SaveSetting Statement
        • Shell Function
        • NPV Function
        • Version Property
      • Input/Output
        • CurDir Function
        • Dir Function
        • EOF Function
        • FileAttr Function
        • GetAttr Function
        • Input Function
        • Loc Function
        • LOF Function
        • Seek Function
        • SetAttr Statement
        • Spc Function
        • Tab Function
      • Inspection
        • IsArray Function
        • IsEmpty Function
        • IsMissing Function
        • IsError Function
        • IsNull Function
        • IsDate Function
        • IsNumeric Function
        • IsObject Function
        • TypeName Function
        • VarType Function
      • Math
        • Abs Function
        • Atn Function
        • Cos Function
        • Exp Function
        • Int, Fix Functions
        • Log Function
        • Rnd Function
        • Round Function
        • Sgn Function
        • Sin Function
        • Sqr Function
        • Tan Function
      • Messages
        • InputBox Function
        • MsgBox Function
      • Program Flow
        • Choose Function
        • IIf Function
        • Switch Function
      • SQL Aggregate
        • Avg Function
        • Count Function
        • First, Last Functions
        • Min, Max Functions
        • StDev, StDevP Functions
        • Sum Function
        • Var, VarP Functions
      • Text
        • Asc Function
        • Format Function
        • Chr Function
        • InStr Function
        • InStrRev Function
        • LCase Function
        • Left Function
        • Len Function
        • LTrim, RTrim, and Trim Functions
        • Mid Function
        • Replace Function
        • GUIDFromString Function
        • Right Function
        • Space Function
        • StrComp Function
        • String Function
        • StrReverse Function
        • UCase Function
        • StrConv Function
  • Access Projects
    • Understanding a Microsoft Access Project
      • About an Access project (ADP)
      • About offline data (ADP)
      • About differences between data types in an Access database and Access project
      • About SQL Server 2000 Desktop Engine
      • Install and configure SQL Server 2000 Desktop Engine
      • Ways to deploy an Access project
      • Comparison of functions between Visual Basic for Applications and SQL Server Transact-SQL (ADP)
      • About getting help on SQL Server (ADP)
      • About OLE DB and Data Links
      • Troubleshoot Access projects (ADP)
      • Improve performance of an Access project
      • Change the default data type and text size (ADP)
    • Creating an Access Project
      • Basic Tasks
        • Open an Access project
        • Create an Access project
        • Connect an Access project to a Microsoft SQL Server database (ADP)
        • Install and configure SQL Server 2000 Desktop Engine
        • Link tables in an Access project by using the Link Table Wizard (ADP)
        • Show SQL Server properties (ADP)
        • Drop a database (ADP)
        • Create a lookup column (ADP)
        • Create an input mask (ADP)
        • Back up and restore a database or Access project (ADP)
        • Create a column to store hyperlinks (ADP)
      • Filtering and Sorting Data
        • About filters (ADP)
        • About sorting records (ADP)
        • Apply a filter (ADP)
        • Create a filter (ADP)
        • Delete a local sort (ADP)
        • Delete or remove a filter (ADP)
        • Modify a filter (ADP)
        • Sort records (ADP)
        • Troubleshoot filters (ADP)
        • Troubleshoot sort (ADP)
    • Upsizing from an Access Database
      • About upsizing a Microsoft Access database
      • Upsize your Microsoft Access database
      • Use the Upsizing Wizard
      • Troubleshoot the Upsizing Wizard
    • Designing a Database
      • Columns and Tables
        • About columns and column properties (ADP)
        • Set column properties (ADP)
        • Troubleshoot tables and columns (ADP)
        • Change a column’s identity properties (ADP)
        • About Table Designer (ADP)
        • Add tables to a database diagram or database (ADP)
        • Change a table view in a database diagram (ADP)
        • Hide a table in a database diagram (ADP)
        • Change which properties appear in a database diagram (ADP)
        • Copy columns from one table to another (ADP)
        • Copy a table across database diagrams (ADP)
        • Delete a table from the database (ADP)
        • Delete columns from a table (ADP)
        • Duplicate a table (ADP)
        • Insert columns into a table (ADP)
        • Move columns from one table to another (ADP)
        • Save your work in Table Designer (ADP)
        • Rename a column (ADP)
        • Rename a table (ADP)
        • Resize property columns (ADP)
        • Create a column to store hyperlinks (ADP)
        • About tables (ADP)
      • Constraints, Keys, Indexes, and Triggers
        • Replace a global default value with a default value (ADP)
        • Troubleshoot keys, relationships, and indexes (ADP)
        • Constraints
          • About constraints (ADP)
          • Create a constraint (ADP)
          • Create constraint validation text (ADP)
          • Delete a constraint (ADP)
          • Disable a constraint (ADP)
          • Modify or rename a constraint (ADP)
          • View foreign key constraint attributes (ADP)
        • Keys
          • About keys (ADP)
          • Delete an index (ADP)
        • Indexes
          • Rename an index (ADP)
          • Specify a fill factor for an index (ADP)
          • Update an index (ADP)
          • About indexes (ADP)
          • Create an index (ADP)
        • Triggers
          • About triggers (ADP)
          • Create a trigger (ADP)
          • Delete a trigger (ADP)
          • Open a trigger (ADP)
          • Rename a trigger (ADP)
      • Database Designer
        • About Database Designer (ADP)
        • About Database Designer considerations for SQL Server databases (ADP)
        • Discard changes made in Database Designer or Table Designer (ADP)
        • About large database projects (ADP)
        • Database Diagrams
          • Add labels to relationship lines in a database diagram (ADP)
          • Adjust the table size in a database diagram (ADP)
          • Annotate database diagrams (ADP)
          • Arrange tables automatically in a database diagram (ADP)
          • Create a database diagram (ADP)
          • Interactions among database diagrams and table design windows (ADP)
          • Interactions between database diagrams, table design windows, and the database (ADP)
          • Merge subdiagrams into a master database diagram (ADP)
          • Print and preview a database diagram (ADP)
          • Reconcile a database diagram with a modified database (ADP)
          • Save an entire database diagram (ADP)
          • Save selected tables on a database diagram (ADP)
          • Select multiple objects in a database diagram (ADP)
          • Subdivide a database diagram (ADP)
          • Zoom a database diagram (ADP)
      • Joins and Relationships
        • How the Query Designer represents joins (ADP)
        • About joining tables automatically (ADP)
        • Check existing data when creating a relationship (ADP)
        • Copy primary key column properties to a foreign key column (ADP)
        • Create an outer join in a query (ADP)
        • Create a self-join in a query automatically (ADP)
        • Create a self-join in a query manually (ADP)
        • Enforce referential integrity between tables (ADP)
        • Draw a reflexive relationship (ADP)
        • Troubleshoot keys, relationships, and indexes (ADP)
        • Rename a relationship (ADP)
        • Map many-to-many relationships in a database diagram (ADP)
        • Modify a join operator in a query (ADP)
        • Create a join between tables on multiple columns in a query (ADP)
        • Create a join between tables, views, or functions in a query manually (ADP)
        • Remove a join in a query (ADP)
        • Delete a relationship (ADP)
    • Queries
      • Troubleshoot queries (ADP)
      • Query Designer
        • About the Query Designer layout (ADP)
        • About summary and grouping behavior in the Query Designer (ADP)
        • About using the Query Designer with international data (ADP)
        • About creating queries (ADP)
        • Add columns to a query (ADP)
      • Basic Query Tasks
        • About Query Designer considerations for SQL Server databases (ADP)
        • Add a comment to a query (ADP)
        • Add tables, views, and functions to a query (ADP)
        • Create column aliases in a query (ADP)
        • Create a subquery (ADP)
        • Verify a query (ADP)
        • Create table aliases in a query (ADP)
        • Exclude duplicate rows in a query (ADP)
        • Remove tables, views, or functions from a query (ADP)
        • Reorder output columns in a query (ADP)
        • Include user-defined functions in a query (ADP)
        • Run a parameter query (ADP)
        • About different query types (ADP)
        • Create a query (ADP)
        • Modify an indexed view (ADP)
        • Create and use a parameter query (ADP)
        • Execute a query in the Query Designer (ADP)
        • Create a make-table query (ADP)
        • Create an append query (ADP)
        • Create an update query (ADP)
        • Create a delete query (ADP)
      • Search Conditions
        • Rules and grid-pane conventions for combining search conditions (ADP)
        • Comparison operators (ADP)
        • Logical operators (ADP)
        • Select rows that do not match a value in a query (ADP)
        • Rules for entering search values (ADP)
        • Specify search conditions (ADP)
        • Examples of using wildcard characters (ADP)
      • Expressions and Calculations
        • About aggregate functions (ADP)
        • About expressions in queries (ADP)
        • Group rows in query results (ADP)
        • Summarize or aggregate values for all rows in a query (ADP)
        • Summarize or aggregate values using custom expressions (ADP)
        • Use HAVING and WHERE clauses in the same query (ADP)
        • Transact SQL scalar functions for expressions (ADP)
        • Count rows in a query (ADP)
    • Sharing and Updating Data
      • About handling concurrent updates (ADP)
      • Set the number of records retrieved in an Access project (ADP)
      • About copying data and databases in an Access project (ADP)
      • Ways to deploy an Access project
      • Copy or transfer a SQL Server database (ADP)
      • Troubleshoot copying, transferring, and linking to a SQL Server database (ADP)
      • Troubleshoot updating data (ADP)
      • About updating data in an Access project
    • Making an Access Project More Secure
      • About securing an Access project (ADP)
      • About securing Visual Basic for Applications code in Access projects
      • Protect a Microsoft Access project (ADP)
      • Selecting the type of security validation used when logging on to SQL Server (ADP)
      • About enabling the System Administrator (SA) user name in an Access project
      • Enable or disable the System Administration (SA) user name in an Access project (ADP)
      • Change an encrypted view in an Access project (ADP)
      • About ADE files (ADP)
    • Query, Table, and Database Designer Reference
      • Summary of dialog box Help in Microsoft Access Project Designers
      • Summary of extended properties in a Microsoft Access Project
      • Summary of messages in Microsoft Access Project Designers
    • Similarities between Access Databases and Projects
      • About filters
      • About indexes
      • About keys
      • About queries
      • About sorting records
      • About table relationships
      • About tables
      • Add columns to a query
      • Apply a filter
      • Backup and restore an Access file
      • Create a delete query
      • Create a filter
      • Create a join in a query
      • Create a relationship between tables
      • Create an append query
      • Create an index
      • Create an input mask
      • Create an update query
      • Create and use a parameter query
      • Delete a join in a query
      • Delete a relationship
      • Delete a sort
      • Delete an index
      • Delete or remove a filter
      • Exclude duplicate rows in a query
      • Modify a filter
      • Modify a join in a query
      • Run a query
      • Sort records
      • Total records in a query
      • Troubleshoot filters
      • Troubleshoot queries
      • Troubleshoot sort
  • Database Replication
    • Understanding Replication
      • Changes made to your database when you use replication (MDB)
      • About choosing a tool for replication (MDB)
      • About changing the design of a replicated database (MDB)
      • About the replica set retention period setting (MDB)
      • About AutoNumber field size and replicated databases (MDB)
      • Troubleshoot replication (MDB)
    • Replicating a Database
      • Create a replicated database (MDB)
      • Methods and properties used to programmatically replicate a database (MDB)
      • Make a replicated database a regular database (MDB)
    • Replica Visibility
      • About replica visibility (MDB)
      • A comparison of global, local, and anonymous replicas (MDB)
    • Synchronizing Data
      • About choosing a synchronization method (MDB)
      • About synchronization conflicts (MDB)
      • Synchronize and resolve conflicts in a replica set (MDB)
      • About setting replica priority (MDB)
  • Security and Privacy
    • Security
      • Overview of Access security (MDB)
      • Troubleshoot security (MDB)
      • About making connections to external data sources more secure
      • Making an Access File More Secure
        • About distributing a security-enhanced application (MDB)
        • About user-level security (MDB)
        • Remove user-level security (MDB)
        • Help protect an Access database and its objects with user-level security (MDB)
        • Security Zones in Access
        • Create, join, or fix workgroup information files (MDB)
        • Manage user and group accounts (MDB)
        • Types of permissions (MDB)
        • About securing a replicated database (MDB)
      • Making an Access Project More Secure
        • About securing an Access project (ADP)
        • About securing Visual Basic for Applications code in Access projects
        • Protect a Microsoft Access project (ADP)
        • Selecting the type of security validation used when logging on to SQL Server (ADP)
        • About enabling the System Administrator (SA) user name in an Access project
        • Enable or disable the System Administration (SA) user name in an Access project (ADP)
        • Change an encrypted view in an Access project (ADP)
      • Protecting Code
        • About securing Visual Basic for Applications code in Access databases (MDB)
        • Troubleshoot Visual Basic code security (MDB)
        • About securing Visual Basic for Applications code in Access projects
        • Remove a Visual Basic for Applications code password
        • About MDE and ADE files
        • About MDE files (MDB)
      • Passwords
        • About passwords (MDB)
        • Create, change, or remove passwords (MDB)
        • About linking tables from a password-protected database (MDB)
        • Troubleshoot passwords (MDB)
      • Digital Signatures
        • About digital signatures
        • Add a digital signature to macro project
        • Remove a digital signature
        • Create your own digital certificate
        • Review digital certificates for a macro project
      • Macros
        • About helping protect files from macro viruses
        • Macro security levels
        • Change the security level for macro virus protection
        • Modify the list of trusted publishers for macros
        • Troubleshoot macro security
        • Troubleshoot macro security and warnings
        • Macros
        • Troubleshoot modifying the list of trusted publishers for macros
        • Warn about installed templates and add-ins
    • Privacy
      • Microsoft Office Access 2003 Privacy Statement
      • Microsoft Office Activation/Registration Privacy Statement
  • Access and the Web
    • About the types of Web pages Access creates
    • About where to save on the Web
    • Turn off automatic completion of file names and URLs
    • Troubleshoot HTML formatted files
    • Online Meetings
      • About online meetings
      • Accept a request for an online meeting
      • View a list of participants in an online meeting
      • Control an Access database, Access project, or data access page in an online meeting
      • Remove a participant from an online meeting
      • Open Chat in an online meeting
      • Use the Whiteboard in an online meeting
      • End an online meeting
      • Troubleshoot online meetings
    • Data on the Web
      • Speed up downloading Web pages by using Vector Markup Language
      • Set the language encoding for a Web page
      • Cancel the display of a Web page or hyperlink
      • About managing Web files and links
      • About single file Web pages (MHTML)
      • Refresh the display of the active file or Web page
      • Go back to the previous drive, folder, or Internet location
      • Language-specific names for Web page supporting folders
      • Optimize Web pages for a specific browser
      • Troubleshoot Web page options
      • Graphics on the Web
        • About working with graphics on Web pages
        • About Portable Network Graphics (.png) format
        • Save graphics in .png format
    • Working with Scripts
      • About creating and editing a Visual Basic script on a Web page
      • About Visual Basic scripts in a Web page
      • Create a script on a Web page
    • Working with Smart Tags
      • About Smart Tags
      • About the smart tags supplied by Microsoft
      • Add a smart tag to a control
      • Show smart tags
      • Hide smart tags
    • Access and Windows SharePoint Services
      • Link a table to a Windows SharePoint Services list
      • How Access converts between Access and SharePoint data types
      • Import from a Microsoft Windows SharePoint Services list
      • Export a table or query to a Windows SharePoint Services list
  • Sharing Information
    • With Other People
      • About Microsoft Office Document Imaging
    • With Other Programs
      • About applications that work with Access
  • Programmability
    • Actions
      • A-F
        • AddMenu Action
        • ApplyFilter Action
        • Beep Action
        • CancelEvent Action
        • Close Action
        • CopyDatabaseFile Action
        • CopyObject Action
        • DeleteObject Action
        • Echo Action
        • FindNext Action
        • FindRecord Action
      • G-N
        • GoToControl Action
        • GoToPage Action
        • GoToRecord Action
        • Hourglass Action
        • Maximize Action
        • Minimize Action
        • MoveSize Action
        • MsgBox Action
      • O
        • OpenQuery Action
        • OpenDataAccessPage Action
        • OpenDiagram Action
        • OpenForm Action
        • OpenFunction Action
        • OpenModule Action
        • OpenQuery Action
        • OpenReport Action
        • OpenStoredProcedure Action
        • OpenTable Action
        • OpenView Action
        • OutputTo Action
      • P-R
        • PrintOut Action
        • Quit Action
        • Rename Action
        • RepaintObject Action
        • Requery Action
        • Restore Action
        • RunApp Action
        • RunCode Action
        • RunCommand Action
        • RunMacro Action
        • RunSQL Action
      • S
        • SendObject Action
        • Save Action
        • SelectObject Action
        • SendKeys Action
        • SendObject Action
        • SetMenuItem Action
        • SetValue Action
        • SetWarnings Action
        • ShowAllRecords Action
        • ShowToolbar Action
        • StopAllMacros Action
        • StopMacro Action
      • T-Z
        • TransferDatabase Action
        • TransferDatabase Action
        • TransferSpreadsheet Action
        • TransferSQLDatabase Action
        • TransferText Action
    • Events
      • About events and event procedures
      • About setting the value of a control or property in response to an event
      • Set the value of a property in response to an event
      • Example of setting the value of a property in response to an event
      • Order of events for database objects
    • Macros
      • About macros and macro groups
      • Troubleshoot macros
      • Creating and Customizing Macros
        • Create a macro or macro group
        • Modify macros
        • Open the Macro window or the Visual Basic Editor
        • Convert macros to Visual Basic
      • Using Conditions in Macros
        • Examples of macro conditions
      • Using Macros to Work with Forms
        • About synchronizing records between two forms
        • Synchronize two forms by using the Form Wizard
        • Examples of synchronizing two forms programmatically
        • About printing a report from a form
      • Data Validation
        • About validating data programmatically
        • Validate data programmatically
        • Order of validation for controls and fields
      • Running and Debugging Macros
        • Run macros
        • Find problems in a macro by single stepping through it
      • Making Key Assignments
        • Assign an action or set of actions to a key
    • Basic Programming Concepts
      • Should I use a macro or Visual Basic?
      • Open the Macro window or the Visual Basic Editor
      • Secure Visual Basic for Applications code in Access databases (MDB)
      • Using Help
        • Ways to get help on writing code
        • Copy Visual Basic code examples from Help to the Code window
        • Get help on Access events and properties
      • Working with Modules
        • About modules
        • About procedures
      • Working in the Visual Basic Editor
        • Ways to get help on writing code
        • About working with data and database objects by using Visual Basic code
        • Change the display of your Visual Basic code
        • Create a Visual Basic procedure
        • Example of using Visual Basic to change a query's SQL statement
        • Get information about the objects used in your Visual Basic code
        • Guidelines for naming Visual Basic procedures, variables, and constants
        • Require variable declarations for Visual Basic code
        • Run Visual Basic code
        • Use arguments in Visual Basic
      • Debugging, Troubleshooting, and Optimizing
        • About errors in Visual Basic code
        • Debug your Visual Basic code
        • Improve Visual Basic code performance
        • Troubleshoot Visual Basic code
      • Setting Programmatic Operations
        • Create a message box programmatically
        • Navigate between controls, records, and form pages programmatically
        • Validate data programmatically
        • Examples of synchronizing two forms programmatically
        • Save a database object programmatically
        • Show or hide warning messages programmatically
        • Synchronize records between two forms programmatically
        • View the latest records for a form programmatically
    • Registry Settings
      • Customize driver settings
      • Customize Jet database settings (MDB)
  • Language-Specific Features
    • About Microsoft Proofing Tools
    • About multilingual features in Office
    • Troubleshoot working in a different language
    • Language Setup
      • About the global interface and Microsoft Office Multilingual User Interface Pack
      • Check spelling in a different language
      • Install system support for multiple languages
      • Requirements for specific languages
      • Enable editing of multiple languages in Office programs
      • Locale identification numbers for language-specific files
      • Remove commands and controls for languages you don't use
      • Change the default country/region
      • Change the default language setting
      • Use a keyboard layout for a specific language
      • Change the language of the user interface or Help in Office programs
      • Enable editing for multiple languages
      • Automatic Language Detection
        • About automatic font switching
      • Encoded Text Files and Unicode
        • Install the universal font for Unicode
    • East Asian
      • Reconvert Japanese, Traditional Chinese, or Simplified Chinese text
      • Review a file by using Reconversion
      • Japanese
        • About Japanese sort order
        • Specify IME behavior
      • Korean
        • Convert Hangul and Hanja
        • Add or delete Hanja in a custom dictionary
        • About Correct Keyboard Setting
        • Turn on Correct Keyboard Setting
      • Input Method Editors (IME)
        • About Input Method Editors (IMEs)
        • Install an Input Method Editor (IME)
        • Specify IME behavior
        • Set the default Input Method Editor (IME)
        • Add a word to an Input Method Editor (IME) dictionary
    • European
      • Work with euro currency symbols
    • Indic
      • About Indic language features in Office
      • About automatically checking the correct sequence of characters in Indic languages
    • South Asian
      • About South Asian features in Office
      • About South Asian databases
      • About using numbers and dates in South Asian databases
      • Specify the initial keyboard language in a text box or combo box
      • Specify the appearance of numbers in a text box or other control
      • Specify dates in dual calendar databases
      • Delete diacritics, ligatures, and special marks in South Asian text
      • Thai
        • Justify Thai text
        • About SQL Server 7.0 Support
        • Specify dates in dual calendar databases
    • Right-to-Left
      • About right-to-left features in Office
      • About finding and replacing characters in Indic, South Asian, or right-to-left languages
      • About right-to-left behavior in forms and reports
      • About right-to-left feature compatibility
      • About right-to-left language features
      • Use right-to-left features in forms and reports
      • About bidirectional fonts
      • Select diacritics or ligated characters
      • Set the default direction for new tables, queries, forms, reports, and pages
      • About global text direction
      • Change global text direction settings
      • About right-to-left control properties
      • About the hierarchy of setting right-to-left features
      • About bidirectional properties of the user interface
      • Examples of printing orders
      • About checking the spelling of bidirectional text
      • About using right-to-left sort orders
      • Set insertion point behavior
      • About code page and text layout support for right-to-left HTML files
      • About importing, exporting, and linking right-to-left tables in text formats
      • About creating macros in right-to-left applications
      • Change the default for a right-to-left feature
      • About using bidirectional text in expressions
      • About creating modules in right-to-left applications
      • Arabic
        • About Arabic sort order
        • About the Arabic code page
        • Specify the appearance of numbers in a text box or other control
        • Set language-specific spelling options
      • Hebrew
        • About Hebrew sort order
        • About the Hebrew code page
        • Set language-specific spelling options
        • Specify the appearance of numbers in a text box or other control
      • Calendars
        • About using different calendars
        • Switch database calendars
      • Controls
        • Summary of right-to-left properties for controls
        • Set right-to-left properties in controls
        • Specify alignment behavior in text fields
        • Specify the direction of a control on a data access page
        • Specify text alignment in a text box or other control
        • Specify text reading order for a text box or other control
        • Specify where you want scroll bars in a text box or other control
        • About attaching labels to controls
        • Specify the initial keyboard language in a text box or combo box
      • Converting Bidirectional Text
        • About converting reports saved as text files from ANSI characters
        • Convert bidirectional text files from ANSI
        • Convert bidirectional text files to ANSI
      • Data Access Pages
        • About right-to-left features in data access pages
        • Use right-to-left features in data access pages
        • Specify the direction of a data access page and its controls
      • Queries
        • About right-to-left behavior in queries
        • Change query direction
        • Change individual query direction
      • Tables
        • About right-to-left behavior in tables
        • Change table direction
        • Change individual table direction

Get in touch

Submit feedback about this site to:

  • [email protected]

© documentation.help. Design: rehmann.co.