Top 550+ Solved Microsoft Access (MS Access) MCQ Questions Answer
Q. What is the difference between ‘open’ and ‘open exclusively’
a. Open statement opens access database files and open exclusively opens database files of other program like oracle
b. Open exclusive locks whole database so that no one can access it whereas open locks only the record that is being accessed
c. Both open and open exclusively are same
d. Open exclusive command does not exist in MS Access
Q. After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?
a. You need to delete the whole table. There is no method to remove a particular field only.
b. Delete all the fields from third downwards and reenter the required fields again.
c. Select the third column in datasheet view then delete
d. Select the third row in table design view then delete
Q. Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find relationship command
a. File menu
b. View menu
c. Database menu
d. Tools menu
Q. What do you mean by one to many relationship between student and class table?
a. One student can have many classes
b. One class may have many student
c. Many classes may have many students
d. Many students may have manu classes
Q. Referential integrity means
a. Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table
b. Do not enter a value in the primary key field of chield table if that value does not exist in the primary key of the parent table
c. Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child table
d. All of above
Q. Cascade delete option
a. Is used to delete all the records of all tables in a database
b. Will repeat the recent delete operation to all the records of current table
c. Is available in edit relatiionship dialog box which makes sure that all the related records will be deleted automatically whn the record from parent table is deleted
d. None of above
Q. When a picture or other graphic image is placed in the report header section it will appear____
a. Once in the bugging of the report
b. At the top of every page
c. Every after record break
d. On the 1st and last pages of the report
Q. Which of the following database object is created first before any other created?
a. Table
b. Form
c. Report
d. Query
Q. This type of database contains multiple tables that are connected to produce combined output from all tables.
a. Bound
b. Linked
c. Relational
d. Joined
Q. The ‘filter by selection’ allows you to filter those records
a. That match the selected field
b. That match the criteria specified
c. That meet any of several criteria specified
d. All of above
Q. The operation of checking input data against specified criteria is known as?
a. Data verification
b. Data validation
c. Cross check
d. Data control
Q. Some rules are set in databases to check and permit only correct values. What is this feature called?
a. Data verification
b. Auditing
c. Data filtering
d. Data validation
Q. Database access levels are specified so as to define who can access what in a database. It is identified through
a. User id
b. Password
c. Status
d. None of above
Q. What it is called to present information in a particular order based on numeric or alphabetical value?
a. Sorting
b. Searching
c. Arranging
d. Cropping
Q. A collection of related records in database is known as a
a. Table
b. Database
c. File
d. None of above