A search value can be an exact value or it can be
Wild card character
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of Microsoft Access MCQ
comments powered by Disqus.
A __ name must be unique within a database
When creating a new table which method can be used to choose fields from standard databases and tables
A database language concerned with the definition of the whole database structure and schema is ________
Which of the following can be an example of a database?
Which field type can store photos?
It is an association established between common fields of two tables.
To create a new table, in which method you dont need to specify the field type and size?
To create primary key for a table when in design view
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.
This key uniquely identifies each record
Queries in Access can be used as
Which of the following creates a drop down list of values to choose from a list?
We can remove a relationship defined between two tables by
What does the show check box in query design window indicate
Which of the following statement is true?
Each record is constituted by a number of individual data items which are called
To achieve AND effect when you are entering criteria in a query design window
What is the maximum length a text field can be?
When entering field name, how many characters you can type in maximum?
The size of a field with Number data type can not be
A composite key is
Which of the following database object hold data?
In a database table, the category of information is called ____________
The command center of access file that appears when you create or open the MS Access database file.
If you write criteria values vertically (one in a row) it will mean
Which is not a view to display a table in Access?
After entering all fields required for a table, if you realize that the third field is not needed, how…
Referential integrity means
Every table in relational database contain a field or combination of fields that can uniquely identify…
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter