WorksheetsQuery and Reports in MS Access (8th)
Total questions: 40
Worksheet time: 13mins
A ____________ is a unique identifier for a record in the table.
line item
data type
primary key
property field
Which of the following is the correct definition of a Record?
It has only one type of information
Collection of Files
All information about a single entity.
Full form of RDBMS is
Relational Database Management System
Rotational Database Maintenance System
Record Management System
Student's Roll no is an example of
Primary Key
Secondary Key
What function enables you to ask questions about the data stored in a database and returns the answers based on your criteria?
Query
Form
Report
When you close a new table, it asks you for what
name of the file
where to save it
nothing
A unique identifier used in creating a table that assures there will be no duplicate data.
Primary Key
Query
Data Type
Where are the previous, first, next and last record buttons are located?
Title bar
Menu Bar
Navigation Bar
We can generate Reports and Queries from:
Tables
Form
Cells
From which tab we can generate Reports and Queries?
File Tab
Home Tab
Create Tab
Database Tools
A small graphical representation of an organization or theme.
Theme
Logo
Form
This is specified as a condition in a query.
option
data type
criteria
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 database , we can
Add the record
Delete the record
Amend the record
All the above
File extension for MS Access is ______________.
.accdb
.acdb
.accd
.access
The _____________ defines the type of data stored in a field.
query grid
field name
record type
data type
A table stores different types of data
✔️
✖️
____________ is used to store alphanumeric datatype?
Numbers
currency
Text
none of these
The _______of the table are called records
rows
column
Which one the correct logo of ms Access?
Ms. Access very useful for manage?
usually a lot of data
a small data
chart
graph
How to open Ms Access in your computer?
Start>>ms.office>>access
start>>access
access
start>> all porgrams>> microsoft office>> ms access
____________ are conditions that identify the records you want to find.
Comparison Operator
Wildcards
Criteria
Query
How many main types of queries are there in MS Access?
2
3
4
Unlimited
Multiple Criteria can be used in a query.
True
False
Which query is used to find the records from one table that do not have corresponding values in the second table?
Duplicate Query
Unmatched Query
Wild Card Query
Matching Query
The two wildcards provided by Access are-
(*) & (/)
(*) & (?)
(%) & (+)
(*) & (%)
While sorting on more than one field, the more important field is called:
Minor Key
Enter Key
Major Key
Primary Key
Run button is present on which tab?
Home
Design
Create
Format
<>
Click ___________ to show the results of a query
Execute
Show
Run
Results
