documentation.HELP! Microsoft Office Access 2003 Documentation

Microsoft Office Access 2003 Help

Microsoft Office Access 2003

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

next page

Get in touch

Submit feedback about this site to:

• [email protected]