Open Microsoft ACCESS and create a new blank database. Save the new database as “Access Assignment 1”. Note: These files have a file extension of .accdb
-40 pts - Create the Database and Table as seen in the YouTube Videos. Create the Table Structure (add the Fields Names,Write a research paper on the Data Types and change appropriate properties as seen on the YouTube Videos) …look below for the Table Structure. Name the table as the video shows (CustomerT). Watch the videos carefully and take notes if you need to. After doing the table, then you do the next instruction…
-60 pts - populate the table or add the 1st record to the table as seen on the videos. Important: Once you add the 1st record, you will then “ADD” fifteen additional records for the assignment. You will make-up the data and make sure to fill-in data for “all” the fields. Feel free to use sample output below or make up your own.
Close Microsoft Access and use the appropriate link on Blackboard to submit your Access Assignment 1 before the due date.
