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.
Which field type can store photos?
When creating a new table which method can be used to choose fields from standard databases and tables
Query design window has two parts. The upper part shows
Unlike text data type, this can store up to maximum of 65, 535 characters.
What happens when you release mouse pointer after you drop the primary key of a table into foreign key…
Which of the following is not a type of relationship that can be applied in Access database
To achieve AND effect when you are entering criteria in a query design window
It is most common type of query. It retrieves records from one or more tables and then displays the
The___ operator will cause a record to be selected only if two or more conditions are satisfied
To create a new table, in which method you dont need to specify the field type and size?
In one-to-many relationship the table in one side is called _______ and on many side is called _______
A part of database that stores only one type of data is
DCL provides commands to perform actions like
A small button with three dots usually displayed at the right of field properties box
To create primary key for a table when in design view
Which field type will you select when creating a new table if you require to enter long text in that…
Which of the following store command to retrieve data from database?
Which of the field has width 8 bytes?
After entering all fields required for a table, if you realize that the third field is not needed, how…
To create relationship between two tables
Microsoft Access is a
A primary key in any table has the properties
Which is not a view to display a table in Access?
The database language that allows you to access or maintain data in a database
When entering field name, how many characters you can type in maximum?
If you write criteria values vertically (one in a row) it will mean
To sort records in a table
The expression builder is an access tool that controls an expression___ for entering an expression
This data type allows alphanumeric characters and special symbols.
Which of the following is NOT a type of Microsoft Access database object?
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter