NEW
Font size
WorksheetsDatabase Management System
Total questions: 30
Worksheet time: 10mins
Which Access object primarily stores data in rows and columns?
Form
Table
Query
Report
Which data type is best for storing a True/False value?
Byte
Boolean
Lookup Wizard
Number
What is the main purpose of a Primary Key?
To speed up queries
To ensure uniqueness in each record
To link unrelated tables
To encrypt data
How do you establish a relationship between two tables?
Using a common field
By matching field sizes
By matching Auto Numbers only
Through macros
The property that sets the maximum length of a Text field is
Field Size
Format
Input Mask
Validation Rule
The Lookup Wizard is used to
Create a dropdown list from another table or query
Restrict numeric input
Automatically number records
Define relationships
Referential Integrity ensures that
You cannot delete a record that’s referenced by another table
Duplicate records are allowed
Only text fields can be related
Null values are permitted
The Format property
Converts data types automatically
Changes the actual stored value
Locks a field from editing
Controls how data is displayed
A Validation Rule to accept only numbers greater than 100 is
>100
>=100
<100
=100
The Input Mask property is used to
Change field size
Create relationships
Restrict the data entry format
Prevent duplicates
Which data type is most appropriate for currency values?
Number
Currency
Double
Decimal
A Foreign Key is used to
Link tables in relationships
Identify each record uniquely
Create an input mask
Sort records
Which Access object is used to retrieve specific information?
Table
Query
Form
Report
Which criterion will return prices between 500 and 1000?
Range(500,1000)
>=500 Or <=1000
Between 500 And 1000
>500 Or <1000
The AutoNumber data type is ideal for
Primary keys
Foreign keys
Text values
Calculations
If Cascade Delete is enabled, deleting a record in the main table
Deletes the entire database
Creates a backup automatically
Deletes related records in the child table
Prevents deletion completely
Bound forms differ from unbound forms because:
Bound forms can’t display queries
Bound forms are connected to data sources
Unbound forms edit table data
There’s no difference
To prevent users from leaving a field blank, use the property
Required
Default Value
Input Mask
Format
Which feature can automatically detect relationships?
Relationship Tool
Lookup Wizard
AutoForm
Data Analyzer
The Default Value property
Automatically fills in a value for new records
Prevents editing a field
Creates a validation rule
Locks record entries
Which property restricts entries to certain patterns such as phone numbers?
Indexed
Format
Field Size
Input Mask
Which data type automatically generates a unique number for each record?
Number
AutoNumber
Currency
Short Text
What happens if referential integrity is not enforced?
Relationships cannot be created
Data will not save
You may have orphan records in related tables
Queries will not run
Which object allows you to create a user-friendly interface for data entry?
Form
Report
Query
Table
Which field property defines how Access stores numeric data internally?
Field Size
Format
Input Mask
Validation Text
What is the advantage of indexing a field?
It encrypts stored data
It prevents invalid data
It speeds up search and sort operations
It hides field content
The command Compact and Repair Database is used to
Delete unused tables
Create automatic backups
Fix errors and reduce database size
Encrypt the database
What’s the difference between “Backup Database” and “Compact & Repair”?
Backup erases old data
Both perform the same function
Backup creates a copy; Compact & Repair optimizes the file
Compact & Repair only compresses images
Which expression in a query calculates total sales?
[Quantity]*[UnitPrice] AS TotalSales
Sum(Quantity, UnitPrice)
=Quantity*UnitPrice()
[UnitPrice]/[Quantity]
The Input Mask “(999) 000-0000” represents
A date format
A currency format
A phone number pattern
An SSS format
