Share this Page URL

Part II: The Database Application > Completing Your Database Application - Pg. 457

457 Chapter 13. Completing Your Database Application In this chapter, you will learn how to: · · · · · · · Create a macro group and add conditions to a macro Create an application switchboard Create your own menus and toolbars Assign a toolbar or a menu to a form Customize toolbars and menus Set startup options for a database Add a smart tag to a control or a field While you build a database in Microsoft Office Access 2003, setting up tables and queries and designing forms and reports, you rely frequently on the Database window, the Access menus, and the various toolbars that Access provides to help you create and fine-tune the database objects that you and other users work with. In the day-to-day operation of a database, however, every user won't need to create a new form or change the design of a table. In a database used by more than one person, you'll probably want to assign tasks such as modifying tables or creating new reports only to users with full knowledge of the database's structure, while still providing the means for all users to work with the data in the ways they need to. To work through this chapter: · You should understand the fundamental techniques used to design a form and how to create a basic macro. For information about how to design a form, see Chapter 7, "Designing Basic Forms." You'll find information about creating a basic macro in Chapter 4, "Importing and Linking to Data." See Also For more information about setting permissions for database objects, seeChapter 19, "Im- plementing Security." In this chapter, we'll describe steps you can take to complete a database application. You'll learn how to create your own toolbar, for example, which lets users perform database operations such as opening a form and printing a report without using the Database window. We'll create an appli- cation switchboard, a form that includes links to key database tasks and helps direct the workflow in a database. You can display a switchboard (or another form) automatically when a database opens. We'll also explain other ways in which you can customize the Access user interface. To start, we'll describe more of the work you can do with macros. We'll use the macros we create in the next section when we set up the application switchboard form later in this chapter.