Top 550+ Solved Microsoft Access (MS Access) MCQ Questions Answer
Q. In relational database schema each tuple is divided into fields known as?
a. Relations
b. Queries
c. Records
d. Domains
Q. Which of the following columns does not exist in macro design window?
a. Arguments
b. Comments
c. Conditions
d. Actions
Q. What is the type of query that extracts data from a table and puts them into separate table?
a. Parameter query
b. Make table query
c. Update query
d. Put table query
Q. What type of control in a form can display data from database table?
a. Bound control
b. Unbound control
c. Both of above
d. None of above
Q. To display value from table for a label control
a. Set teh control source and record source prom property panel
b. Choose the databse, table, field and select data value to display
c. Look at the table and type value in the caption
d. Set the record source property and then control source
Q. Which of the following is not a section in report design window?
a. Report header section
b. Page header section
c. Summary section
d. Report footer section
Q. You can not import data into access database from
a. Dbase iii database files
b. Excel spreadsheets
c. Comma delimited text files
d. None of the above
Q. Which control does access use to link data access page components to Access data?
a. Microsoft dynamic data control
b. Microsoft data connection control
c. Microsoft office data source control
d. None of the above
Q. which program do you use to edit code for data access pages?
a. Microsoft script editor
b. Microsoft code editor
c. Microsoft data access pages editor
d. None of above
Q. the way a particular application views the data from the database that the applicaton uses is a
a. Module
b. Relational model
c. Schema
d. Sub-schema
Q. which of the following is a database management system?
a. Ms-word
b. Lotus 1-2-3
c. Oracle
d. None of above
Q. what is the corresponding text for the <#1/1/95# validation rule setting?
a. Neter a value less or more than 1,195
b. Value must be less than 95 characters
c. Enter a date before 1995
d. All of above
Q. what is the name of the visual basic editor utility that allows you to view the Microsoft Access type library’s available objects and members?
a. Object viewer
b. Object browser
c. Type library spy
d. None of above
Q. a computer language for informing the dbms regarding the data structure used is
a. Pascal
b. Ddl
c. Prolog
d. Fortran