An important prerequisite for CMIS 351 is to have working knowledge of Microsoft Access. This requires both that you understand the fundamentals of relational databases and that you can apply this knowledge in Microsoft Access.
To assess whether you have the necessary skills, we have created a two part self-assessment exercise. The first part tests your knowledge of relational databases, and the second part tests your ability to create queries in Microsoft Access. If you can answer at least seven of the ten Part 1 multiple choice questions correctly, and create all three queries in Part 2, you should have sufficient Access knowledge to complete the assignments in CMIS 351.
Download this Microsoft Access database: link
If you have an older version of Access and are unable to open the data file above, try this one: link
The database contains fictional student grade data. The “Student Grades” table contains the names of the students, the courses they completed, the dates each student started and completed each course, and the grade each student received. The “Grade Conversion” table shows the numeric value for each possible grade.
Create queries to answer each of the following questions:
To check your answers, click link to Access query answers.docx.