MS Access

Question 1

Is a repository of data.

Answer 1

Database

Question 2

It can be a text, image, video or even logs.

Answer 2

Data

Question 3

Is used to organize data so that it can be easily accessed, managed, and updated.

Answer 3

Database

Question 4

DBMS stands for?

Answer 4

Database management system

Question 5

What are the two basic building blocks of database?

Answer 5

Entity and Attribute

Question 6

Is a thing or object that has meaning and relevance in your domain. For example, a customer, a product, or an order.

Answer 6

Entity

Question 7

They are properties or characteristics that describe the entity. For example, a customer can have __________ such as name, email, and address.

Answer 7

Attributes

Question 8

Converting the Entities and attributes to tables refers to the process of what?

Answer 8

Mapping

Question 9

In mapping, the entities translates ______.

Answer 9

Tables

Question 10

All the attributes translates into _______ in a table.

Answer 10

Columns

Question 11

Alphanumeric data. Formerly known as text. Up to 255 characters.

Answer 11

Short text

Question 12

Large amounts of alphanumeric data. Up to 1gb data.

Answer 12

Long text

Question 13

Numeric data. 1, 2, 4, 8, or 16 bytes.

Answer 13

Number

Question 14

Numeric data. 8 bytes.

Answer 14

Large number

Question 15

Date and times. 8 bytes.

Answer 15

Date/Time

Question 16

Date and times. Encoded string of 42 bytes.

Answer 16

Date/Time Extended

Question 17

Monetary data, stored with 4 decimal places of precision. 8 bytes.

Answer 17

Currency

Question 18

Unique value generated by Access for each new record. 4 bytes (16 bytes for replicationID).

Answer 18

AutoNumber

Question 19

Boolean (true/false) data; Access stores the numeric value (0) for false, and -1 for true. 1 byte.

Answer 19

Yes/No

Question 20

Picture, graphs, or other ActiveX objects from another Windows-based application. Up to about 2 gb.

Answer 20

OLE Object

Question 21

What are the four database objects?

Answer 21

Tables, Forms, Queries, Reports

Question 22

In Access, all data is stored in ______.

Answer 22

Tables

Question 23

It is the heart of any database.

Answer 23

Tables

Question 24

In Access, rows and columns are referred to as _______ and ______.

Answer 24

Records and Fields

Question 25

Is a tool that guides you through the process of creating complex reports.

Answer 25

Report Wizard

Question 26

Allow you to pull information from one or more tables based on a set of search conditions you define.

Answer 26

Queries

Question 27

This lets you access common commands no matter which tab is selected.

Answer 27

Quick Access Toolbar

Question 28

It contains all of the commands you will need to perform common tasks in Access. It has multiple tabs, each with several groups of commands.

Answer 28

Ribbon

Question 29

It box works like a search bar to help you quickly find tools or commands you want to use.

Answer 29

Tell Me

Question 30

Displays all of the objects contained in your database.

Answer 30

Navigation Pane

Question 31

All open objects are displayed in tabs on the ________ Tabs bar. To view an object, click its tab.

Answer 31

Document Tabs bar

Question 32

It allows you to navigate records one at a time.

Answer 32

Record Navigation Bar

Question 33

You can use this to search for any term in the current object. The first result will be selected automatically.

Answer 33

Record Search box

Question 34

Gives you various options for saving, opening, and printing your database.

Answer 34

Backstage View

Question 35

Each record has its own __ ______.

Answer 35

ID Number

Question 36

This command allows you to search for any term in your table.

Answer 36

Find

Question 37

This command allows you to search for any term in your table and replace it with a new one.

Answer 37

Replace

Question 38

The ______ __________ bar allows you to navigate through records one at a time.

Answer 38

Record Navigation bar