Help answer 1 In Access, the database window uses the wizard to create a table

It's the same, there's no difference.

A subform is actually a normal form.

You first create a form and save it. Then design the view to open another form, drag the previous form onto this form and try it.

Yes, it is possible to close the dragged form. Just drag from the task pane on the left to an open form.

How to create a form using the Form Wizard in Access 2010:

1 Select Create->> Form Wizard:

2 Select the table that appears in the form:

4 Creation Complete:

A form in Access is a database object that you can use to create the user interface of a database application. The Bindings form connects directly to a data source, such as a table or query, and can be used to enter or display data from that data source. Alternatively, you can create an Unbound form.

1. Click the Create tab and select the Form Wizard option, that is, the Form Wizard dialog box will pop up.

2. In the Table Query drop-down list box, select the name of the table or query that is the form data.

3. Select the fields required by the form and click the Next button.

4. Select the layout, this step gives the form with 4 selection states that can be used for the appearance of the field (column table, **, data table, aligned at both ends). Click the Next button.

5. This step is to create a title for the form and select a title for the form. Click the Done button.

6. Access 2010 will produce a form.

If you are not satisfied with the form you created with the Form Wizard in Access 2010, you can also make changes to the form in Design view.

First, use the database wizard to create a database, including all tables, forms, reports and other objects;

Second, use the table wizard and select fields from various predefined tables;

3. Input data directly into a blank data table, and when a new data table is saved, Access will analyze the data and automatically specify the appropriate data type and format for each field;

Fourth, it is the use of "design"."The view, from scratch specifies the full details of the table's structure, and then populates the data in the table.

5. Import from another table to a new table and save it.

1. Click on the menu: Create - Report Wizard.

The report wizard dialog box pops up, we select the table from the table query column in the drop-down list: inventory transactions, in this table, click the Add All button to add all the fields into. Then click Next.

2. Here we need to set whether to group, the general report grouping can help readers find the data conveniently, so we select the grouping, click the [Thing Creation Date] and then click the Add button. Finally, click Next.

3. Here we want to set which field to sort the records by, we select [Thing ID] in the drop-down list and click Next.

4. In this step, we set the layout of the report, there are three layouts, you can try them all, there is no essential difference. Then set the paper orientation and finally click Next.

5. In this step, we want to set the appearance of the report, the following list is the style that comes with all the systems, choose one from 6, you think it is beautiful, and then click Next.

7. Set the name of the report, and then click [Finish].

8. We see that the print preview of the report automatically pops up, and some data cannot be displayed, because the column width is too narrow, resulting in incomplete data display, which is a common problem encountered in automatically created reports. Let's tackle it below.

9. Click [Turn Off Print Preview] on the menu bar to automatically switch to the design view of the report.

10. In the design view, find the field whose column width is too narrow, drag the lower right corner of the field, drag it to the right to change the width, and drag all the columns to make the column width wider.

11. Finally, in the start menu, click: Print--Print Preview.

12. In the print preview, you can see that the data display is complete.