A primary key in any table has the properties
Both of above
None of above
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of Microsoft Access MCQ
comments powered by Disqus.
What is the maximum length a text field can be?
Which is not a view to display a table in Access?
What does the show check box in query design window indicate
The complete information about an entity in a database is called
What do you mean by one to many relationship between Student and Class table?
Both conditions display on the same row in the design grid when ___operator is in use
When creating a new table which method can be used to choose fields from standard databases and tables
What are the columns in a Microsoft Access table called?
It is an association established between common fields of two tables.
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?
An Access database object that is used to enter, view or edit records
A database object in MS Access that stores a question about the data in database?
Two tables can be linked with relationship so that the data integrity can be enforced. Where can you…
A search value can be an exact value or it can be
Which of the following database object produces the final result to present?
To create queries in Access
It is most common type of query. It retrieves records from one or more tables and then displays the
You can automatically include all of the field in a table in a query by___ a strike that appear list…
If you write criteria values vertically (one in a row) it will mean
Which of the following database object hold data?
Queries in Access can be used as
Which of the following expresses correct order?
Cascade update option
The key uniquely identifies each record in a table.
It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
It is a query that when run displays its own dialog box prompting you for information, such as
This data type allows alphanumeric characters and special symbols.
A small button with three dots usually displayed at the right of field properties box
A database can be best described as
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter