Knowledge
- Understand the principles of data management and relational databases. Skills
- Develop a time sheet entry/customer account management software system using relational database software and prepare an associated report detailing the technical and learning issues encountered.
- Work effectively as a team member. Values
- Appreciate the evolving nature of Accounting Information Systems, and how these are reshaping the practice of Accounting.
This assignment is designed to help you to understand how data is stored and information is retrieved in Information Systems. Working together in teams of two, you will develop skills with Microsoft TM Access and Word. It contributes 20% towards the overall assessment in the unit.
It is best if you:
- Read through the entire assignment before you commence work;
- Prepare your report at the same time as you create your software;
- Learn how to capture ‘screen shots', trim the part you want, and then place these screen shots into a Word document before you begin preparing your report;
- Understand that this assignment is not only about learning MS Access, it is also about the approach to developing a new skill.
Relax and enjoy doing this assignment. You can learn a lot. If you make mistakes, that's great! It is by correcting mistakes, or deleting part of the work already done and re-doing it that we learn. In IT attention to detail is most important. This assignment demonstrates the importance of attention to detail, something you can apply to your studies and to your work.
Before you commence work on this assignment, it is strongly suggested you work through one or more of the on-line tutorials at https://office.microsoft.com/en-us/access-help/download-office-2010-training-HA101901726.aspx?CTT=1 to become familiar with Access 2010. This website has free on-line courses showing you (among many other things) how to create tables (the basic components of a database) and when to use Access and when to use Excel.