Choose one of the below systems and create a database for it using all the skills we have learned in Microsoft Access 2016; · Hospital · Dental Clinic · Bank · Library

Choose one of the below systems and create a database for it using all the skills we have learned in Microsoft Access 2016;

· Hospital

· Dental Clinic

· Bank

· Library

· School

· Car rental company

· Airline company

· Super Market

· Mobiles Shop

· Restaurant

· Video store

· Football tournament

· Car service company

· Quranic database (Tafseer, meaning, Tajweed, …..)

· Hotel system

· Travel agency

Or You can suggest one and see if the instructor agree on it.

Outlines

· Tables:

· At least 3 tables

· Choose fields and define appropriate data types

· Define a primary key for the tables

· Use the suitable properties (such as validation rule, validation text, and field size)

· Fill the tables with a real data (at least 8 records)

· Draw tables relationship

· Queries:

· At least 3 Queries

· Display data from one table

· Display data from multiple tables

· Use criteria to show data based on some conditions

· Use suitable operators (<, >, >=, <=, <>, =, between) in the criteria

· Forms:

· At least 3 Forms

· Modify headers and footers sections to include all necessary information (such as date time and title and some notes if you need)

· Choose appropriate layout for the form with good size for all controls.

· Make sure you use a mix of controls (text, option, combo,….)

· Add some commands on the form to make things easy such as the record navigation commands, form command, …. Etc

· Reports:

· at least 3 Reports (accept default settings in a wizard

· Add your name and section number in the report footer

· Add some controls (label, image, date/time, textbox,……etc)

· Group data and sort them