Datasheet
4. Click Change next to the Data Source field and in the Change Data Source dialog box, select
Microsoft SQL Server and then click OK.
5. In the Add Connection dialog box, select the name of the computer running the SQL Server
instance that contains your ProjectTimeTracker database in the Server name field.
6. In the Log on to the server section, choose the type of authentication that your account has been
set up with (consult your DBA if you did not set up the database and create an account your-
self). If you are using a specific User ID and Password, check the Save my password check box.
7. Select the ProjectTimeTracker database in the Select or enter a database name combo box.
8. Click the Test Connection button to verify your credentials. If the test did not succeed, verify
your credentials and contact your DBA if necessary. When you are done, click OK to close the
Add Connection dialog box.
9. Expand the Data Connection node that you just created.
10. Right-click the Tables node and choose Add New Table from the context menu. In the designer,
add the columns and column attributes for the Projects table according to the schema shown in
Figure 1-8. When you are done, your designer should look like the one shown in Figure 1-9.
Figure 1-9
11. You now need to set the primary key for this table. Click the ProjectID column and click the
Table Designer menu and select the Set Primary Key menu item or click the Set Primary Key
icon on the toolbar. The Primary Key icon will be displayed in the row selector for the ProjectID
column.
12. Save the table by clicking the File menu and selecting the Save Table1 menu item or by clicking
the Save Table1 icon on the toolbar. In the Choose Name dialog box, enter a table name of
Projects and then click OK. Finally, close the designer for the Projects table.
13. Repeat Steps 10 through 12 for the rest of the tables shown in the schema in Figure 1-8. The
primary key for each table is the first column listed in each table. Don’t worry about the foreign
key relationships, as you add those in the next few steps.
22
Chapter 1
04_58894x ch01.qxd 10/13/05 5:54 PM Page 22