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.
In a database table, the category of information is called ____________
Which field type can store photos?
A search value can be an exact value or it can be
What is the difference between Open and Open Exclusively?
When creating a new table which method can be used to choose fields from standard databases and tables
Database Management Systems are featured with:
If you write criteria values vertically (one in a row) it will mean
In table design view, which key can be used to switch between the field names and properties panels?
DCL provides commands to perform actions like
What are the columns in a Microsoft Access table called?
In one-to-many relationship the table in one side is called _______ and on many side is called _______
How can you link a table with another so that a field in current table will display values in drop down…
To create queries in Access
Unlike text data type, this can store up to maximum of 65, 535 characters.
The size of a field with Number data type can not be
After entering all fields required for a table, if you realize that the third field is not needed, how…
It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
Which of the following expresses correct order?
What do you mean by one to many relationship between Student and Class table?
A __________ enables you to view data from a table based on a specific criterion
To sort records in a table
Queries in Access can be used as
The expression builder is an access tool that controls an expression___ for entering an expression
Collection of related records in a database is known as
This option allows you to build a new table by entering data directly into the datasheet.
A __ name must be unique within a database
This is the stage in database design where one gathers and lists all the necessary fields for the database…
If I create Student field in Fees table to store student_id of Students table, then this Student field…
The two form layout types will display multiple records at one time are tabular and___
To create primary key for a table when in design view
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter