MS Access MCQ Questions Part 3 Computer MCQs: multiple choice questions and answers,Mock Tests and Practice Papers

Question:

  What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?

1.display all customers with CustID from 10 to 100

2.display all customers with CustID above 10

3.display all customers with CustID below 100

4.display all customers with CustID from 11 to 99

Posted Date:-2021-02-19 07:57:20

Question:

 How to make a date field DOB store the dates like “2002/10/17” ?

1.By setting the input mask property to “yyyy/mm/dd”

2.By setting the format property to “yyyy/mm/dd”

3.By entering dates in yyyy, mm, dd order

4.none of the above

Posted Date:-2021-02-19 07:57:20

Question:

 In a datasheet, what does each column represent?

1.Record

2.Field

3.Database

4.Table

Posted Date:-2021-02-19 07:57:20

Question:

 In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?

1. zipcode, firstname, lastname

2.firstname, lastname, zipcode

3.zipcode, lastname, firstname

4. can’t sort by multiple fields

Posted Date:-2021-02-19 07:57:20

Question:

 What is an intersection of a row and a column?

1.Form

2.Cursor

3.Cell

4.Record

Posted Date:-2021-02-19 07:57:20

Question:

 Which criteria do not return the position “Officer” as a match?

1.position = “*ff*”

2.position = “O??icer”

3.position = ” ?ff*”

4.position = “O#r”

Posted Date:-2021-02-19 07:57:20

Question:

 Which is the valid data type in Access?

1.Number

2.Text

3.Currency

4.All of the above

Posted Date:-2021-02-19 07:57:20

Question:

 Which leads you through the process of creating a table?

1.wizard

2.assistant

3.relation

4.coach

Posted Date:-2021-02-19 07:57:20

Question:

 Which object is used to create a form?

1.Tables and Queries

2.Tables only

3.Tables and reports

4. Queries and reports

Posted Date:-2021-02-19 07:57:20

Question:

 Which of the following is not a database application?

1.dBase

2.Flash

3.FoxPro

4.Access

Posted Date:-2021-02-19 07:57:20

Question:

 Which of the following is not an action query?

1.add

2.delete

3.make-table

4.update

Posted Date:-2021-02-19 07:57:20

Question:

 Which tool do you use to create a query object?

1.Database wizard

2.Simple filter wizard

3.Simple query wizard

4.Table query wizard

Posted Date:-2021-02-19 07:57:20

Question:

 You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?

1.By setting required to ‘Yes’

2.By using default value

3.By defining validation rule

4. By using forma

Posted Date:-2021-02-19 07:57:20

Question:

A ________ is a unit of information in a ________

1.record, field

2. field, record

3.data source, field

4.record, data source

Posted Date:-2021-02-19 07:57:20

Question:

After right click the field selector button, which do you choose to delete a field in design view?

1.Delete field

2.delete rows

3.remove field

4.remove rows

Posted Date:-2021-02-19 07:57:20

Question:

How many relations may exist between tables in databases?

1.4

2.3

3.2

4.1

Posted Date:-2021-02-19 07:57:20

Question:

HSAM stands for ________

1.Hierarchic Sequential Access Method

2.Hierarchic Standard Access Method

3.Hierarchic Sequential and Method

4.Hierarchic Standard and Method

Posted Date:-2021-02-19 07:57:20

Question:

 An organized collection of logically related data is known as

1.Data

2.Meta data

3.Database

4.Information

Posted Date:-2021-02-19 07:57:20

Question:

In a datasheet, what does each row represent?

1.Record

2.Field

3.Database

4.Table

Posted Date:-2021-02-19 07:57:20

Question:

In an application created using the database wizard, the main menu is presented as a

1.form, called a switchboard

2.report, called a menu

3.table, called a switchboard

4. query, called a menu

Posted Date:-2021-02-19 07:57:20

Question:

In databases, Locking level is also called as

1.Granularity

2. S lock

3.X lock

4.Dead lock

Posted Date:-2021-02-19 07:57:20

Question:

In MS Access, Text Data type may contain maximum character of

1.255Character

2.256 Character

3.1064 Character

4.No Limit

Posted Date:-2021-02-19 07:57:20

Question:

In the datasheet formatting dialogue box, which is not an option in the border and line styles dropdown list box?

1.datasheet border

2.datasheet underline

3. Column Header underline

4.vertical gridline

Posted Date:-2021-02-19 07:57:20

Question:

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?

1.Referential integrity is enforced

2.Referential integrity isn’t enforced

3.An inner join is set

4.An outer join is set

Posted Date:-2021-02-19 07:57:20

Question:

The basic elements of a form or a report are called

1.Controls

2.Objects

3.Windows

4.Properties

Posted Date:-2021-02-19 07:57:20

Question:

The report footer section is most useful for displaying

1.grand totals

2.Column headings

3.subtotals

4.page numbers

Posted Date:-2021-02-19 07:57:20

Question:

What do you call a collection of records matching parameters of a query?

1.Field

2.Record

3.Query

4.Dynaset

Posted Date:-2021-02-19 07:57:20

Question:

What do you call a primary key field included in another table?

1.Foreign key

2. Parent key

3.Child key

4.Index

Posted Date:-2021-02-19 07:57:20

Question:

What do you call the process of restricting the display of records in a table to those matching a particular criterion?

1.filtering

2.restricting

3.sorting

4.sifting

Posted Date:-2021-02-19 07:57:20

Question:

What does the expression [detail] ! [product] * 1.30 do?

1.multiplies the contents of detail and product fields by 1.3

2.First divides detail by product and then multiplies by 1.3

3. multiplies the contents of detail in the product table by 1.3

4.multiplies the contents of product in the detail table by 1.3

Posted Date:-2021-02-19 07:57:20

Question:

What is the full form of SQL?

1.Sophisticated Question List

2.Structured Question List

3.Structured Query Language

4.Small Query Length

Posted Date:-2021-02-19 07:57:20

Question:

What is the purpose of indexing?

1.To reduce table size

2. To speedup data search

3.both A and B

4.none of the above

Posted Date:-2021-02-19 07:57:20

Question:

Which control type do you use to create a calculated control?

1.command button

2.combo box

3. text box

4.list box

Posted Date:-2021-02-19 07:57:20

Question:

Which control types is most often associated with a bound control?

1. command button

2.label

3. text box

4.list box

Posted Date:-2021-02-19 07:57:20

Question:

Which criteria return only those addresses beginning with the letter “K”?

1.address = “K”

2. address = “K*”

3.address = “K?”

4.address = “K#”

Posted Date:-2021-02-19 07:57:20

Question:

Which data type is better to use for storing phone number in the following format “977-1-1234567”?

1.Text

2.AutoNumber

3.Number

4.Currency

Posted Date:-2021-02-19 07:57:20

Question:

Which data type is better to use for storing the price of an item?

1.Text

2.AutoNumber

3.Number

4.Currency

Posted Date:-2021-02-19 07:57:20

Question:

Which do you click to display the table’s primary key and indexes in a separate window?

1.indexes button

2.primary key button

3.view datasheet button

4.view design button

Posted Date:-2021-02-19 07:57:20

Question:

Which function can not be used for calculated controls in a report?

1.SUM

2.AVG

3.MPT

4.COUNT

Posted Date:-2021-02-19 07:57:20

Question:

Which is not a command that is selectable from right click menu of a field column?

1.Hide columns

2.Rename columns

3.freeze columns

4.sort descending

Posted Date:-2021-02-19 07:57:20

Question:

Which is not a view for displaying a report object?

1.Datasheet view

2.Design view

3.Print preview

4.Layout preview

Posted Date:-2021-02-19 07:57:20

Question:

Which is not an option for customizing a datasheet window?

1.change one row’s height

2.hide one column

3.change one column’s width

4.freeze one column

Posted Date:-2021-02-19 07:57:20

Question:

Which of the following is not a legitimate section for form objects?

1.Form detail

2.Group header

3.Form header

4.Page footer

Posted Date:-2021-02-19 07:57:20

Question:

Which of the following is not a logical database structure?

1.Chain

2.Network

3.Tree

4.Relational

Posted Date:-2021-02-19 07:57:20

Question:

Which of the following is not a view for interacting with a form object?

1.Datasheet view

2.Design view

3.Form view

4.Layout view

Posted Date:-2021-02-19 07:57:20

Question:

Which query do you use to answer the question “What is the average salary of the employees”?

1.Search query

2.Cross tab query

3.Select query

4.Update query

Posted Date:-2021-02-19 07:57:20

Question:

Which query do you use to answer the question “Which employees earn more than $5000 a month?

1.Search query

2.Cross tab query

3.Select query

4. Update query

Posted Date:-2021-02-19 07:57:20

Question:

Which setting you must modify to print a report using letterhead?

1.Group

2.Margin

3.Section

4.Orientation

Posted Date:-2021-02-19 07:57:20

Question:

Which tool is used to generate printout of a table’s structure?

1.Analyzer

2.Designer

3.Documenter

4.Generator

Posted Date:-2021-02-19 07:57:20

Question:

Which type of field is incremented automatically?

1.Auto Elevate

2.AutoNumber

3. Auto Increment

4.Auto Value

Posted Date:-2021-02-19 07:57:20

Posted on by R4R Team

Computer/MS Access MCQ Questions Part 3 Sample Test,Sample questions

Question: What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?

Question: How to make a date field DOB store the dates like “2002/10/17” ?

Question: In a datasheet, what does each column represent?

Question: In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?

Question: What is an intersection of a row and a column?

Question: Which criteria do not return the position “Officer” as a match?

Question: Which is the valid data type in Access?

Question: Which leads you through the process of creating a table?

Question: Which object is used to create a form?

Question: Which of the following is not a database application?

Question: Which of the following is not an action query?

Question: Which tool do you use to create a query object?

Question: You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?

Question: A ________ is a unit of information in a ________

Question: After right click the field selector button, which do you choose to delete a field in design view?

Question: How many relations may exist between tables in databases?

Question: HSAM stands for ________

Question: ﻿ An organized collection of logically related data is known as

Question: In a datasheet, what does each row represent?

Question: In an application created using the database wizard, the main menu is presented as a

Question: In databases, Locking level is also called as

Question: In MS Access, Text Data type may contain maximum character of

Question: In the datasheet formatting dialogue box, which is not an option in the border and line styles dropdown list box?

Question: 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?

Question: The basic elements of a form or a report are called

Question: The report footer section is most useful for displaying

Question: What do you call a collection of records matching parameters of a query?

Question: What do you call a primary key field included in another table?

Question: What do you call the process of restricting the display of records in a table to those matching a particular criterion?

Question: What does the expression [detail] ! [product] * 1.30 do?

Question: What is the full form of SQL?

Question: What is the purpose of indexing?

Question: Which control type do you use to create a calculated control?

Question: Which control types is most often associated with a bound control?

Question: Which criteria return only those addresses beginning with the letter “K”?

Question: Which data type is better to use for storing phone number in the following format “977-1-1234567”?

Question: Which data type is better to use for storing the price of an item?

Question: Which do you click to display the table’s primary key and indexes in a separate window?

Question: Which function can not be used for calculated controls in a report?

Question: Which is not a command that is selectable from right click menu of a field column?

Question: Which is not a view for displaying a report object?

Question: Which is not an option for customizing a datasheet window?

Question: Which of the following is not a legitimate section for form objects?

Question: Which of the following is not a logical database structure?

Question: Which of the following is not a view for interacting with a form object?

Question: Which query do you use to answer the question “What is the average salary of the employees”?

Question: Which query do you use to answer the question “Which employees earn more than $5000 a month?

Question: Which setting you must modify to print a report using letterhead?

Question: Which tool is used to generate printout of a table’s structure?

Question: Which type of field is incremented automatically?

More MCQS

Search

R4R Team

Question:
What is the result of ‘Select * from customer where CustID>10 and CustID<100’ query?

Question:
How to make a date field DOB store the dates like “2002/10/17” ?

Question:
In a datasheet, what does each column represent?

Question:
In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?

Question:
What is an intersection of a row and a column?

Question:
Which criteria do not return the position “Officer” as a match?

Question:
Which is the valid data type in Access?

Question:
Which leads you through the process of creating a table?

Question:
Which object is used to create a form?

Question:
Which of the following is not a database application?

Question:
Which of the following is not an action query?

Question:
Which tool do you use to create a query object?

Question:
You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?

Question:
A is a unit of information in a

Question:
After right click the field selector button, which do you choose to delete a field in design view?

Question:
How many relations may exist between tables in databases?

Question:
HSAM stands for ________

Question:
An organized collection of logically related data is known as

Question:
In a datasheet, what does each row represent?

Question:
In an application created using the database wizard, the main menu is presented as a

Question:
In databases, Locking level is also called as

Question:
In MS Access, Text Data type may contain maximum character of

Question:
In the datasheet formatting dialogue box, which is not an option in the border and line styles dropdown list box?

Question:
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?

Question:
The basic elements of a form or a report are called

Question:
The report footer section is most useful for displaying

Question:
What do you call a collection of records matching parameters of a query?

Question:
What do you call a primary key field included in another table?

Question:
What do you call the process of restricting the display of records in a table to those matching a particular criterion?

Question:
What does the expression [detail] ! [product] * 1.30 do?

Question:
What is the full form of SQL?

Question:
What is the purpose of indexing?

Question:
Which control type do you use to create a calculated control?

Question:
Which control types is most often associated with a bound control?

Question:
Which criteria return only those addresses beginning with the letter “K”?

Question:
Which data type is better to use for storing phone number in the following format “977-1-1234567”?

Question:
Which data type is better to use for storing the price of an item?

Question:
Which do you click to display the table’s primary key and indexes in a separate window?

Question:
Which function can not be used for calculated controls in a report?

Question:
Which is not a command that is selectable from right click menu of a field column?

Question:
Which is not a view for displaying a report object?

Question:
Which is not an option for customizing a datasheet window?

Question:
Which of the following is not a legitimate section for form objects?

Question:
Which of the following is not a logical database structure?

Question:
Which of the following is not a view for interacting with a form object?

Question:
Which query do you use to answer the question “What is the average salary of the employees”?

Question:
Which query do you use to answer the question “Which employees earn more than $5000 a month?

Question:
Which setting you must modify to print a report using letterhead?

Question:
Which tool is used to generate printout of a table’s structure?

Question:
Which type of field is incremented automatically?