Category: Database Mcqs

(A) Sort by month name
(B) Sort by month number
(C) Define the field with the data type month and sort Ascending
(D) Define the field with the data type month and sort Descending

(A) Help make the database applications system user-friendly by eliminating the need to remember command languages
(B) Provide security though user-level logins
(C) Control access by providing only those options that allow people to do their jobs
(D) Create an environment that is tailored to specific types of applications and end users

(A) They have more prompting options than dialog boxes generated by Access
(B) They allow the use of combo boxes
(C) Access-generated dialog boxes are likely to disrupt interface layout schemes, while form-based dialog boxes are not
(D) All of the above

(A) A single-source form, based on a tabular format
(B) A single-source form, based on a columnar format
(C) A multi-source form, based on a tabular format
(D) A multi-source form, based on a columnar format

(A) A form is based on exactly one table. The table must exist before the form is created
(B) A form is based on exactly one table. The table may be created before or after the form is created
(C) A form may be based on one or more tables. The table(s) must exist before the form is created
(D) A form may be based on one or more tables. The table(s) may be created before or after the form is created

(A) Forms are used to tie together the database components through menu structures
(B) Forms extend data validation rules through queries, value lists, and other input control devices
(C) Forms are used to enter new data and to edit existing data
(D) Forms program and control user responses

(A) Zero or more of the preceding character
(B) Any one character in the position held by the ?
(C) Multiple characters in the position held by the ?
(D) Any letter in the position held by the ?

(A) Month: Format([EMP_DOB],”m”)
(B) Month: Format([EMP_DOB],”mm”)
(C) Month: Format([EMP_DOB],”mmm”)
(D) Month: Format([EMP_DOB],”mmmm”)