A form is mainly designed for entering and displaying data. As forms are an important primary interface between you and your clients, Microsoft Access allows you to decide how you want to present data on a form.
The AutoForm creates a basic form which you can then adapt to your needs, while the Form Wizard allows you greater control over the appearance, content, and layout of your form.
Subforms can be based on a table or a query. Using the Form Wizard, you can create a main form and a subform at the same time. You can also add a subform to an existing form using the ^USubform/Subreport^u button on the Toolbox toolbar.
Access allows you to nest a subform within a subform to give you easy access to the data you need.
@@
You have seen the variety of ways in which you can customize your Access 97 forms.
|
Creating a form, without using a wizard, allows you the freedom to choose exactly how you want to set up your form.
All information in a form is contained in controls.
Using controls, you can enhance the appearance of your form, improve its readability, and guard against the possibility of error when entering data.
All controls on a form are separate objects. Access allows you to resize, change, modify, format, or delete them.
Access allows you to enhance the appearance of your form by formatting its controls, and by using pictures and images to add to its appeal.
Charts are useful to illustrate the data shown in tables or queries. Using source data, you can create a variety of charts. Access allows you to create chart types which you can format and adapt to your needs.
@@
You have seen how reports are created and used in Access 97, and how database objects such as reports and forms are printed.
|
Reports are an excellent way to summarize and present data taken from a database, in printed form.
You can choose to group and sort data to make a report easy to understand.
Once a Report Wizard has generated a report, you can add more controls, change the sort order, and customize headers and footers to suit your needs.
Using the ^USorting and Grouping^u button, you can organize the information on your report in more meaningful ways.
You can add a subreport to an existing report using the ^USubform/Subreport^u button on the Toolbox toolbar.
Access allows you to nest a subreport or subform within a main report, to give you easy access to the data you need.
You use the ^UPrint^u button on the toolbar to print a table, report, or form quickly, using the default settings. If you want to specify additional criteria such as print range, you use the ^UPrint^u option on the ^UFile^u menu.
