Microsoft Access Quiz

1.      Database management system use in

• Word

• Powerpoint

• Excel

• Access

Purpose of Microsoft Access?

• Used for letter writing, creating documents and reports

• Create charts and make complex calculations

• To store large amounts of data in an organized and efficient manner

• Create presentations from scratch or a template

Types of object in Microsoft Access?

• Table, Field, Formula and Chart

• Table, Query, Form and Report

• Shape, Form, Spreadsheet and Image

A special relational database table column (or combination of columns) designated to uniquely identify each table record.

• Primary Key

• Secondary Key

• Third Key

Primary key can be empty and NULL.

• Yes

• No

Find specific quickly data by filtering on specific criteria (conditions)

• Table

• Form

• Query

• Report

A relationship in Access helps you combine data from two different tables.

• Yes

• No

Is not a valid data type in Microsoft Access.

• Currency

• Memo

• Hyperlink

• Auto Number

Which tool do you use to create a query object?

• Table Query Wizard

• Simple Query Wizard

• Database Wizard

The columns in a Microsoft Access table are called as

• Macro

• Fields

• Columns

• Records