Use a graphical User Interface (GUI) – based database application to solve problem – 117927: Formative Assessment – Section A

Question 1 (SO 1, AC 1, AC 2, AC 3)

I.) What are the benefits of developing a working plan before designing and implementing a database?

II.) Identify the key elements of a database working plan.         

Question 2 (SO 2, AC 1, AC 2, AC 8)

Identify and describe 3 ways of creating database tables.   

II.) What is a database form and what are its benefits.  

Question 3 (SO 3, AC 1, AC 3, AC 4

1. Identify 4 types of filtering that can be used to retrieve specific information in a database 

II.) What are the benefits of creating queries in a database?      

Question 4 (SO 3, AC 4)

Identify the steps that must be taken to run a saved query in design view.   

Question 5 (SO 5, AC 1)

Explain the benefits of creating a database report.               

Question 6 (SO 5, AC 2)

What are the benefits of grouping data in a database report?

Section B: Multiple Choice

1. Which object is used to create a form? (SO2/AC2)

2. What determines a table’s sort order? (SO4/AC1)

3. What is an intersection of a row and a column? (SO2/AC1)

4. Which tool do you use to create a query object? (SO3/AC3)

5. What is the purpose of indexing? (SO3/AC1)

6. Which is the valid data type in Access? (SO2/AC1)

7. How do you describe a property in MS Access? (SO2/AC1, AC2)

8. In a datasheet, which icon appears at the left side of a record while it is being edited? (SO2/AC3)

9.  Which of the following data types retains only two values? (SO2/AC1)

10. Which of the following is not a type of action query? (SO3/AC3)

11. Which query do you use to answer the question “Which employees earn more than R7000 a month”? (SO3/AC3, AC4)