Once students become competent in Access, they can apply these skills in newer contexts, such as creating databases to record financial transactions associated with revenue and expenditure cycles.Īs noted earlier, existing Access instructional resources are available, but tend to be long and complex.
By using familiar tasks (tracking assignments and grades), students can focus on learning database design and implementation, rather than being concerned with whether they are properly applying accounting rules and conventions. The project purposely focuses on a non-financial context that is familiar to students. The project requires students to create tables, add validation controls on fields, design forms to ease data entry, create relationships, and develop useful queries and reports. Students create a database to keep track of students, assignments, and related dates and grades on assignments. This project introduces students to database implementation using Microsoft Access 2013. Virtually all introductory accounting and management information systems (AIS and MIS) courses include database design as a topic ( Murthy & Ragland 2009). While accounting graduates will probably never need to create a database from scratch, they will routinely evaluate data, processes, and controls associated with databases.
Although students interact with databases on a daily basis (e.g., student registration system, online shopping, social media sites), they rarely think about the underlying structure, design, and controls of those databases.