Which of the following store command to retrieve data from database?
Correct Answer :
Download Objective type questions of
Visit our PDF store
Get all objective type questions of Microsoft Access MCQ
comments powered by Disqus.
If you need to edit a relationship
The command center of access file that appears when you create or open the MS Access database file.
A __ name must be unique within a database
A small button with three dots usually displayed at the right of field properties box
The third stage in designing a database is when we analyze our tables more closely and create a ___________…
To sort records in a table
Unlike text data type, this can store up to maximum of 65, 535 characters.
Which of the field has width 8 bytes?
The___ operator will cause a record to be selected only if two or more conditions are satisfied
Which of the following expresses correct order?
If you write criteria values vertically (one in a row) it will mean
What do you mean by one to many relationship between Student and Class table?
It is most common type of query. It retrieves records from one or more tables and then displays the
Database Management Systems are featured with:
What does the show check box in query design window indicate
When creating a new table which method can be used to choose fields from standard databases and tables
To create primary key for a table when in design view
It is a query that when run displays its own dialog box prompting you for information, such as
We can remove a relationship defined between two tables by
A part of database that stores only one type of data is
What are the columns in a Microsoft Access table called?
The size of Yes No field is always
Cascade update option
A composite key is
After entering all fields required for a table, if you realize that the third field is not needed, how…
Which of the following can be an example of a database?
DCL provides commands to perform actions like
If I create Student field in Fees table to store student_id of Students table, then this Student field…
This is the stage in database design where one gathers and lists all the necessary fields for the database…
A search value can be an exact value or it can be
Join our Chat Group
Join our Twitter Group
Join our Pinterest Group
Join our Facebook Group
Subscribe to our Email Newsletter