Сделать базу данных в Microsoft Access на английском языке.

STUDENT INDEPENDENT WORK 2.1

MS Access

Perform database design based on the requests. The database should contain:

1. Tables for a given subject area. The number of tables is determined during the design process, but not less than three. Each table should contain eight records.

2. Ten requests:

- one to sample to each table;

- two cross;

- two to sample related tables;

- two with parameters to related tables;

- one with a calculated field;

- two with group operations. When filling out the wording of the request is required.

3. Forms: - the main and subordinate;

- one autoform.

4. Reports:

- one auto report;

- one created by the Report Wizard or in Design mode.

5. Button form. When creating objects in the database, OLE objects (pictures, photos), the capabilities of the Wizards, Constructor and Builder should be used.

Task 1. Hotel Database Indicative tables: “Numbers”, “Accounts”, “Clients”