NEW
Font size
WorksheetsFinal Exam - CC25
Total questions: 20
Worksheet time: 10mins
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
What is the purpose of a database management system (DBMS)?
To store data
To manage and organize data
To create user interfaces
To write code
Which of the following is NOT one of the main components of a relational database?
Tables
Queries
Reports
Algorithms
What is the term used to describe the process of combining data from multiple tables based on related columns?
Merging
Joining
Appending
Linking
Which of the following actions can be performed using a macro in MS Access?
Creating a table
Writing a SQL query
Printing a report
All of the above
Which operator is used for string concatenation in Visual Basic?
.
+
||
&
What is the purpose of normalization in database design?
To improve data security
To optimize query performance
To minimize data redundancy
To create backups of the database
What is a foreign key used for in a database?
To uniquely identify each recor
To establish relationships between tables
To encrypt sensitive data
To sort data in a table
What is the purpose of the "Comment" action in MS Access macros?
To disable a section of the macro code
To execute a SQL query
To open a dialog box for user input
To add explanatory notes within the macro
Which object in MS Access can be used to store and execute macros?
Modules
Forms
Queries
Tables
What is the purpose of the Exit statement in Visual Basic?
To terminate a loop or select statement
To end the current function or sub-procedure
To close the application
To skip the current iteration of a loop
