MS - Access - 1

Description: Test your basics of MS Access with this quiz.
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 Computer Basics Microsoft Office
Attempted 0/25 Correct 0 Score 0

Attributes can be defined for

  1. entity

  2. switch board

  3. macro

  4. pages

  5. none of these


Correct Option: A

By which command can we create a table from a query?

  1. Simple query wizard

  2. Make table query

  3. Cross table query

  4. Append query

  5. None of these


Correct Option: B

Which of the following is a DBMS software?

  1. Access

  2. Excel

  3. Word

  4. Power point


Correct Option: A

How many types of database objects are there in MS-Access?

  1. 5

  2. 6

  3. 7

  4. 8

  5. None of these


Correct Option: C

How many modes or views are available to open a query?

  1. 3

  2. 5

  3. 6

  4. 7

  5. None of these


Correct Option: A

What is the default size of the data type in MS-Access?

  1. 50

  2. 60

  3. 70

  4. 80

  5. None of these


Correct Option: A

How many types of normalization forms are there in MS-Access?

  1. 3

  2. 4

  3. 5

  4. 6

  5. None of these


Correct Option: A

Which symbol is used to align the text to the right in a table?

  1. <

  2. >

  3. @

  4. $

  5. None of these


Correct Option: D

A memo data type of access can hold ________ characters.

  1. 31, 000

  2. 32, 000

  3. 33, 000

  4. 34, 000

  5. None of these


Correct Option: B

Which menu keeps the relationship command?

  1. Tools

  2. Insert

  3. Format

  4. Table

  5. None of these


Correct Option: A

Which symbol is used to display the contents in lower case?

  1. <

  2. >

  3. $

  4. %

  5. None of these


Correct Option: A

In order to include picture, data type must be

  1. OLE

  2. Hyperlink

  3. Yes/No

  4. Picture

  5. None of these


Correct Option: A

Which option should we use to give heading in the form?

  1. Label

  2. Textbox

  3. Option Group

  4. Insert

  5. None of these


Correct Option: A

Which command is used to close Datasheet view of the table?

  1. Ctrl + W

  2. Ctrl + C

  3. Ctrl + O

  4. Alt + F4

  5. None of these


Correct Option: A

How many types of queries are available in the query menu?

  1. 4

  2. 5

  3. 6

  4. 7

  5. None of these


Correct Option: A

Which menu keeps the parameter command?

  1. Tools

  2. Query

  3. Insert

  4. View

  5. None of these


Correct Option: B

By which command can we link a table with Excel worksheet?

  1. Get external data

  2. Join

  3. Attach

  4. Merge

  5. None of these


Correct Option: A

By which command can we add records to a table from different tables?

  1. Simple query wizard

  2. Cross query wizard

  3. Find match query

  4. None of the above


Correct Option: A

How many types of summary operators are there in access?

  1. 5

  2. 6

  3. 7

  4. 8

  5. None of these


Correct Option: A

Name the step to create summary query.

  1. Simple query wizard

  2. Summary query

  3. Cross tab query

  4. None of the above


Correct Option: A

Unlike filters, queries can be saved as _______ in a database.

  1. objects

  2. filters

  3. database

  4. files

  5. None of these


Correct Option: A

Where do we find the referential integrity command?

  1. Tools

  2. View

  3. Format

  4. None of these

  5. All of these


Correct Option: D

How many types of relationships are there in MS-Access?

  1. 3

  2. 4

  3. 5

  4. 6

  5. None of these


Correct Option: A

Why do we use the input mask in MS-Access?

  1. For formatting of text

  2. For alignment of text

  3. For formatting of numbers

  4. All of the above

  5. None of these


Correct Option: C

How many types of computing models are there?

  1. 3

  2. 4

  3. 5

  4. 7


Correct Option: B
- Hide questions