Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of Microsoft Access MCQ
comments powered by Disqus.
It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
Which of the following statement is true
DCL provides commands to perform actions like
In table design view, which key can be used to switch between the field names and properties panels?
The command center of access file that appears when you create or open the MS Access database file.
To create relationship between two tables
When creating a new table which method can be used to choose fields from standard databases and tables
Every table in relational database contain a field or combination of fields that can uniquely identify…
A search value can be an exact value or it can be
Which of the following database object hold data?
A __ name must be unique within a database
If you write criteria values vertically (one in a row) it will mean
A __________ enables you to view data from a table based on a specific criterion
This data type allows alphanumeric characters and special symbols.
If I create Student field in Fees table to store student_id of Students table, then this Student field…
What is the maximum length a text field can be?
Queries in Access can be used as
What do you mean by one to many relationship between Student and Class table?
The complete information about an entity in a database is called
Which of the following is not a type of relationship that can be applied in Access database
Which of the following is not a field type in Access
It is a database object to view, change, and analyze data in different ways
When entering field name, how many characters you can type in maximum?
A small button with three dots usually displayed at the right of field properties box
It is most common type of query. It retrieves records from one or more tables and then displays the
Cascade update option
To sort records in a table
The___ operator will cause a record to be selected only if two or more conditions are satisfied
A primary key in any table has the properties
After entering all fields required for a table, if you realize that the third field is not needed, how…
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter