Analyzing Data with Microsoft Access 111 connect an Access project to a remote SQL Server 2000 database, a local SQL Server 2000 data- base, or a local installation of the SQL Server 2000 Desktop Engine. The fact that an Access project does not contain any data itself allows you to use the features of SQL Server for very large databases or large numbers of concurrent users and use the familiar Access user interface for queries (called views, functions, and stored procedures in SQL Server terminology), data entry forms, reports, and so on. To create an Access project and connect to a SQL Server database, click New on the File menu, click Project (Existing Data) if you're using Access 2002, or Microsoft Access Projects if you're using Access 2000. Provide a file name and location, and then click Create. On the Connection tab, select or enter a server name, provide your server logon credentials, select a database, and then click OK. SQL Server uses different terms and data types than Access. You'll notice terms such as identity seed, varchar, and stored procedure when you create or modify data tables or queries. To under- stand these terms, as well as how to work in more detail with Access projects, refer to the book Microsoft Access Projects with Microsoft SQL Server (Microsoft Press, 2002). SQL Server itself can seem somewhat intimidating to first-time users. The key point to remember is that with Access projects, you don't have to be an expert in the inner workings of SQL Server. You need to understand a few differences in terminology, but otherwise you can use the skills you've mastered in this chapter to analyze SQL Server data through Access projects. Analyzing Access Data over the Web Both Access 2000 and Access 2002 provide support for hosting Access data over the Web. Data access pages are Web pages that connect to and display data from an Access database. Users can then interact with and analyze the data over an intranet or the Internet. Because data access