Applicable course objective: · demonstrate problem-solving skills by identifying and resolving issues relating to information systems and their components, and proficiently utilise different types of information systems software (especially gaining proficiency in utilising databases, spreadsheets, and presentation applications). · demonstrate written communication skills by understanding basic information communication and technology (ICT) terminology for effective communication and applying it within a business environment. Applicable graduate qualities and skills gained from this assessment instrument: · Problem Solving (Skill U2) · Written & Oral Communication (Skill U4) This assignment is quite complex, and exposes you to many different components in Microsoft Access 2007/2010/2013, some or all of which might be very unfamiliar to you. The assignment description provides some explanation of how to use these components, but you are also expected to use available resources such as Online Help, the Beskeen et al text, the Practical Skills sections at the end of each Module in the Study Materials, the SAM online tutorial activities and the course discussion forums, as well as exploring and experimenting on your own. Preamble Dr George Martini retired in 2010 after a long, but relatively boring, career as an accountant. To keep busy and to fulfil a lifelong dream, Dr Martini started a Memorabilia mail order business, specialising in Game of Thrones Memorabilia related products called the "The Seven Kingdom Collective" and began selling various types of imported Game of Thrones merchandise such as statues, replicas, giftware, clothing and other assorted Game of Thrones paraphernalia to customers via mail order around Australia. These types of Game of Thrones merchandise have become very popular, especially since HBO TV series and Dr Martini has experienced a rapid growth in his mail orders. When Dr Martini first retired, he bought his own home computer to help manage the business's books and finances. The Seven Kingdom Collective is located at Shop 4, 891 Kings Landing Close, Toowoomba (about 100 km west of Brisbane). Dr Martini can be contacted via phone on (07) 4637 7869; fax on (07) 4637 7860; or email on [email protected]. Dr George Martini is extremely impressed with our computing firm "Night's Watch Systems" and he has contracted our firm to assist him in setting up his various computer-based information systems. Please use our new business contact details as follows: 25 Westeros Street, Toowoomba; Phone (07) 4632 5821; fax on (07) 4632 5827; email [email protected]. The first computer-based information system that Dr Martini is interested in is a Database Management System (DBMS) utilising Microsoft Access 2007/2010/2013. The DBMS will be used to store all of the business's customer details, information about the stock items that the business sells, the suppliers that the business uses and all postal order transactions for the business. It will allow Dr Martini to run a number of queries on the data which he has specified below and he wishes to be able to print out an invoice for each customer at the end of each month.