QUEZON CITY UNIVERSITY
SIMULATION
REPORT NO. 4
BALINGIT, JERALDINE A.
SBIE – 4B
April 26, 2025
In our laboratory, we developed a basic yet functional database simulation using
Microsoft Access. Our main goal was to create a system that could manage customer
information and order details in an organized and efficient manner. The system included two
primarytables—CustomerIDandOrderID—andutilizedformsandsubformstosimplifydata
input and viewing. By applying the core concepts we learned, we successfully connected
customer data to their respective orders, creating a simple relational database that reflects
real-world business transactions.
Throughout the development process, we encountered several challenges, particularly
with setting up relationships between tables and designing user-friendly forms. For instance,
ensuringthateachcustomercouldbeproperlylinkedtotheirorderrequiredcarefulattentionto
primarykeysandforeignkeys.Moreover,customizingtheformlayouttomakeitmoreintuitive
taught us the importance of good user interface design, even in simple databases. These
experiencesshowedusfirsthandhowcrucialdatabasestructureandplanningarewhenbuilding
information systems, even at a basic level.
Overall,theprojectdeepenedourunderstandingofdatabasemanagementsystemsand
howbusinessesrelyonorganizedinformationfordailyoperations.Italsohighlightedtheroleof
information systems in improving data accuracy, enhancing workflow, and supporting
decision-making.Throughhands-onpractice,wemovedbeyondjusttheoreticalknowledgeand
gained valuable skills that we can apply in larger, more complex systems in the future.
The simulation project was a rewarding experience that allowed us to put
classroom concepts into action. By building a working database from scratch, we
developed a much stronger appreciation for the behind-the-scenes structures that
support everyday business activities. We realizedthatevenasmallsystem—likethe
onewecreated—requiresthoughtfuldesigntoensureaccuracy,reliability,andeaseof
use. This reinforced the importance of strategic thinking when it comes to creating
effective information systems.
Moreover, the project emphasized the importance ofuserexperienceinsystem
design.Itbecameclearthatit’snotenoughforadatabasetosimply"work";itmustalso
be intuitive and efficient foritsusers.ThroughdesigningtheCustomerIDformandthe
OrderIDsubform,welearnedhowessentialitistoconsiderhowusersinteractwiththe
system.Smalldesignchoices,likeclearlabelingandsimplenavigation,canmakeabig
difference in the usability and overall success of a system.
In conclusion, our laboratory about simulation was more than justanacademic
requirement — it was a meaningfullearningjourney.Itgaveusarealisticglimpseinto
the field of database management and helped us understand how crucial information
systemsareinthemodernworld.Movingforward,theskillswedevelopedthroughthis
experiencewillserveasastrongfoundationformoreadvancedprojectsandreal-world
applications.
