Share this Page URL

Chapter 1. The HelloWorld Database > Enhancing Our Simple Form - Pg. 19

The HelloWorld Database 1. 2. 3. 4. 5. In the Database window, select the table or the query that includes the records you want to display in the report. On the Insert menu, click Report. From the field list, drag the fields you need on the report to the report sections. Click the Properties button on the toolbar, and then set properties for the report's fields. For example, you might set font properties for the display of text. Save the report. 19 Enhancing Our Simple Form You can see from these examples that tools such as the Form Wizard and the Simple Query Wizard help you complete a lot of the work required to create a database. But many databases require some specific refinements to their design--information you can't always convey to a wizard. In this section, we'll develop our form a little more. We'll open the form so that we can modify its design by hand, take a quick look at the tools you use to design forms, and then add a command button to the form. We'll also change the settings for a couple of the properties for the command button and the form. In the next section, we'll use Visual Basic code to make the button do what we want--in this case, open the report we just created. Working in Design view You can be creative when designing forms by hand. You can pick the color for the text the form displays, and you can pick the background color for the form. You can add images to forms and display banners in large, boldface type. You also get to pay attention to details such as whether every button is the same size or whether a list box displays items in the correct order. One important point to keep in mind when you're designing a form is that human beings will use it. A form's design needs to make its function immediately apparent, which is