[ Pobierz całość w formacie PDF ]
.To set the tab order for controls within a particular page of a tab control, choosethe Tab Order command from the tab control s right-click menu, or select a controlon the tab page, and then select View ª' Tab Order.You must set the tab order foreach page individually.Tabbing out of the last control inside a tab control page brings you to the next con-trol in the tab order for the form.You can t jump between pages.Adding pictures to the tab controlYou can add a picture to each tab using the page properties for the tab control.Youcan display the page properties for a particular tab by selecting the tab on the tabcontrol and choosing View ª' Properties.To add a picture to the tab, use the Pictureproperty just like you do for a command button, toggle button, image control, orunbound OLE object.When you specify a caption and a picture for a tab, the pic-ture displays to the left of the tab caption.You can type the full path and name of the bitmap or icon file or use the Access2002 Picture Builder to select a picture.Figure 32-45 illustrates adding a picture to atab in the Print Reports Tabbed Dialog form.In the figure, the picture of a printerdisplays on Page 1. 3596-X ch32.F 5/30/01 11:48 AM Page 1109Chapter 32 &' Creating Switchboards, Command Bars, Menus, Toolbars, and Dialogs1109Figure 32-45: Adding a picture to a tab&' &' &' 3596-X ch32.F 5/30/01 11:48 AM Page 1110 3596-X pt06.F 5/30/01 11:48 AM Page 1111P A R TAccess and theVIVIExternal World&' &' &' &'In This PartChapter 33Moving from Jet tothe SQL Server 2000Desktop EngineChapter 34Working with AccessProjectsChapter 35Using and CreatingAccess Objects forIntranets and theInternetChapter 36Building WebApplications, DataAccess Pages, andXML&' &' &' &' 3596-X pt06.F 5/30/01 11:48 AM Page 1112 3596-X ch33.F 5/30/01 11:48 AM Page 1113C H A P T E R3333Moving from Jetto the SQL&' &' &' &'In This ChapterServer 2000Understanding theSQL Server 2000Desktop EngineDesktop EngineComparing the SQLServer 2000 DesktopEngine to JetQL Server 2000 Desktop Engine is a client/server dataWorking with theSengine alternative to the Microsoft Jet database engine.SQL Server 2000In Access 2000, this was called the Microsoft Database EngineDesktop Engine(MSDE) and was built on the SQL Server 7 technology.InAccess 2002, the SQL Server 2000 Desktop Engine is built onCreating tables andSQL Server 2000 and is compatible with the full Microsoft SQLdatabase diagramsServer 2000 version, so your client/server application can runin an Access projecton either version.If you anticipate your small workgroup appli-cation to eventually accommodate 20 or more users or evenUpsizing from Jethundreds or thousands of users you probably want to useSQL Server 2000 Desktop Engine.In this chapter, you learn howto set up SQL Server 2000 Desktop Engine and how you can use &' &' &' &'it to build powerful client/server database applications.Understanding SQL Server 2000Desktop EngineSQL Server 2000 Desktop Engine is a client/server databaseengine that is designed to be compatible with the SQL Serverdatabase engine.Think of SQL Server 2000 Desktop Engine asa scaled-down version of SQL Server.With some exceptions, itprovides all of the power of SQL Server, yet it has been opti-mized to run on desktop computers running Windows 98,Windows ME (or later), Windows NT 4.0, and Windows 2000(or later). 3596-X ch33.F 5/30/01 11:48 AM Page 1114Part VI &' Access and the External World1114Applications developed using SQL Server 2000 Desktop Engine can be run underSQL Server 2000 Standard Edition or SQL Server 2000 Enterprise Edition withoutmodification.This capability is a great advantage to both application developersand their customers.In the rapidly changing business environments of today, many software develop-ment projects begin targeting a handful of users.Within a relatively short span oftime, the application needs to be available across the enterprise, consisting of pos-sibly hundreds or thousands of users.In a typical scenario like this, the customerfaces expensive development costs and lost time when the application needs to bemodified to accommodate the larger environment.Or, in the worst case scenario,the customer may be forced to abandon the smaller application and reengineer itwith a client/server toolset.SQL Server 2000 Desktop Engine provides the scalabil-ity required by growing business environments.Developers who don t have access to a network running SQL Server can buildclient/server applications using SQL Server 2000 Desktop Engine on a personalcomputer.Some simple changes to the connection information are all that isrequired when the time comes to connect the application to SQL Server.Comparing SQL Server 2000 Desktop Engine and JetThe SQL Server 2000 Desktop Engine is a true client/server database engine.Thatis, the interface objects (forms, reports, and shortcuts to data access pages) arestored locally on the workstation in a Microsoft Access project.The data, however,is stored on a local or network server.Additionally, much of the processing of data(running queries and stored procedures) occurs on the server.This is very differentfrom the Jet database in that regardless of where you have the data, all the recordsin a table are returned to the local workstation when processing a bound form orreport.Client/server architecture minimizes the work of both the client and theserver and cuts down on the amount of information traveling over the network.Microsoft Jet is the default database engine included with Access 2002.SQL Server2000 Desktop Engine is an alternative database engine to the Microsoft Jet databaseengine.If you have developed applications in previous versions of MicrosoftAccess, you should be familiar with Microsoft Jet.Jet is the file/server data manager behind the Microsoft Access database.AMicrosoft Access database can store all of an application s database objects, includ-ing the interface objects and the data.Jet moves the data back and forth betweentables and forms and reports.Jet is described as a file server database enginebecause its job is merely to store and retrieve data.There is no distribution of pro-cessing between server and workstation as occurs in the client/server architecture.Although SQL Server 2000 Desktop Engine provides the optimum in power and flexi-bility, Jet is the appropriate environment for many types of situations.Therefore,it s important to choose the right database engine for the job. 3596-X ch33.F 5/30/01 11:48 AM Page 1115Chapter 33 &' Moving from Jet to the SQL Server 2000 Desktop Engine1115Choosing the right database engineDesigning a database application requires careful consideration of the businessenvironment s current situation, as well as strategic planning for expansion either in the number of users, or in the volume of data to be stored and retrieved [ Pobierz caÅ‚ość w formacie PDF ]