![]() The fourth dialog lets you choose a style for printed reports (see Figure 3.7). Select a form style and click Next to continue.įigure 3.6 Select the text color and background color or image for data-entry forms. ![]() As you select an item in the list, a sample of the style appears in the dialog (see Figure 3.6). The third Wizard dialog offers a selection of text colors and background colors or images for the data forms that the wizard creates. You can't remove the standard set of fields that appear in Roman type you receive an error message if you try. You can remove only the optional fields you add. Check the Home Phone field and click Next to continue.įigure 3.1 Double-clicking the General Templates link under the New from Template heading of the task pane opens the Templates dialog with the Databases page active.įigure 3.2 Select the Contact Management template in the Databases page of the Templates dialog.įigure 3.3 Shorten the default database file name, Contact Management1.mdb to Contacts.mdb.įigure 3.4 The first Database Wizard dialog offers a brief description of the new database.įigure 3.5 Add the optional Home Phone field of the Contact Information table of Contacts.mdb. To add or remove an optional field of the Contact Information table, mark or clear the check box (see Figure 3.5). Optional fields appear in italic type in the list. The second Wizard dialog lets you add or remove optional fields to each of the three tables. The first dialog of the Database Wizard describes the type of information that the new database stores (see Figure 3.4). Click Create to generate an empty Jet 4.0 database file (Contacts.mdb) and start the Database Wizard. Accept the default name or shorten it to Contacts.mdb (see Figure 3.3). The default location of the database file is your My Documents folder. The wizard proposes a default database with the name of the template plus a 1 suffix. Click OK to open the File New Database dialog. This example uses the Contact Management.mdz template. Access stores its templates in the \Program Files\Microsoft Office\Templates\1033 folder. If you don't see the New File task pane, choose View, Toolbars, Task Pane to display it.Ĭlick the General Templates link of the New from Template group (see Figure 3.1) to open the Templates dialog.Ĭlick the Databases tab, and select one of the 10 database templates (*.mdz files) to build your new application from (see Figure 3.2). To use the Database Wizard to create a sample application from an Access 2002template, follow these steps:Ĭhoose Programs, Microsoft Access from the Start menu to launch Access 2002 with the New File task pane visible. Template files contain thedefinitions of Table, Form, and Report objects, plus the VBA code required to automateinteraction of these objects. Using the Database Wizard to generate a new database from one of the 10database templates included with Access 2002. Opening an existing database, such as Northwind.mdb, the NorthwindTraders sample database that's located in \Program Files\MicrosoftOffice\Office10\Samples.Ĭreating a copy of a database from an existing Access file. The New Filepage offers you the following options: ![]() When you launch Access 2002, the new Office 2002 task pane appears at theright of the main window with the default New File page active. ![]() Learn More Buy Creating an Access Application from a Template File Special Edition Using Microsoft Access 2002
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |