Final Exam - CC25

What is a database?

• A collection of related data

• A software application

• A programming language

• A type of computer hardware

What is the purpose of a primary key?

• To sort the data in a table

• To provide a unique identifier for each record

• To establish relationships between tables

• To encrypt sensitive data

Which of the following is NOT a data type commonly used in databases?

• Integer

• Text

• Date/Time

• Python Script

What is a macro in MS Access?

• A set of instructions to automate tasks

• A type of database query

• A programming language

• A way to create forms and reports

Which of the following actions cannot be performed with a macro in MS Access?

• Opening a form

• Running a query

• Compiling code

• Importing data

How are macros typically created in MS Access?

• By writing code in a text editor

• Through the Macro Designer

• Using the Query Wizard

• By recording user actions

What is the purpose of the Dim statement in Visual Basic?

• To define a function

• To declare a variable

• To start a loop

• To print output

Which keyword is used to end a loop in Visual Basic?

• Stop

• Quit

• End

• Next

What is the correct syntax for an If statement in Visual Basic?

• If (condition) { ... } Else { ... }

• If condition Then... ElseIf... Else... End If

• if condition: ... elif: ... else: ...

• If condition -> ... ElseIf -> ... Else -> ... End If

Which of the following is NOT a valid data type in Visual Basic?

• Integer

• Double

• Boolean

• List