Open the CUSTOMERS form in Design View.

Go to Design section, click the command button – icon named BUTTON, draw a rectangle on the form /detail section/, choose form operations, open form – next.

Select form name Products, next, open form and show records, next, choose text option – in the text field type PRODUCTS, click next, finish.

Go to the data entry view and test functionality of this button.

Go back to the design view, and create buttons to open the orders form.

Create another command button, choose Report operations - Preview report, next, choose LastNames, next, choose the text option - LAST NAMES, next, finish.

Similarly, create buttons for the other 2 reports.

Adjust the form’s appearance (make it larger, reposition the command buttons, insert a line, etc.)

In the footer, add command buttons to close the form (form operations – close form) and exit MS Access (application – quit)

In footer, add current date and time TEXT BOX. Click – ab button, draw rectangle, delete its text label, and in the text box type =now()

Similarly, adjust the PRODUCTS and ORDERS forms.

Click Database Tools – icon Relationships, and add all 3 tables. Close the window and save changes.

Open the Orders table in Design View, click CustomerID data type cell and select option Lookup Wizard. In the dialog window select 1st option, Next, choose table Customers, Next, Move Customer ID and Lastname to the right section, remove checkmark from “hide key column” Next, Finish.

Create a lookup field for ProductID

Check out the CustomerID and ProductID fields on Orders form to see the option menus and then check the relationships window.

Open the Orders form in Design View, delete the CustomerID and ProductID fields, activate the field list – click the Add Existing Fields icon under the Design section and drag and drop the two attributes fields from the field list in the detail section. Rearrange thefield order on form.

Click Create – Form Design.

Insert header with a label - company name.

In the detail section, insert 3 command buttons to open the 3 forms (customers, products, orders) and other 3 to preview the reports (food, clothes, lastnames)

In the footer part, insert 2 command buttons to close this form and exit MS Access. Also, the footer will contain current date.

Format the form appearance and save this form as INDEX.

Click the macros tab – New

In the 1st row choose minimize, in the 2nd row open form, in the action arguments part choose form name = Index, and in the third row select the restore command.

Save this macro as autoexec. Close the database and open it again to check the functionality of the autoexec macro.

Create a new form – new – design view

Draw a label with title – Currency Converter (Euro/Sk), below a text box with label text Insert the price in Euro and press Enter, and below insert another text bow with label text Price in Sk.

Select the 2nd text box – right-click – properties – data tab. Click the button next to the Control source field and in the Expression builder dialog window double-click text0 /the name of the 1st text box/, click *,  key in 35, click ok. In the design view check the functionality of the calculated control and enter some number in the 1st text box..

Insert the close form button and save the form as Converter.

Add command buttons to open the converter from Index, Products, and Orders form.