Ms Access — Part 2 MCQs with Explanations

Relationships is the correct answer to “Which of the following is not a database object”. This question is standard in competitive examination syllabi for Ms Access.

SHIFT+F4 is the correct answer to “In Access to find the next occurrence of the text specified in the Find and Replace dialog box when the dialog box is closed (Datasheet view and Form view only)”. This question is standard in competitive examination syllabi for Ms Access.

Ddl is the correct answer to “a computer language for informing the dbms regarding the data structure used is”. This question is standard in competitive examination syllabi for Ms Access.

Data string is the correct answer to “a subset of characters within a data field is known as”. This question is standard in competitive examination syllabi for Ms Access.

events is the correct answer to “Macros can recover from _______ in a controlled manner.”. This question is standard in competitive examination syllabi for Ms Access.

Made up of two or more fields to uniquely identify records is the correct answer to “A composite key is”. This question is standard in competitive examination syllabi for Ms Access.

txt is the correct answer to “According to the Leszynski Naming Conventions, which of the following is the prefix for a text box control”. This question is standard in competitive examination syllabi for Ms Access.

Margin is the correct answer to “Which setting you must modify to print a report using letterhead”. This question is standard in competitive examination syllabi for Ms Access.

Justified is the correct answer to “In this form, a single record may appear in multiple rows in the form window in order to fully display the field name label and data.”. This question is standard in competitive examination syllabi for Ms Access.

Option group frame is the correct answer to “Which of the following components has a property sheet that includes settings for the frame and the option group”. This question is standard in competitive examination syllabi for Ms Access.

Move the selected control up is the correct answer to “In Access press UP ARROW or CTRL+UP ARROW”. This question is standard in competitive examination syllabi for Ms Access.

join line is the correct answer to “In the Relationship window, related fields from each table are connected by a(n) _______________.”. This question is standard in competitive examination syllabi for Ms Access.

Parameter is the correct answer to “Which of the following queries prompts users for input data by displaying dialog boxes”. This question is standard in competitive examination syllabi for Ms Access.

Picture is the correct answer to “Which of the following is not a valid Data Type in MS Access”. This question is standard in competitive examination syllabi for Ms Access.

Report is the correct answer to “Which of the following is use to view or print the data in organized manner”. This question is standard in competitive examination syllabi for Ms Access.

Bound is the correct answer to “What type of controls are text boxes when data from the recordset is visible”. This question is standard in competitive examination syllabi for Ms Access.

Foreign key is the correct answer to “If I create 'Student' field in 'Fees' table to store 'student_id' of 'Students' table, then this 'Student' field in 'Fees' table is called:”. This question is standard in competitive examination syllabi for Ms Access.

Form is the correct answer to “Which of the following is use to get data from user”. This question is standard in competitive examination syllabi for Ms Access.

It can contain only one object. is the correct answer to “Which of the following statements about a tab control in a form is incorrect”. This question is standard in competitive examination syllabi for Ms Access.

Between is the correct answer to “In a query, using the keyword _______________ will return records in which the field value is between two numbers.”. This question is standard in competitive examination syllabi for Ms Access.

Referential integrity is enforced is the correct answer to “In the relationships window, what does the appearance of symbols, such as 1 and the infinity symbol, at the endpoints of a relationship line mean”. This question is standard in competitive examination syllabi for Ms Access.

To describe the data that should be entered in each field is the correct answer to “What is the purpose of the description column in Table Design View”. This question is standard in competitive examination syllabi for Ms Access.

OLE is the correct answer to “Which field type can store photos”. This question is standard in competitive examination syllabi for Ms Access.

Calculated field is the correct answer to “In access, this displays the results of a calculation in a query”. This question is standard in competitive examination syllabi for Ms Access.

At least one field is the correct answer to “If you are creating a cross tab query, what must table you are querying contain”. This question is standard in competitive examination syllabi for Ms Access.

Bound control is the correct answer to “What type of control in a form can display data from database table”. This question is standard in competitive examination syllabi for Ms Access.

Memo is the correct answer to “Which field type will you select when creating a new table if you require to enter long text in that field”. This question is standard in competitive examination syllabi for Ms Access.

Picture/graphic is the correct answer to “which of the following is not a data type”. This question is standard in competitive examination syllabi for Ms Access.

Stretch is the correct answer to “When adding an image, which size mode will change the height or width of the image fit the control”. This question is standard in competitive examination syllabi for Ms Access.

procedure is the correct answer to “In a module, a(n) _______ is a series of commands and properties that perform a specific task.”. This question is standard in competitive examination syllabi for Ms Access.

Module1 is the correct answer to “By default, what is the name of a new module in the Modules folder of the Project pane called”. This question is standard in competitive examination syllabi for Ms Access.

Click the Show Table button on the toolbar is the correct answer to “You add a table to the query design window”. This question is standard in competitive examination syllabi for Ms Access.

24 is the correct answer to “You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have”. This question is standard in competitive examination syllabi for Ms Access.

Form Header is the correct answer to “You have a Command button in the Form Footer, you click the Tabular Control Layout; an attached label will be added in what section”. This question is standard in competitive examination syllabi for Ms Access.

All of the Above is the correct answer to “In MS Access, Field Value may contain”. This question is standard in competitive examination syllabi for Ms Access.

By setting the format property to "yyyy/mm/dd" is the correct answer to “How to make a date field DOB store the dates like "2002/10/17"”. This question is standard in competitive examination syllabi for Ms Access.

ALT+B is the correct answer to “In Access press to Move to the previous page of the wizard”. This question is standard in competitive examination syllabi for Ms Access.

Data validation is the correct answer to “The operation of checking input data against specified criteria is known as”. This question is standard in competitive examination syllabi for Ms Access.

macro is the correct answer to “A(n)_______ is a major object that can run independent of a control.”. This question is standard in competitive examination syllabi for Ms Access.

A conditional expression is the correct answer to “(IF [Age]>65, "Senior","Adult") This expression is an example of:”. This question is standard in competitive examination syllabi for Ms Access.