Forms, reports, macro modules, and so on in Access (Access 2000)

Form:

Divided into data manipulation forms, which include single-page, multi-page, continuous, sub-windows

Control form

Information Interaction Forms

Form three views: Design view, Form view, Datasheet view

Five ways to create a form:

One: Create a form automatically

Two: Form Wizard (one-to-many relationship can select a form with a ribbon form)

Three: Design view

Four: Chart Wizard (if both axes and series are present well data can only have one)

V: PivotTable Wizard creates a crosstab-like form that requires Excel support

Automatically create three styles for a form: columnar, tabular, datasheet form

Design the composition of the view window:

Five regions, each called a section, called the form header, page header, body, page footer, form footer (I can see the form header and the form footer)

By default, only the "main", other through "view" is displayed.

Double-click the upper-left corner of the small black box to set properties (data source)

Control's use

Type of control:

Bound controls, unbound controls, calculated controls

An option group, such as a control key, is saved as a number, but a lookup field can be used to save as a text conversion.

When you layout a command button, make sure that the wizard presses

tab, option group control belongs to the container class control.

Create a subform: Create a form and a subform at the same time (wizard creation)

Second, add the existing form to the main form

Three is to eject the subform and select Link form in the wizard.

Appearance, etc. resize toolbar on the Format View menu, properties in the "format"

Forms also include: sorting, finding, filtering, and so on

Report:

A report consists of five parts: report header, page header, body, page footer, report footer

A section that is called a report

There are also views-the group header and the group footer in the sort and group commands.

Section selector and report selector

To create a report:

"Auto Create"

The Report Wizard

The Chart Wizard

The Label Wizard

"Design View"

Multi-column report creation: Auto-Create report--columnar--Design view--File--page Setup--Number of columns--column layout

To edit a report:

Sorting and Grouping: views--Sorting and grouping

Set a new row or column for each group of reports: File--page Setup--Columns--Column layout-- group header \ Footer Selector--property sheet--sets a column or new row property.

Before, after, before and after, for the position of the new row.

Insert Page number, current date and time ( located under menu bar-insert option)

Add a calculated control to a report ... =[]/ Data Source settings (& connection string)

Common functions avg () \count () \sum () \

Subreport:

1. Create with the subform \ Report Toolbox through the wizard

2. Use an existing report as a subreport (drag)

Data access page:

is a special access page that is connected to a database.

Types of data access pages: Interactive report pages, data entry pages, data analysis pages

Composition: group header section, Data browsing section

Connect the database First

Create a data access page method: Automatic features, wizard features, creating in Design view, converting an existing Web page to a data access page

Edit Data access page ...

File--web Preview

Design view: Format--Themes

Grouping settings: Toolbars or right-click: <-

Toolbars are grouped and sorted, and others are the same as reports.

`

Macros and modules:

Type of macro: Action sequence macro, macro group (call: Macro group. macro name), a conditional macro (other slightly)

Ext.: http://www.cnblogs.com/_programmer/archive/2009/11/03/1595333.html

Forms, reports, macro modules, and so on in Access (Access 2000)