NEW
Font size
WorksheetsDatabase Concepts and MS Access Assessment
Total questions: 15
Worksheet time: 8mins
What is the primary purpose of Design View in MS Access?
To enter data quickly into tables
To modify the structure and properties of database objects
To create reports automatically
To run complex queries
In MS Access, what is a record?
A single column in a table
The table design blueprint
A complete set of related data about one item
The navigation pane
Which view in MS Access displays data in a spreadsheet-like format?
Form View
Report View
Design View
Datasheet View
What is the main advantage of using forms in a database?
They allow for easier data entry and viewing
They automatically create tables
They compress the database size
They encrypt the data
When using the Form Wizard, what is NOT a standard option?
Selecting fields to include
Choosing a layout style
Creating automatic calculations
Selecting the data source
Which statement about tables in MS Access is correct?
Tables can only contain text data
Tables are the fundamental building blocks of a database
Tables cannot be related to each other
Tables can only have 10 fields maximum
What happens when you delete a record in MS Access?
It can be automatically recovered
It moves to a backup table
It is permanently removed
It becomes hidden but remains in the database
How can graphics be added to a form in MS Access?
Through the Form Wizard only
Using the Insert Image control
By copying from Excel only
Through query design
What is the best practice for editing records in MS Access?
Always work in Design View
Save after each field modification
Edit directly in Datasheet View
Only edit through queries
Which feature helps in creating a basic form quickly?
Query Wizard
Form Wizard
Table Wizard
Report Wizard
What is a primary key in a database table?
The first field in the table
A unique identifier for each record
The largest field in the table
The most frequently used field
When printing forms in MS Access, what option is available?
Print only selected records
Print in 3D format
Print to multiple printers simultaneously
Print with animation effects
What is the maximum number of tables that can be related in MS Access?
5 tables
10 tables
There is no practical limit
20 tables
Which view is best for creating calculated fields?
Datasheet View
Print Preview
Design View
Form View
What happens when you modify a field's data type in Design View?
All existing data is automatically converted
The database might lose data if incompatible
Nothing changes until you enter new data
The field is automatically deleted
