Skip to search results
PRODUCT
Office.com results
Database basics
Article This article provides a brief overview of databases -- what they are, why you might want to use one, and what the different parts of a database do.
Access 2013, Access 2010
Introduction to importing and exporting data
Article This article shows you what kinds of data you can import, link to, and export from Access. It also shows you some basic steps to get started.
Access 2010
Introduction to expressions
Article In Access, you use expressions to calculate values, validate data, combine text, and more. This is an overview of expression components and how to use them.
Access 2013, Access 2010...
Customize default settings for your databases
Article You can customize various settings for your Microsoft Access 2010 databases from the Client Settings category of options. The settings that you make from this c...
Access 2010
Introduction to tables
Article In this overview, learn what a table is and how you create one, how to add fields to a table, how to set a primary key, and how to set properties.
Access 2010
Introduction to queries
Article When you want to review, add, change, or delete data from your database consider using a query. Using a query, you can answer very specific questions about your...
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
Introduction to Access SQL
Article Show All Hide All When you want to retrieve data from a database, you ask for the data by using Structured Query Language, or SQL. SQL is a computer language th...
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
Examples of query criteria
Article Learn how to use query criteria to limit the returned results of a query.
Access 2010
Tips for finding clips
Article Getting started With most Microsoft Office programs, you can find clip art, pictures, and other media files. Office 2010 Open an Office 2010 program. On the Ins...
Access 2010, Excel 2010...
Undo or redo data entry or design changes
Article The undo and redo commands work for data entry until you move to a different record. You can also undo and redo many form and report design changes.
Access 2010
Create an Access database
Article Create a database from scratch or by using a template from Office.com.
Access 2010
Introduction to controls
Article This article describes the different kinds of controls available in Access, and shows how to add controls to forms and reports. Controls are the parts of a form...
Access 2010
Change the default file format
Article When you create a new, blank database, Access asks you to name the database file. By default, the file is given the ".accdb" extension — it is created in the Ac...
Access 2010
Introduction to the Access 2010 templates
Article If you're new to databases, or if you just don't want to spend time creating a database from scratch, Microsoft Access 2010 provides various templates that you ...
Access 2010
Convert a database to the .accdb file format
Article By default, Access 2010 and Access 2007 create databases in the .accdb file format, which is generally referred to as the Access 2007 file format. This format s...
Access 2010
Introduction to Access 2010 security
Article Show All Hide All This article provides an overview of the security features offered by Access 2010, and explains how to use the tools that Access provides for ...
Access 2010
Compact and repair a database
Article Use the Compact and Repair Database command to help prevent and correct the following problems: files growing larger with use and files becoming corrupted.
Access 2010
What's new in Microsoft Access
Article In Microsoft Access 2010, you can build web databases and publish them to a SharePoint site. SharePoint visitors can use your database application in a web brow...
Access 2010
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 2010
Introduction to Access programming
Article When you create a new database, you typically begin by creating several database objects such as tables, forms, and reports. Eventually, you reach a point where...
Access 2010
Bypass startup options when you open a database
Article If you used a setting to specify what happens when you open a Microsoft Access 2010 database, you can bypass those settings to regain full access to your data...
Access 2010
Which view should I use: Layout view or Design view?
Article Layout view and Design view are the two views in which you can make design changes to forms. You can use either view to perform many of the same design and layo...
Access 2010, Access 2007
Learn the structure of an Access database
Article Becoming familiar with the tables, forms, queries, and other objects in a database can make it easier to perform a wide variety of tasks, such as entering data ...
Access 2010
PREV12NEXT
Didn't find what you were looking for?Search all of Office.com