Creating Access Projects ADPs

Now that you have SQL Server installed, you can return to the discussion of using Access Projects to work with SQL Server databases. To create a new Access Project for a SQL Server database, you first select File C> New. You can then select one of the two options circled in Figure 9.5.

j New Fite

g X




Blank database,,, Slank data access page,,.

Project using existing data,,, Project using new data,,, J

[¿j From existing file,,,

Figure 9.5

Selecting the Project Using Existing Data option will allow you to create a new Access Project using an existing SQL Server database. Selecting the Project Using New Data option will create a new Access Project and a new SQL Server database. You will now look at each of these options in detail.

0 0

Post a comment