Database design - Access - Microsoft Office Online

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Database design

Documents 1-25 of 41

Page: [1] 2 Go to previous page (disabled)

Database design basics

Create a table

Relationships between tables

Learn to think relationally

Learn the structure of an Access database

6 key considerations when creating Access 2007 databases

Create a custom field template for the Field Templates pane

Validation rules

Create a validation rule to validate data in a field

Set default values for fields or controls

Add a field to a table

Create or remove a primary key

Control data entry formats with input masks

Create and use an index to improve performance

Require a value in a field

Field properties quick reference

Delete a field

Make a database easier to use by customizing and controlling the Navigation Pane

Introduction to data types and field properties

Prevent duplicate values in a field

Split a database

Store the date and time when a record is modified

Create a calculated control

Create, edit or delete a relationship

Set name AutoCorrect options

Documents 1-25 of 41

Page: [1] 2 Go to previous page (disabled)

Related Web Sites

» Product Support
» Microsoft.com

» Microsoft Update
» TechNet

» Office for Mac
» Office Community

Site Help | Accessibility | Contact Us | My Office.com | Office Worldwide Click here to switch to other Office Online sites worldwide