COMP1750 – G’day – MS Access
Case Background G’day ticketing company has been selling concert tickets featuring different artists for the past 18 years across Australia. You have been hired to build a database to store and record their ticket sales, as well as preparing queries, forms, reports, and a user-friendly navigational menu. Task Descriptions Your tasks in this assignment are as follows: Task 1: Setting up Database Note that anything with “???” means that you will need to assign an appropriate replacement. Create a blank database called GDAY followed by your student ID number (e.g. GDAY12345678). Artist Table a. Create the table Artist with the following fields and properties: Field Name Data Type Description Properties ArtistID Number Artist/Band ID Size: Integer AName Short Text…
Details