MS Access MCQ Questions Part 7 | Computer | Learn & Give Online MCQS Test ,MCQs: multiple choice questions and answers,Mock Tests and Practice Papers

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

Question:

 A __________ enables you to view data from a table based on a specific criterion

1.Form

2.Query

3.Macro

4.Reports

Question:

 Microsoft Access is a

1.Rdbms

2.Oodbms

3.Ordbms

4.Network database model

Question:

 SQL stands for __________.

1.Standard Query Language

2.Structured Query Language

3. Simplified Query Language

4.Static Query Language

Question:

 The ability of a database to grow as the data tracking needs grow is its __________.

1.scalability

2.expandability

3.maintainability

4.platform-independence

Question:

 The database language that allows you to access or maintain data in a database

1.Dcl

2.Dml

3.Ddl

4.None of above

Question:

 The __________ field is used to hold a yes or no answer.

1.object

2.number

3.text

4.logical

Question:

 The __________ is the software tool to store or access data.

1.table

2.DBMS

3.query

4.report

Question:

 The __________ is used to access one record at a time.

1.query

2.filter

3.form

4.report

Question:

 Which of the following database object produces the final result to present?

1.Forms

2.Reports

3.Queries

4.Tables

Question:

 Which of the following methods CANNOT be used to delete records from a table?

1.Selecting records and pressing [Delete]

2.Pressing [Ctrl]+[â€™]

3.Clicking the Delete Record button

4.From the ribbon selecting Delete Record

Question:

A DBMS that runs on many different operating systems is said to be __________.

1.scalable

2.robust

3.platform independent

4.distributed

Question:

A(n) ____ in the Record Selector indicates a new record.

1.check mark

2.pencil

3.asterisk

4.arrow

Question:

All attachment fields display as a(n) ____ in Datasheet View.

1.icon

2.button

3.thumb tack

4.paperclip

Question:

An application that executes on separate PCs like this is called a(n) __________ application.

1.enterprise

2.distributed

3.tier

4.global

Question:

An enterprise solution with data storage a client interface and a security system is a(n) __________ system.

1.2-tier

2.3-tier

3.4-tier

4.n-tier

Question:

Dcl provides commands to perform actions like

1.Change the structure of tables

2.Insert update or delete records and data values

3.Authorizing access and other control over database

4.None of above

Question:

Following is not a database model

1.Network database model

2.Relational database model

3.Object oriented database model

4.None

Question:

In a database table the category of information is called __________

1.Tuple

2. Field

3.Record

4. All of above

Question:

In table design view which key can be used to switch between the field names and properties panels?

1.F3

2.F4

3.F5

4.F6

Question:

It is an association established between common

1.Line

2.Relationship

3.Primary key

4.Records

Question:

ï»¿ Which of the following methods CANNOT be used to copy a block of text from one part of a table to another?

1.Press Ctrl+C and Ctrl+V

2.Right-click choose from the shortcut menu Copy and Paste.

3.Press [Ctrl]+[+] and [Ctrl]+[-].

4.From the ribbon select Copy and Paste.

Question:

Search engines use a(n) __________ to automatically index sites.

1.crawler

2.query

3.enterprise

4.sitebuilder

Question:

The command center of access file that appears when you create or open the MS Access database file.

1.Database window

2.Query window

3.Design view window

4. Switchboard

Question:

The default and maximum size of text field in access

1.50 and 255 characters

2.8 and 1 gb

3.266 characters & 64000 characters

4.None of above

Question:

The most open source DBMS.

1.Microsoft SQL Server

2.Microsoft Access

3.MySQL

4.Oracle

Question:

The most popular commercial DBMS.

1.Microsoft SQL Server

2.Microsoft Access

3.MySQL

4.Oracle

Question:

The __________ performs document tracking.

1.distributed application

2.enterprise software

3.Oracle software

4.EDM software

Question:

This database has only one table.

1.relational

2.large

3.flat-file

4.DBMS

Question:

This is the stage in database design where one gathers and list all the necessary fields for the database project.

1.Data definition

2.Data refinement

3.Establishing relationship

4.None of the above

Question:

To delete records or perform calculations on a table the best tool to use is a __________.

1.query

2.filter

3.form

4.report

Question:

To print information from a table the __________ tool is the best choice.

1.form

2.report

3.query

4.macro

Question:

To store your picture in a database requires a(n) __________ field.

1.BLOB

2.text

3.image

4.logical

Question:

What are the columns in a Microsoft Access table called?

1.Rows

2.Records

3.Fields

4.Columns

Question:

What are the different views to display a table

1.Datasheet view

2. Design view

3.Pivote table & pivot chart view

4.All of above

Question:

What is the difference between â€˜openâ€™ and â€˜open exclusivelyâ€™

1.Open statement opens access database files and open exclusively opens database files of other program like oracle

2.Open exclusive locks whole database so that no one can access it whereas open locks only the record that is being accessed

3.Both open and open exclusively are same

4. Open exclusive command does not exist in MS Access

Question:

What is the maximum length a text field can be?

1.120

2.255

3.165

4.75

Question:

Where can you find the undo command in Access?

1.Office button

2. Home command tab

3.Status bar

4.Quick Access toolbar

Question:

Which of the field has width 8 bytes?

1.Memo

2.Number

3.Date/time

4.Hyperlink

Question:

Which of the following creates a drop down list of values to choose from?

1.Ole object

2.Hyperlink

3.Memo

4.Lookup wizard

Question:

Which of the following database object hold data?

1.Forms

2.Reports

3.Queries

4.Tables

Question:

Which of the following is a method to create a new table in MS Access?

1.Create table in design view

2. Create table using wizard

3.Create table by entering data

4.All of above

Question:

which of the following is not a database object?

1.Tables

2.Queries

3.Relationships

4.Reports

Question:

Which of the following is not a type of Microsoft Access database object?

1.Table

2.Form

3.Worksheets

4.Modules

Question:

Which of the following statement is true?

1.Foreign key fields donâ€™t allow duplicate values

2. In primary key field you can enter duplicate value

3. In an indexed field you may or may not enter duplicate value depending upon setting

4.All statements are true

Question:

Which of the following store command to retrieve data from database?

1.Forms

2.Reports

3.Queries

4.Tables

Question:

_______ are documents that when filled in create records.

1.Forms

2.Reports

3.Tables

4.Queries

Question:

_______ is the clear leader for personal databases.

1.Microsoft Access

2.Microsoft FoxPro

3.Borland dBase

4.MySQL

Question:

________ is used to build â€˜intuitiveâ€™ queries

1.SQL

2.Xbase

3.QBE

4.XML

Question:

_________ will answer questions you did not think to ask of your data.

1.data mining

2.data extrapolation

3.knowledge discovery

4.data enlightenment

Posted on by Online Exam TestTeam

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

Question: A __________ enables you to view data from a table based on a specific criterion

Question: Microsoft Access is a

Question: SQL stands for __________.

Question: The ability of a database to grow as the data tracking needs grow is its __________.

Question: The database language that allows you to access or maintain data in a database

Question: The __________ field is used to hold a yes or no answer.

Question: The __________ is the software tool to store or access data.

Question: The __________ is used to access one record at a time.

Question: Which of the following database object produces the final result to present?

Question: Which of the following methods CANNOT be used to delete records from a table?

Question: A DBMS that runs on many different operating systems is said to be __________.

Question: A(n) ____ in the Record Selector indicates a new record.

Question: All attachment fields display as a(n) ____ in Datasheet View.

Question: An application that executes on separate PCs like this is called a(n) __________ application.

Question: An enterprise solution with data storage a client interface and a security system is a(n) __________ system.

Question: Dcl provides commands to perform actions like

Question: Following is not a database model

Question: In a database table the category of information is called __________

Question: In table design view which key can be used to switch between the field names and properties panels?

Question: It is an association established between common

Question: ï»¿ Which of the following methods CANNOT be used to copy a block of text from one part of a table to another?

Question: Search engines use a(n) __________ to automatically index sites.

Question: The command center of access file that appears when you create or open the MS Access database file.

