• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part I: Microsoft Access Projects and Microsoft SQL Server

Part I: Microsoft Access Projects and Microsoft SQL Server

This section describes the basics of setting up Access projects. Access projects differ from traditional Access mdb databases in that data and queries are managed and run with SQL Server and MSDE.

This section will explain in detail how SQL Server and MSDE manage data in tables and how they differ from Access mdb database tables. The SQL Server database diagrams correspond to the relationship diagrams in Access mdb databases for creating and documenting key relationships.

Queries are created with SQL Server or MSDE in the Transact-SQL programming language. Select queries can be defined as views. Entire program processes and action queries are implemented as stored procedures. You will learn how to create, edit, and run views and stored procedures from an Access project and will be given an overview of programming with Transact-SQL.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint