Intro to Database (Microsoft Access)

Database Basics

100

What is the main object in  Microsoft Access?

What is Tables

200

tables, forms, queries, and reports

What are the four objects in a database

300

The name of the most used database Management System

What is Microsoft Access 

400

request for specific data results, and for action on data. You can use it to answer a simple question, to perform calculations

What is a Query

500

A____________ is used to present the information retrieved from the tables of a database in a presentable manner so that it is useful and appealing to the user.

What is a report

Tables

100

A _____________ is a collection of rows referred to as records and columns referred to as fields

Table

200

True or False, A row is referred to a field

False

300

A___________ is also reffered to as an Attribute

Field

400

Tables are best created using which aspects of MS Access?

Design View

500

What is the first step in creating a table in Design view?

Select the "Create" Tab

Data Type

100

Which of the following is NOT a data type in Access?

1. YES/NO

2. MEMO

3. STRING

4. TEXT

Strings

200

Which data type would be best for "10011"?

numbers/integer

300

I Want to store students' school fees in a Field, which data type would be most suitable for this?

Currency

400

What are the 2 views used in MS Access

1. Design View

2. Datasheet View

500

List 5 Data types used on Microsoft Access

Text, number, currency, Date/Time, Autonumber, Memo, Yes/no

Database Basics 2

100

_____________ is a field or set of fields with values that are unique throughout a table

Primary Key

200

This feature in MS access allows us to link two or more tables

Relationship

300

A field contains the id number "JS101" Which data types would best be used?

Text

400

All of the following can be used as a primary key except

ID NUMBER, TRN, LAST NAME, ACCOUNT #

LAST NAME

500

A primary key has two main characteristics what are they

1. it cannot contain a null value

2. cannot have any repetition 

Random

100

List three organizations where a database can be found

School, banks, tax office, supermarket, prison, insurance companies, church etc

200

The term given to the type of data that a field can store

Data type

300

All of the following are data types EXCEPT

Number, Text, Character, Yes/NO

Character

400

Which data type would be most suitable for the telephone number "876479-2591"

Text - because it contains the dash"-"

500

List the steps to create a Database called 10 MUS2

1. Locate the App

2. Select the blank database

3. Type in the name 10 MUS2

4. Select Create