What This Document Is
This is a laboratory exercise designed to accompany the CGS 2545 Database Concepts course at the University of Central Florida. It provides a practical, hands-on experience working with database management systems, specifically Microsoft Access. The lab builds upon previously learned concepts and introduces more advanced features for database design and manipulation. It’s intended to be used in conjunction with course lectures and other assigned materials.
Why This Document Matters
This lab is essential for students enrolled in CGS 2545 who want to solidify their understanding of database principles through practical application. It’s particularly helpful for those who learn best by doing and for anyone preparing for more advanced coursework or professional roles involving database management. Successfully completing this lab will enhance your ability to create, modify, and optimize databases for real-world scenarios. This resource is most valuable when used during scheduled lab sessions or as a supplementary study aid.
Topics Covered
* Indexing strategies for improved database performance
* Primary key implementation and its impact on data integrity
* Creating indexes on both key and non-key fields
* Managing duplicate values within indexed fields
* Database design best practices within the Access environment
* Utilizing the Access interface for table manipulation
What This Document Provides
* A focused exercise centered around a pre-existing database schema (supplier-parts-jobs-shipments).
* Guidance on navigating the Microsoft Access interface.
* A series of tasks designed to reinforce core database concepts.
* Visual references illustrating key steps within the Access environment.
* A structured approach to building and refining database structures.
* Clear indications of where practical application and experimentation are encouraged.
