It is a query that when run displays its own dialog box prompting you for information, such as
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of Microsoft Access MCQ
comments powered by Disqus.
To create queries in Access
What do you mean by one to many relationship between Student and Class table?
Which field type will you select when creating a new table if you require to enter long text in that…
Every table in relational database contain a field or combination of fields that can uniquely identify…
The command center of access file that appears when you create or open the MS Access database file.
A composite key is
It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
Which of the following is a method to create a new table in MS Access?
After entering all fields required for a table, if you realize that the third field is not needed, how…
If you need to edit a relationship
To achieve AND effect when you are entering criteria in a query design window
The__ button on the tool box display data from a related table
A __________ enables you to view data from a table based on a specific criterion
Database Management Systems are featured with:
It is a sign or symbol that specifies, operator, and values that produce a result
An Access database object that is used to enter, view or edit records
This option allows you to build a new table by entering data directly into the datasheet.
Queries in Access can be used as
Which of the following is not a database object?
In one-to-many relationship the table in one side is called _______ and on many side is called _______
Unlike text data type, this can store up to maximum of 65, 535 characters.
In a database table, the category of information is called ____________
The complete information about an entity in a database is called
If you write criteria values vertically (one in a row) it will mean
We can remove a relationship defined between two tables by
Cascade update option
Which of the following is not a type of relationship that can be applied in Access database
Both conditions display on the same row in the design grid when ___operator is in use
In table design view what are the first column of buttons used for
A search value can be an exact value or it can be
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter