BTS 268 Advanced Business Data Management Tools • 5 Cr.
Course covers additional user interface features of a relational database. Advanced Wizards are used to create a user interface. Topics include action queries, macros, modules, switchboards, and startup options. Prerequisite: BTS 168.
After completing this class, students should be able to:
- Create specialized information through use of action and cross tab queries
- Build a customized user interface with macros, macro groups, command buttons, and procedures
- Enhance database design using many-to-many and one-to-one relationships
- Provide database continuity with proper documentation
- Improve database functionality using properly compiled and tested Function procedures, Sub procedures, and event procedures
- Maximize database efficiency by analyzing database performance, splitting databases and linking to external data sources
- Secure data using passwords, startup options, replication, and backups
- Submit written work in accordance with BC writing benchmarks