documentation.HELP! Microsoft Office Access 2003 Documentation

Summary of dialog box Help in Microsoft Access Project Designers

Microsoft Office Access 2003

previous page next page

Summary of dialog box Help in Microsoft Access Project Designers

Add Table Dialog Box (Database Designer)
Add Table Dialog Box (Query Designer)
Choose Name Dialog Box
Choose Target Table for Insert Results Dialog Box
Choose Target Table for Insert Values Dialog Box
Column Selection Dialog Box
Create Relationship Dialog Box
Database Changes Detected Dialog Box (Database Designer)
Datatype Change Required Dialog Box
Define Column Collation Dialog Box
Delete Table Dialog Box
Indexes Dialog Box
Make-Table Dialog Box
Page Setup Dialog Box
Post-Save Notifications Dialog Box
Query Definitions Differ Dialog Box
Save Dialog Box
SQL Syntax Errors Encountered Dialog Box
Update Table Dialog Box
Validation Warnings Dialog Box
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.