WorksheetsMS Access-Forms, Queries and Reports
Total questions: 20
Worksheet time: 7mins
A ____________ is a unique identifier for a record in the table.
line item
data type
primary key
property field
The _____________ defines the type of data stored in a field.
query grid
field name
record type
data type
File extension for MS Access is ______________.
.accdb
.acdb
.accd
.access
In a database, a "form" allows you to...
Create a query
Enter data and edit it in a simple form that consists of the fields from a table
In database , we can
Add the record
Delete the record
Amend the record
All the above
What are the 4 main objects in a database?
Tables, Forms, Reports, Keys
Spell Check, Grammar, Ruler, Tools
Tables, Queries, Forms, Reports
Cells, Columns, Rows, Sheet
In a database, all the information about one person or thing is called a
Worksheet
Presentation
Record
File
This is specified as a condition in a query.
option
data type
criteria
A small graphical representation of an organization or theme.
Theme
Logo
Form
From which tab we can generate Reports and Queries?
File Tab
Home Tab
Create Tab
Database Tools
We can generate Reports and Queries from:
Tables
Form
Cells
Where are the previous, first, next and last record buttons are located?
Title bar
Menu Bar
Navigation Bar
Which button allows us to select an attractive layout from many readymade available layouts?
Design
Auto Format
Navigation
You can specify a criteria for a report.
True
False
Once a Report has been generated, it cannot be customized.
True
False
