Skip to search results
PRODUCT
Office.com results
Add, remove, or view a trusted publisher
Article Learn what trusted publishers are and how to add, view, or remove them.
Access 2013, Excel 2013...
Find and remove duplicate data
Article Learn to find, remove, or edit duplicate records and to help prevent users from entering duplicate data.
Access 2010
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 and use an index to improve performance
Article Index one or more table fields in Access 2010 by using the table designer. Also covers automatic index creation, viewing, and deleting.
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
Create and manage custom categories and groups in the Navigation Pane
Article Show All Hide All To use and manage your database objects in Microsoft Access 2010, you use the Navigation Pane. The pane replaces an older tool — the Database ...
Access 2010
Save and reuse database design elements
Article Maximize your design investment by reusing all or part of a database by saving it as a template - with or without data. Share templates with others in your offi...
Access 2010
Social media done easy
Article Watch 3 members of the Access Team create an Access web database for collecting ideas and suggestions from a group.
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
Build an Access database to share on the Web
Article You can use Access 2010 and Access Services, a new component of SharePoint, to build web database applications. This helps you: Secure and manage access to your...
Access 2010, SharePoint Server 2010
Customize design settings for objects in your database
Article The Object Designers category has setting options that can be used to modify the design of Microsoft Access 2010 objects. You can set design options for table, ...
Access 2010
Create an Access database
Article Create a database from scratch or by using a template from Office.com.
Access 2010
Streamline reporting on shared business data by using queries and macros
Article Report on data from a large external data source by creating a new database that has normalized data and automated importing. Print the reports or save them as ...
Access 2010
Make a query ask for input
Article Learn how to use parameters in an Access query to filter data using criteria values you supply when the query runs.
Access 2010
Store the date and time when a record is modified
Article Show All Hide All 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 m...
Access 2010
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 2010
Customize and lock 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 2010
Create or modify tables or indexes by using a data-definition query
Article You can create and modify tables, constraints, indexes and relationships by writing data-definition queries in SQL view.
Access 2010
Set user options for current database from a centralized location
Article To customize several user settings such as, how object windows display, to enable keyboard shortcuts, and to enable automatic correction options for a Microsof...
Access 2010
Split an Access database
Article Show All Hide All Consider splitting any database that several people share over a network. Splitting a shared database can help improve its performance and red...
Access 2010, Access 2007
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
Use parameters to ask for input when running a query
Article Adding parameters to a query makes it ask for criteria so that it filters the results.
Access 2013
Customize and lock the Navigation Pane
Article Use Navigation Pane features to keep your database organized.
Access 2013
Store the date and time when a record is modified
Article Keep track of when data in a table was modified by using a macro that stores the date and time of the latest record modification in the table.
Access 2013
Split an Access database
Article Split an Access database into front-end and back-end components to improve performance and safely share data with other users.
Access 2013
PREV12NEXT
Didn't find what you were looking for?Search all of Office.com