Objective: Build a comprehensive relational database with tables, forms, queries

Photo of author

By admin

Objective: Build a comprehensive relational database with tables, forms, queries, and reports for the gym clothing brand YOUNGLA. The database should help the company and improve the way that they handle their data. The records
in the tables can be fictitious.
Your Access database should contain at least the following features:
a) Minimum of four tables with at least 10 records in each table. Tables should be designed properly, and
data types should be properly selected.
b) Minimum of four queries. At least two queries should be grouped query (sum, count, average, etc.)
c) Minimum of four forms. Each form should be properly formatted for the best user experience.
d) Minimum of four reports. Two reports should have totals, and/or sub-totals for some financial data.
e) When you open the database, it should populate a menu and the user should be able to navigate
through the database using the menu items.