System Design Report: User Authentication, Reports, and Modules

This report presents a detailed system design, outlining the module hierarchy and functionality of a software application. The report describes the login module, which handles user authentication using a VBA script to compare user inputs with database credentials. It also details the design of the user interface, including a login screen and a dashboard, and provides descriptions of various reports such as orders by month, orders by customer, cost of goods, materials purchase, and revenue reports. Furthermore, the report covers the coding of six main modules: login, products, customers, staff, orders, and reports, detailing the functions each module performs. The report also covers how the application is used and the reports generated by the application.

System Design
[Name]
Institution

The applications module hierarchy is as shown below;
When the application starts, the login page automatically appears. The users can log in using
their first name and the default password; admin. The login page queries the database for the
credentials and compares the user inputs with what is stored in the database. This is done by a
VBA script. Upon successful login, the system redirects the users to the home dashboard where
various options are available.
Login Screen Mockup
The Login screen will have a section for selecting the user and a field for typing in the password.
Two buttons will are provided; Login and Exit. The exit button closes the system while the Login
invokes a VBA script which processes the login process.

Dashboard Mockup
All the forms have options to navigate through records, save new records and delete a selected
record. For ease of operations, all navigation controls are placed on the right side of the form.
The designed forms use a light blue and light green shades for background colors.
Reports
 Orders By month: this report summarizes number of orders per a given calendar month.
The report will help in identifying months that are good for business and the general
growth in sales as the year progresses.

 Orders by customers; the report presents a summary of customers and total number of
orders they have placed. This report helps to identity the most valuable customers as well
as help in marketing.
 Cost of Goods; the report presents quantity sold per product total sales and the cost of the
products sold. The report is critical in calculating profits as well as identifying products
with low inputs but high returns.
 Materials purchase; the report outlines customers, products and quantity purchased. The
report is critical in understanding customer preferences, for use in targeted marketing
campaigns.
 Revenue report; the report presents a breakdown of sales, costs and margins.
 Charts; the charts help to visualize various reports such as orders by customers.
Coding of modules
The application consists of 6 main modules; the login module, products, customers, staff
module, orders and reports module.
 The login module handles user authentication.
 Products Module; handles products and interactions with products.
 Customers module; this module handles all functions related to customers; adding new
customer, deleting a customer and editing the details
 Staff module; the module contains functions required to add, edit and delete staff from
the system.
 Orders Module; the module contains features and functions required in managing orders
such as creating a new order, altering order details, deleting an order etc.
 Reports Module; the module contains all the required reports by various stakeholders.
The reports include; orders by month report, orders by customer, revenue report, charts
among others.