Access Test Flashcards
(T/F)
1. Tables are sometimes called entities
True
- What is data?
Facts and statistics only
(T/F) Tables are related sets of information
True
(T/F) The LONG text field can be used as often as you like.
False
- What does DBMS stand for?
Database Management System
(T/F) 3. Each foreign key is a primary key in another tab
True
(T/F)
3. In a business narrative, tables can be identified as adjectives
False
. What is the maximum number of characters for the SHORT text data type.
255
. Entities are made up of rows and columns. The columns are called
fields
- Excel is an example of
Flat File Database
(T/F) 4. There are 5 types of relationships.
False
A foreign key is a column in a table used to reference a primary key in another table.
True
- A primary key is typically set to what type of data?
Autonumber
. What is the most common database model?
Relational Database Model
(T/F) . A 1:1 relationship generally occurs when a table is a subset of another table
True
(T/F) A foreign key can be data type SHORT text when the primary key is a number.
False
(T/F). A 1:M relationship exists when a record can relate to 1 or more records in a second table
True
(T/F) The many in a 1:M relationship can relate to only one record in the primary table.
True
When designing a database, the first prinicple is to reduce
Redundant or duplicate information
A primary key field holds data that
uniquely identifies each record in a table
Whata data type should you use for a field that will store telephone numbers
SHORT text
Each field in a table must contain:
a unique name
If you let MS Access create a primary key for you, what field name does it use?
ID
In design view how can you tell that a field is the primary key?
The key symbol appears on the row selector button.
Which of the following is not a valid data type?
Text & Numbers
(T/F) After you save your table structure, you cannot edit or change it.
False
(T/F) You can enter only numbers in a numbers field
True
(T/F) In Access Query design mode, to match a word or phrase simply type the text you want to match in the criteria area
True
Yor* will find
York
Working with dates requires what symbol surrounding the date?
#
(T/F) Changing a field name has no effect on the data stored.
True
(T/F) To add a field in table design view, type the field name in the field name box and press enter.
True
Which of the following features is found in a relational database management system but not in a file management system?a. The ability to store records b. the ability to define relationships between tables c. the ability to retrieve records d. all answers are correct
all answers are correct