Skip to search results
PRODUCT
Office.com results
Create a list of choices by using a list box or combo box
Article When entering data on forms, it can be quicker and easier to select a value from a list than to type a value. Learn how to add a list box or combo box.
Access 2013, Access 2010...
Insert or add a rich text field
Article In Microsoft Office Access 2007 , you can store rich, formatted text in a database. You do this by using a memo field and setting the field's TextFormat prop...
Access 2007
Create, edit or delete a relationship
Article Show All Hide All After you have created a table for each subject in your database, you must provide Office Access 2007 with the means by which to bring that in...
Access 2007
Add or change a lookup column that lets you store multiple values
Article This Access 2007 article explains multivalued lookup columns, how to add one to a table, and how to convert an existing column to a multivalued lookup column.
Access 2007
Create or remove a primary key
Article Show All Hide All Every table in your database should have a primary key — a field or set of fields with a unique value for each record stored in the table. You...
Access 2007
Create a custom field template for the Field Templates pane
Article Sometimes it is easier to choose from a predefined list of fields than to manually create a field. You can use the Field Templates pane to choose from a list o...
Access 2007
Require a value in a field
Article There are two basic ways that you can require a value in a field: Set the field's Required property to Yes You can do this by opening the table in Design view....
Access 2007
Add a field to a table
Article This article explains why well-designed fields are important and shows you several basic ways to add fields to a table in Microsoft Office Access 2007.
Access 2007
Store the date and time when a record is modified
Article You can keep track of when records in a table are last modified, by using a form with a macro. When the form is used to modify a record, the macro stores the d...
Access 2007
Introduction to data types and field properties
Article In Access 2007, an overview of data types and field properties, with a detailed data type reference for fields, including Memo, Date/Time, and Text.
Access 2007
Use a check box or other control to display a Yes/No value
Article In general, a check box is the best control for representing a Yes/No value on your form or report, but you can also use option buttons or toggle buttons.
Access 2010, Access 2007
Delete a field
Article You can delete a field from a query or from a table. When you delete a field from a query, the field remains in the database, but is no longer used in the query...
Access 2007
Document and print your database design
Article Microsoft Office Access can help you prepare printed documentation of your database's design, which you can use for offline reference and planning. Specifically...
Access 2007
Use a command button to start an action or a series of actions
Article Show All Hide All You use a command button on a form to start an action or a set of actions. For example, you can create a command button that opens another for...
Access 2007
Open a blank datasheet
Article Show All Hide All This article explains how to open a new, blank datasheet in Microsoft Office Access 2007. The article also explains how to use design-in-brows...
Access 2007
Add or change a lookup column
Article This article explains what a lookup column is and how to create one in Microsoft Office Access 2007.
Access 2007
Make a database easier to use by customizing and controlling the Navigation Pane
Article Show All Hide All You can improve the usability of a database by customizing and controlling the contents and organization of the Navigation Pane. Custom naviga...
Access 2007
Control data entry formats with input masks
Article When you have several people entering data in your database, you can define how users must enter data in specific fields to help maintain consistency and to mak...
Access 2010, Access 2007
Guide to table relationships
Article One of the goals of good database design is to remove data redundancy (duplicate data). To achieve that goal, you divide your data into many subject-based table...
Access 2007
Validation rules
Article By Allen Browne, Access MVP Validation rules prevent bad data being saved in your table. Basically, they look like criteria in a query. You can create a rule fo...
Access 2007
Database design basics
Article A properly designed database provides you with access to up-to-date, accurate information. Because a correct design is essential to achieving your goals in work...
Access 2007
Create and use an index to improve performance
Article Index one or more table fields in Access 2007 by using the table designer. Also covers automatic index creation, viewing, and deleting.
Access 2007
Insert, create, or delete a field to store numeric values
Article You add a Number field to a table when you need to store numeric data, such as sales figures. This article explains how to use Microsoft Office Access 2007 t...
Access 2007
Modify or change the data type setting for a field
Article This article explains how to set or change the data type applied to a table field in a Microsoft Office Access 2007 database. In this article TOC o "1-1" n h z...
Access 2007
Create a table
Article Show All Hide All When you create a database, you store your data in tables—subject-based lists that contain rows and columns. For instance, you can create a Co...
Access 2007
PREV12NEXT
Didn't find what you were looking for?Search all of Office.com