Skip to search results
PRODUCT
Office.com results
Restrict data input by using a validation rule
Article You can vet or validate data as it is input to help improve accuracy and consistency, by using validation rules. There are three ways to use validation rules: F...
Access 2010
Create or modify a primary key
Article A primary key in an Access database table is a unique value that helps identify each record in the table. Access can assign an AutoNumber primary key.
Access 2010
Store multiple values in a lookup field
Article This Microsoft Access 2010 article explains what a multivalued lookup field is, how to add one to a table, and how to change an existing lookup field.
Access 2010
Add a field to a table
Article To store a new piece of data about something for which you already have a table, consider adding a field to the table. For example, suppose you have a table tha...
Access 2010
Add a calculated field to a table
Article In Access 2010, you can create table fields that calculate values. The calculations can include values from fields in the same table as well as built-in Access ...
Access 2010
Rearrange the order of columns in a table
Article Note You cannot modify a database table by using a Web browser. You must first open the database in Access. You can rearrange the order of columns in a ta...
Access 2010
Create PivotTable or PivotChart views in a desktop database
Article PivotTable and PivotChart views in Access desktop databases.
Access 2013, Access 2010
Set the default format options for datasheets
Article Set all datasheets in your Microsoft Access 2010 databases to display with specified format options.
Access 2010
Freeze fields in an Access datasheet
Article When you freeze a field (column) in an Access datasheet, the field remains visible when you scroll across the datasheet.
Access 2010
Restrict data input by using a validation rule
Article Validations rules help you check data as it is added to your Access database which improves accuracy and consistency of daata entry.
Access 2013
Propagate a field property
Article When you change an inheritable field property in a table, Access can be set to automatically make the same change to controls that are based on that field. Thi...
Access 2013
Add or change a table’s primary key
Article A primary key in an Access database table is a field with unique values for each record in the table. You can use the key to connect data between tables. Access...
Access 2013
Add a field to a table
Article To store new data in a table, consider adding a field to the table.
Access 2013
Store multiple values in a lookup field
Article Learn what a multivalued lookup field is, how to add one to a table, and how to change an existing lookup field.
Access 2013
Set the default format options for datasheets
Article Set all datasheets in your Access database to display with specified formatting.
Access 2013
Add a calculated field to a table
Article In Access, you can create table fields that calculate values, somewhat like using formulas in Excel.
Access 2013
Didn't find what you were looking for?Search all of Office.com