1. Click the form tab – New – Design View.

2. Click the command button – simple, gray button on the toolbox bar, draw a rectangle on the form, choose form operations, open form – next.

3. Choose form customers, next, open form and show records, next, choose text option – in the text field type Customers, click next, finish.

4. Go to the form view and test functionality of this button.

5. Go back to the design view, and create buttons for opening of the other forms.

6. Click the command button, choose report operations, preview report, next, choose customers, next, choose text option, type customers report, next, finish.

7. Similarly, create buttons for the other reports.

8. Adjust the form’s appearance (make it larger, change colors, arrange the command buttons so that the “open” buttons are in the upper part of the detail section, and the report buttons below.

9. Create header, insert label with your/your company’s name.

10. In the lower part of the detail section insert another command button – choose form operations, close form – next, choose either picture or “close” text, next, finish.

11. Save this form as main.

12. Click the macros tab, in the 1st row choose minimize, in the 2nd row open form, below choose form name – main, in the third row choose restore.

13. Save this macro as autoexec. Close the database and reopen it.

* * *

1. Start MS Excel, select cells A1 to E4, change the background color of this area.

2. Select cell A1, type title Scale 1: 200 000

3. Select cell A3, type km; select cell B3, change background color

4. Select cell D3, type cm; select cell E3, change background color

5. Select cell E3, type formula =0.5*B3

6. Check functionality, save the worksheet, quit Excel.

7. Start Access, new db, form – new – design view

8. Draw a label with title – Scale 1:200 000, below another label Insert the distance in KM and press Enter, below another label with CM on the map.

9. Next to the KM label draw a text box (click the ab button on the toolbox bar), select its text label and delete (we want just the text box). Draw another text box right next to the CM value, again, remove its label.

10. Select the “CM” text box – right-click – properties – data tab. Click the button next to the Control source field and in the dialog window click =, form – double-click text 1, *, 0.5, ok. In the design view check the functionality, add the “close button” and autoexec feature.