Chapter 12 explores these resources in greater depth.
The chapter compares and contrasts database objects in Access and SQL Server databases. In addition, you gain exposure to graphical techniques for creating and using these objects. The graphical interfaces start with the Access project Database window that permits you to explore the database objects in the SQL Server database to which an Access project points. You also learn how to graphically create tables, views, stored procedures, and user-defined functions as well as database diagrams for representing whole database schemas.
Although the chapter covers graphical means for creating objects, there is also a strong emphasis on programmatically creating database objects. For example, you learn T-SQL coding techniques. The chapter shows you how to run this code from templates accessible through the Access project Database window as well as via ADO in the VBA project associated with an Access project. Although the VBA samples generally take advantage of running from an Access project, many of these samples can run with slight modification from the VBA project for an Access database file.