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

Chapter 25. Creating Access Data Projects > Using the Project Designer

Using the Project Designer

ADP use a set of client/server graphical design tools called the "da Vinci toolset" during their development. Microsoft calls da Vinci MS Design Tools, but this book refers to the toolset as the project designer. Access's project design mode lets you alter the structure of tables, relationships, and views directly from the user interface. SQL Server and other client/server RDBMSs rely on SQL CREATE, ALTER, and DROP statements for design changes. The project designer executes the SQL statements for your design changes each time you exit design mode. The ability to alter the design of the equivalent to linked tables, unavailable in prior versions of Access, is an important new feature of Access 2000.

Executing SQL for database design operations lets you use the project designer with many client/server (also called SQL) databases, including SQL Server 6.5+ and Oracle 8.03+. Support for other client/server databases depends on the extent to which the RDBMS complies with ANSI SQL-92. The Visual Basic, Visual C++, Visual InterDev, and Visual J++ components of Visual Studio 6+ also use the da Vinci toolset for client/server database design. Thus the project designer brings Access 2000 into conformance with other Microsoft application design platforms, at least for client/server databases.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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