Question: The default and maximum size of text field in access

Question: The most open source DBMS.

Question: The most popular commercial DBMS.

Question: The __________ performs document tracking.

Question: This database has only one table.

Question: This is the stage in database design where one gathers and list all the necessary fields for the database project.

Question: To delete records or perform calculations on a table the best tool to use is a __________.

Question: To print information from a table the __________ tool is the best choice.

Question: To store your picture in a database requires a(n) __________ field.

Question: What are the columns in a Microsoft Access table called?

Question: What are the different views to display a table

Question: What is the difference between â€˜openâ€™ and â€˜open exclusivelyâ€™

Question: What is the maximum length a text field can be?

Question: Where can you find the undo command in Access?

Question: Which of the field has width 8 bytes?

Question: Which of the following creates a drop down list of values to choose from?

Question: Which of the following database object hold data?

Question: Which of the following is a method to create a new table in MS Access?

Question: which of the following is not a database object?

Question: Which of the following is not a type of Microsoft Access database object?

Question: Which of the following statement is true?

Question: Which of the following store command to retrieve data from database?

Question: _______ are documents that when filled in create records.

Question: _______ is the clear leader for personal databases.

Question: ________ is used to build â€˜intuitiveâ€™ queries

Question: _________ will answer questions you did not think to ask of your data.

More MCQS

Search

Olete Team

Question:
A __________ enables you to view data from a table based on a specific criterion

Question:
Microsoft Access is a

Question:
SQL stands for __________.

Question:
The ability of a database to grow as the data tracking needs grow is its __________.

Question:
The database language that allows you to access or maintain data in a database

Question:
The __________ field is used to hold a yes or no answer.

Question:
The __________ is the software tool to store or access data.

Question:
The __________ is used to access one record at a time.

Question:
Which of the following database object produces the final result to present?

Question:
Which of the following methods CANNOT be used to delete records from a table?

Question:
A DBMS that runs on many different operating systems is said to be __________.

Question:
A(n) ____ in the Record Selector indicates a new record.

Question:
All attachment fields display as a(n) ____ in Datasheet View.

Question:
An application that executes on separate PCs like this is called a(n) __________ application.

Question:
An enterprise solution with data storage a client interface and a security system is a(n) __________ system.

Question:
Dcl provides commands to perform actions like

Question:
Following is not a database model

Question:
In a database table the category of information is called __________

Question:
In table design view which key can be used to switch between the field names and properties panels?

Question:
It is an association established between common

Question:
ï»¿ Which of the following methods CANNOT be used to copy a block of text from one part of a table to another?

Question:
Search engines use a(n) __________ to automatically index sites.

Question:
The command center of access file that appears when you create or open the MS Access database file.

Question:
The default and maximum size of text field in access

Question:
The most open source DBMS.

Question:
The most popular commercial DBMS.

Question:
The __________ performs document tracking.

Question:
This database has only one table.

Question:
This is the stage in database design where one gathers and list all the necessary fields for the database project.

Question:
To delete records or perform calculations on a table the best tool to use is a __________.

Question:
To print information from a table the __________ tool is the best choice.

Question:
To store your picture in a database requires a(n) __________ field.

Question:
What are the columns in a Microsoft Access table called?

Question:
What are the different views to display a table

Question:
What is the difference between â€˜openâ€™ and â€˜open exclusivelyâ€™

Question:
What is the maximum length a text field can be?

Question:
Where can you find the undo command in Access?

Question:
Which of the field has width 8 bytes?

Question:
Which of the following creates a drop down list of values to choose from?

Question:
Which of the following database object hold data?

Question:
Which of the following is a method to create a new table in MS Access?

Question:
which of the following is not a database object?

Question:
Which of the following is not a type of Microsoft Access database object?

Question:
Which of the following statement is true?

Question:
Which of the following store command to retrieve data from database?

Question:
_______ are documents that when filled in create records.

Question:
_______ is the clear leader for personal databases.

Question:
________ is used to build â€˜intuitiveâ€™ queries

Question:
_________ will answer questions you did not think to ask of your data.