1. Design a Report showing all the data by joining tables with effective colors, logo, title, date and pictures.

The report should include the following requirements: a. Display without repetition of information.

1. 2. Use any one filed/column to be arranged in ascending/descending order.
   3. Set any Aggregate functions on tables.
2. Design a macro with any two of the following: (opening and or closing a table, query, form and report).
3. Create switchboards which includes all the forms, reports and macros that you have created.

Self-Study:

4. Design a Model Dialog form by selecting any table/s. The form should have buttons to browse and edit the records for possible operations in the record level.
5. Design a Sub form using any two related tables. The form should have buttons to do all possible operations in the form level. Do all possible formatting.
6. Export any two tables to an Excel Sheet.
7. Create one more database and name it as yourid and yourname and set the password for this database as 100.