Section A
1. Create an MS Access database named “Your Name – IOUs.accdb”.
2. Create one single table within it named “Your_Name”
3. Give that table 1 single field named "Answers", and makes its Data Type "Attachment"
4. Answer the following questions in an MS Word document named “Your_Name.docx” and then attach it to the first record in the “Your_Name” table (note that when it is attached it
will be stored within the .accdb file, so you will only have to upload the .accdb file to Moodle, not the .docx too):
a. Take this chance to let your teacher know how you are finding this subject. If you think you are keeping up with the learning, say so. If there are things you fear you aren’t understanding or if you have suggestions, your teacher would like to hear about it.
b. Explain in your own words how the following piece together in a database: table, field, record, attribute, coloumn, row, data type, entity, table relationship, Autonumber, primary key, foreign key
c. Which of the following can be used to insert new records into a database: table design view, table datasheet view, reports, macros, queries, forms
d. Which of the following can be used to alter the structure of tables in a database: table design view, table datasheet view, a report, a query, a form
e. Describe 2 examples how a Form can be used to improve the speed of a secretary's data entry
f. Explain how a Form can be used to improve database security
g. Database software:
• Who owns/creates MS Access?
• Name another DBMS that this company creates and sells to larger companies?
• What is the name of the database programming language that is at the core of all popular database software and what are the names of the “flavours” of that language found in MS Access and MS Server?