ITEC1010 B : Information and Organizations (Fall 2024)
Assignment #1: MS Access 2016
Due Date: October 24, 2024 @ 23.00
Weight: 7.5% of total final grade
Assignment Details:
I- MS Access Database (.accdb file)
In this assignment you will create an MS Access database with content of your choice. It is strongly recommended you use the latest MS Access 2016 and later versions, but databases created in MS Access 2013 or MS Access 2010 will also be accepted (not earlier versions).
Your database must meet the following qualitative and quantitative criteria:
1. The DB must contain at least 6 tables. (7.5 marks)
2. The tables must be consistent (i.e., it must represent a single entity, and all columns must be logical attributes of that entity). Each table must have a minimum of 4 attributes and a minimum of 12 records. (7.5 marks)
3. The DB must have at least four relationships between the tables. At least one of those relationships must be a many-to-many relationship (5 marks)
4. You must use at least five different data types across all 6 tables. (5 marks)
5. You must have at least two examples of Input Mask. (2.5 marks)
6. You must have at least one example of Validation Rule and Validation text. (2.5 marks)
7. At least one lookup must be used with reference to another table. (2.5 marks)
8. One form. must be created involving fields from at least three tables. (5 marks)
9. One report must be created involving fields from at least three tables. The report must present a subset of data answering a specific question regarding the data. (5 marks)
10. One query must be created involving fields from at least two tables; the query must present a subset of data answering a specific question regarding the data. (7.5 marks)
II.- Video in MP4 format
Short video in MP4 format showing yourself presenting your work. As a minimum You should include in your video:
a) A view of the tables and relationships (as in picture below) explaining what your database is used for and how the relationships work. (20 marks)
b) The form. you created from point 8 above and explain visually the steps to create it (10 marks)
c) The report that you created from point 9 above and show visually the steps to create it (10 marks)
d) The query that you created from point 10 above and show visually the steps to create it (10 marks)
Your video must record yourself and the MS Access application running as shown below. You can use Zoom or the tool of your choice to record your live presentation.
III.- You must upload toeClass only two files:
- A single .accdb file with the database you have created (do not use .zip or other archive files)
- The video file in MP4. The size of your two files should be less than 2GB.
Where to get MS Access:
1. If you have a Windows PC, then install Office 365 (it includes MS Access)
https://www.yorku.ca/uit/faculty-and-staff-services/software-and-apps/
Or use York University computer labs to work on your assignment.
https://www.yorku.ca/uit/student-services/computer-labs/
2. If you have a Mac, then you have three options:
a. Use a Windows PC from your home (if you have one, you can install Office 365 there as well) or use York University computer labs.
https://www.yorku.ca/uit/student-services/computer-labs/
b. If you have a license of Windows (or planning to buy one), then install it in your Mac using Parallels or VirtualBox. Once Windows is installed in your virtual environment then you can goto point 1 and install Office 365 from YorkU.
c. If you do not have a license of Windows (or not planning to buy one) then you can run MS Access in your Mac remotely from YorkU MyApps (this is the least preferred option as you are more likely to run into problems, but it works)
https://myapps.yorku.ca/login