0

MS - Access - 2

Description: Prepare for any competitive exam by getting the complete study material for other Access databases, Excel SharePoint lists, text, XML, Outlook, HTML, dBase, Paradox, Access Project, Excel, Outlook, ASCII, dBase, Paradox, FoxPro, SQL Server, Oracle, ODBC
Number of Questions: 25
Created by:
Tags: other Access databases Excel SharePoint lists text XML Outlook HTML dBase Paradox Access Project Excel ASCII FoxPro SQL Server Oracle ODBC Basic Fundamentals Hardware and Software Information Technology
Attempted 0/25 Correct 0 Score 0

We cannot validate cell value by macros.

  1. True

  2. False

  3. Sometimes

  4. Can't say

  5. None of these


Correct Option: B

We can open two database at a time.

  1. True

  2. False

  3. Sometimes

  4. Can't say

  5. None of these


Correct Option: B

Select the shortcut key to delete an object.

  1. Ctrl + X

  2. Ctrl + C

  3. Del

  4. Ctr + E

  5. None of these


Correct Option: C

We can't rename an object created in MS-Access.

  1. True

  2. False

  3. Can't say

  4. Sometimes

  5. None of these


Correct Option: B

Select the shortcut key for refresh.

  1. F2

  2. F3

  3. F4

  4. F5

  5. None of these


Correct Option: D

External database is

  1. database created in EXCEL

  2. database created using DBMS package

  3. database created in MS-word

  4. all of the above

  5. none of these


Correct Option: B

What is database?

  1. It is a collection of data arranged in rows.

  2. It is a collection of data arranged in columns.

  3. It is a collection of data arranged in rows by columns.

  4. All of the above

  5. None of these


Correct Option: C

We can't start access from the run command.

  1. True

  2. False

  3. Sometimes

  4. Can't say

  5. None of these


Correct Option: B

The shortcut key for paste is

  1. Alt + C

  2. Alt + V

  3. Ctrl + V

  4. Alt + F4

  5. None of these


Correct Option: C

In which menu we can find the macro command?

  1. Insert

  2. View

  3. File

  4. Start

  5. None of these


Correct Option: D

Charts must be created as a part of

  1. tables

  2. forms

  3. reports

  4. both (2) and (3)

  5. None of these


Correct Option: D

Which menu keeps the compact database command?

  1. Tools

  2. View

  3. Edit

  4. Insert

  5. None of these


Correct Option: A

Which of the following names is used to run a macro at starting time in a database?

  1. Start.exe

  2. Auto.exe

  3. Macro.exe

  4. Any of the above

  5. None of these


Correct Option: B

In which menu do we find the command document?

  1. File

  2. Insert

  3. Tools

  4. Data

  5. None of these


Correct Option: C

Which of the following is the shortcut key used to reach the view menu?

  1. Ctrl + V

  2. Alt + W

  3. F4

  4. None of these

  5. All of these


Correct Option: D

Which of the following shortcut keys is used to invoke the spell checker in MS-Access?

  1. F2

  2. F7

  3. Alt + F7

  4. F3

  5. None of these


Correct Option: B

Which name is suitable to run a macro at starting time to database?

  1. Start.exe

  2. Auto.exe

  3. Macro.exe

  4. Any of the above

  5. None of these


Correct Option: E

Select the shortcut key to close the database.

  1. Alt + F4

  2. Ctrl + W

  3. Ctrl + C

  4. Ctrl + F4

  5. None of these


Correct Option: A

In which toolbar do we find the filter command?

  1. Standard Toolbar

  2. Table Datasheet Toolbar

  3. Formatting Toolbar

  4. Forms Toolbar

  5. None of these


Correct Option: B

In which toolbar do we find the short command?

  1. Standard toolbar

  2. Table Datasheet toolbar

  3. Formatting toolbar

  4. Forms toolbar

  5. None of these


Correct Option: B

_____________ helps us to display the records, which meet a particular condition.

  1. Auto fill

  2. Auto filter

  3. Auto shape

  4. Auto sum

  5. None of these


Correct Option: B

Access is a/an

  1. RDBMS (Relational DBMS)

  2. DDBMS (Distributed DBMS)

  3. Server

  4. Protocol

  5. None of these


Correct Option: A

_________ is the process of summarising data from more than one source.

  1. Data validation

  2. Data consolidation

  3. Data form

  4. Data filter

  5. None of these


Correct Option: B

By which start menu option we can find 'shortcut of access' in the start menu?

  1. Find

  2. Run

  3. Control panel

  4. None of these

  5. All of these


Correct Option: D

Which command do we use to show the database objects with its description?

  1. Details

  2. Show

  3. List

  4. Any of the above

  5. None of these


Correct Option: A
- Hide questions