Creating a Bindable Microsoft Access Database

In This Topic

To create a bindable Microsoft Access database:

Create a new Microsoft Access database.
Add tables with the fields and settings listed below.

Note: This topic assumes that you are familiar with creating a database in Microsoft Access and setting up tables. If you are a novice to Microsoft Access, please see the Microsoft Office Help for more information.

Appointments Table

The following fields and settings are for the Appointments table:

Field Name	Data Type	Field Size	Required	Indexed	Primary Key
AppointmentID	AutoNumber	Replication ID	Yes	Yes (No Duplicates)	X
Subject	Text	255	Yes	No	--
Location	Text	255	No	No	--
Start	Date/Time	--	No	No	--
End	Date/Time	--	Yes	No	--
Body	Memo	--	No	No	--
Properties	Memo	--	No	No	--

Categories Table

The following fields and settings are for the Categories table:

Field Name	Data Type	Field Size	Required	Indexed	Primary Key
CategoryID	AutoNumber	Long Integer	Yes	Yes (No Duplicates)	X
CategoryName	Text	255	Yes	Yes (No Duplicates)	--

Contacts Table

The following fields and settings are for the Contacts table:

Field Name	Data Type	Field Size	Required	Indexed	Primary Key
ContactID	AutoNumber	Long Integer	Yes	Yes (No Duplicates)	X
Name	Text	255	Yes	Yes (No Duplicates)	--

Resources Table

The following fields and settings are for the Resources table:

Field Name	Data Type	Field Size	Required	Indexed	Primary Key
ResourceID	AutoNumber	Long Integer	Yes	Yes (No Duplicates)	X
ResourceName	Text	255	Yes	Yes (No Duplicates)	--