Database Basics
What is the main object in Microsoft Access?
What is Tables
A _____________ is a collection of rows referred to as records and columns referred to as fields
Table
_____________ is a field or set of fields with values that are unique throughout a table
Primary Key
List three organizations where a database can be found
School, banks, tax office, supermarket, prison, insurance companies, church etc
True or False, A row is referred to a field
False
This feature in MS access allows us to link two or more tables
Relationship
The term given to the type of data that a field can store
Data type
The name of the most used database Management System
What is Microsoft Access
A___________ is also reffered to as an Attribute
Field
A field contains the id number "JS101" Which data types would best be used?
Text
All of the following are data types EXCEPT
Number, Text, Character, Yes/NO
Character
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
Tables are best created using which aspects of MS Access?
Design View
All of the following can be used as a primary key except
ID NUMBER, TRN, LAST NAME, ACCOUNT #
LAST NAME
Which data type would be most suitable for the telephone number "876479-2591"
Text - because it contains the dash"-"
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
What is the first step in creating a table in Design view?
Select the "Create" Tab
A primary key has two main characteristics what are they
1. it cannot contain a null value
2. cannot have any repetition
List the steps to create a Database called 9 MUS
1. Locate the App
2. Select the blank database
3. Type in the name 9 MUS
4. Select Create