You are here:

Challenges in Database Design with Microsoft Access

Journal of Instructional Pedagogies Volume 15, Number 1, ISSN 2327-5324


Design, development and explorations of databases are popular topics covered in introductory courses taught at business schools. Microsoft Access is the most popular software used in those courses. Despite quite high complexity of Access, it is considered to be one of the most friendly database programs for beginners. A typical Access textbook teaches students first how to design and build databases. Next the students are exposed to forms, reports and queries. Advanced courses also delve into applications of modules and macros. In many database design situations, separation of a logical data model from its physical implementation is necessary. Nontechnical, subject-matter, experts and end-users can better understand the logical data model and thus they can help improve the model's structure. This paper focuses on the database design phase. It shows a database design cases implemented in MySQL Workbench and in Microsoft Access. It also attempts to expose some difficulties and anomalies that may be encountered when using exclusively Microsoft Access. Alternative logical-design solutions are also presented.


Letkowski, J. (2014). Challenges in Database Design with Microsoft Access. Journal of Instructional Pedagogies, 15(1),. Retrieved November 28, 2021 from .

This record was imported from ERIC on January 10, 2019. [Original Record]

ERIC is sponsored by the Institute of Education Sciences (IES) of the U.S. Department of Education.

Copyright for this record is held by the content creator. For more details see ERIC's copyright policy.