Practical Examples: Applying the Strategy to the Computer Consulting Firm Application
The time and billing application for the computer consulting firm introduced in Chapter 1, "Access as a Development Tool," could be composed of two databases: one containing the majority of the tables, and the other with the remainder of the database objects, including static and temporary tables. To design the application properly and to make the transition to client/server as smooth as possible, you would develop the application with the idea that you might eventually move the data to a back-end server. You would base the forms and reports that make up the application on stored queries or embedded SQL statements to maximize their flexibility and efficiency. Finally, you would design the application so that it can easily run from Access's runtime version and you would secure it so that unauthorized users could not access its data and other objects.