Skip to search results
PRODUCT
Office.com results
Rearrange the order of columns in a table
Article You can rearrange the order of columns in a table in Datasheet view or in Design view . You can move a single column or a contiguous group of columns. Select...
Access 2007
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
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
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
Create a simple report by formatting a datasheet
Article When you open a table or view the results of a query, Microsoft Office Access 2007 displays the table or query result in Datasheet view. Table data or query ...
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
Turn on or off overtype mode
Article When you are editing text in overtype mode, typing new characters replaces any existing characters to the right side of the insertion point. Do you need help wi...
Access 2007, Excel 2007...
Watch this: Change the data type of a field
Article January 20th, 2009 Steven Thomas Want to change the data type of a table field? Watch this demo to see how you do it in Datasheet view. Watch this Problems watc...
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
Specify how data displays by using predefined formats
Article Microsoft Office Access 2007 provides several predefined formatting options that you can use to enhance the way your data appears in a table or form. This artic...
Access 2007
Insert a table, convert text to a table, or draw a table
Article Learn how to insert a table, draw a table, or convert text to a table in Word 2010.
Word 2010
Display column totals in a datasheet
Article Sum a column of data in a table or query in Access 2007
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
Remove a subdatasheet
Article A subdatasheet is a datasheet that is nested within another datasheet and contains data related or joined to the first datasheet. Microsoft Office Access auto...
Access 2007
Refresh a datasheet
Article If you are sharing a database over a network, other users could be changing data while you are viewing the same data in a datasheet. Microsoft Office Access upd...
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
Insert ASCII or Unicode Latin-based symbols and characters
Article Show All Hide All ASCII and Unicode character encoding enables computers to store and exchange data with other computers and programs. Below are lists of freque...
Access 2007, Excel 2007...
Field properties quick reference
Article Fast info on data types and other field properties , including usage guidelines and storacge capacities. Data types include text, memo, number and others.
Access 2007
Customize how data is displayed by creating a lookup field
Article If you want a field in an Access 2007 datasheet, form, or report to display a value while storing a different value, you create simple or complex lookup fields.
Access 2007
PREV12NEXT
Didn't find what you were looking for?Search all of Office.com