Microsoft Office Access 2003 Help
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
- Other Resources
- Accessibility
-
Installing and Customizing
- What's installed with Access 2003
- Which wizards are installed in Access 2003
- Change Office's appearance
- Components 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
- User Profiles
- Windows Registry Settings
- Adding Custom Help
- Troubleshooting Installing Office
-
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
- Managing Files
-
Handwriting and Speech
- Handwriting Recognition
-
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
-
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
-
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
-
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
- Creating Tables
- Adding and Deleting Fields
-
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
- Fields With Blank Values
-
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
-
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
- Creating Forms
-
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
- Form Sections
- Creating Subforms
- Calculating Totals
-
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
- Switchboard Forms
- Pop-Up Forms and Custom Dialog Boxes
-
Reports
- About reports
- Troubleshoot reports
- Opening and Viewing Reports
- Creating Reports
-
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
- Report Sections
- Page Breaks and 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
- Advanced Reports
- Report Snapshots
-
Queries
- Opening, Viewing, and Running Queries
-
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
-
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
-
Customizing Queries
- Working in the Query Design Grid
- Working with Tables or Queries
-
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
-
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
- Performing Calculations
- SQL Queries
- ANSI SQL Query Mode
-
Microsoft Jet SQL Reference
- Glossary
- What's New
- Overview
- Data Definition Language
- Data Manipulation Language
- Clauses
- Functions
- Operators and Predicates
-
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
-
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
-
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
-
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
-
Changing a Page's Overall Appearance
- Working with Data Access Pages 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
- Working with Files and Links
- Troubleshooting
-
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
-
Tables
-
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
-
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
- Tab Controls
-
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
-
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
-
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
- Troubleshooting Databases
-
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
-
Finding, Sorting, and Grouping Data
- 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
- Grouping Data
- Hyperlinks
- Check 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
-
Changing the Appearance of a Datasheet
-
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
-
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
-
Datasheets
- Sharing Data
-
External Data
- Automate importing, exporting, or linking data
- About XML data and Access
- About connections
- Exporting Data or Objects
-
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
-
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
- Examples of Expressions
-
Functions
- Arrays
-
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
- Domain Aggregate
- Error Handling
- Financial
- General
- Input/Output
- Inspection
- Math
- Messages
- Program Flow
- SQL Aggregate
-
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
-
Basic Tasks
- Upsizing from an Access Database
-
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
-
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)
-
Columns and Tables
-
Queries
- Troubleshoot queries (ADP)
- Query Designer
-
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
-
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
-
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
-
Understanding a Microsoft Access Project
-
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
- Replica Visibility
- Synchronizing Data
-
Understanding Replication
-
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
- Passwords
- Digital Signatures
-
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
-
Security
-
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
- Working with Scripts
- Working with Smart Tags
- Access and Windows SharePoint Services
- Sharing Information
-
Programmability
- Actions
- Events
- Macros
-
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
- Working with Modules
-
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
-
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
-
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
- Encoded Text Files and Unicode
- East Asian
- European
- Indic
-
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
-
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
- Hebrew
- 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
- Data Access Pages
- Queries
- Tables