O'Reilly logo

Beginning Access™ 2007 VBA by Denise Gosnell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

14.2. Building the Database and Database Objects

In this section, you will build the database in an Access project, which stores the data tables in SQL Server, and the user interface in the Access project itself.

You should have a version of Microsoft SQL Server installed in order to create this application. Please refer to Chapter 10 for more information on obtaining and setting up SQL Server.

Try It Out: Building the CustomerServiceSQL Database

Now, let's build the Access Project and SQL Server database that will store the data tables. You will also build the SQL Server stored procedures used by your application.

  1. Create a new Access project and SQL Server database by selecting the Office Button New. Click on the Browse button. Specify a file name of CustomerService, in the Save As type dropdown list select the Microsoft Office Access Projects (*.adp) option, and press the OK button. You will be returned to the original window; press the Create button.

  2. Select "No" when Access asks you if you want to connect to an existing database.

  3. The Microsoft SQL Server Database Wizard will appear, as shown in Figure 14-5. Specify the name of the SQL Server database on your computer. Also, identify whether Windows integrated security (Use Trusted Connection) should be used. If your SQL Server database is not set up for Windows integrated security, you must specify a valid SQL Server login ID ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required