Blank Database

Access Project Using Microsoft AccessSpring 2021The purpose of this assignment is to help you gain a basic understanding of both MS Access and relational database concepts. You are to create tables, forms, queries, and reports for a database that deals with accounting service billing. Instructions for Microsoft Access are given in these instructions. You may use another version; however, you will need to be able to adjust the instructions.Special Note: All examples contained in these project notes are for illustrative purposes only. This is an individual project. Your data should not look like the examples or the data of any other student.Create an Access Database: After starting MS Access, click the Blank Database icon near the top of the right frame. Change the filename in the pop up window textbox. Name your database as follows: xxx_Billing.accdb (where xxx represents your first initial and last name. For example, I would name my database MSargent_Billing.accdb). Click on the folder icon to the right of the textbox to select the folder location of your database. Then click the Create button.Create Tables: When your database first opens, you should see Table1 by default. Click the View icon (top left of the icon ribbon on the Home tab) and name your table as specified on the next page (i.e. the first table should be named Service). If you do not see Table1 or if you are ready to create another table, click the Create tab, then the Table icon followed by the View icon.The Field Name should be input as described below and the Data Type should be selected from the drop-down list in the top section of the Table window. The Field Size, the Caption, Input Masks, Validation Rules and Validation Text, and any other required information (see comment column for additional information) should be input in the Field Properties section of the Table window. See the figure below and the information on the next page.