Access.2007.VBA.Bibl..

(John Hannent) #1

Using Sample Databases and Forms ........................................................................


I created Events and Tasks databases from the new templates and imported the relevant tables and
forms from these databases into the sample database for this chapter, Outlook Export.accdb, and
then renamed the objects and controls with appropriate prefixes.

Microsoft has created several new database templates for Access 2007; one of them cre-
ates an Events database, and another creates the Tasks database. See the “Creating a
Database from a Template” sidebar for full details on how to locate a database template and create a
database from it.

Personally I prefer to maintain my calendar and task list in Outlook, because it has the richest
interface for working with appointments and tasks. However, if you want (or need) to maintain a
simple calendar or task list in Access, you might want to use these new sample databases, or
import objects from them, into your database. You can examine the forms I imported from the
sample databases by selecting them from the Forms section on the main menu of the Outlook
Export database, as shown in Figure 8.10 (the imported forms end with “List”).

FIGURE 8.10
Selecting a form from the main menu.

Figure 8.11 shows the Task List form, and Figure 8.12 shows the Event List form.

NEW FEATURENEW FEATURE

Part II Writing VBA Code to Exchange Data between Office Components

Free download pdf