Services
Discover
Homeschooling
Ask a Question
Log in
Sign up
Filters
Done
Question type:
Essay
Multiple Choice
Short Answer
True False
Matching
Topic
Computing
Study Set
Exploring Microsoft Office Study Set 1
Quiz 31: Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data
Path 4
Access For Free
Share
All types
Filters
Study Flashcards
Practice Exam
Learn
Question 81
Essay
Explain the NOT logical operator and provide one example.
Question 82
Essay
Why might you want to import data rather than creating a new database from scratch?
Question 83
Essay
Would you want to save every query that you create? Why or why not?
Question 84
Essay
What is one important limitation of the Simple Query Wizard?
Question 85
Essay
What are the three ways to run a query?
Question 86
Essay
How do you launch the Query Wizard and what is the first step of the wizard?
Question 87
Essay
"The primary key of a table plays a significant role when setting relationships." Describe why this statement is true.
Question 88
Essay
Why should you strive to avoid data redundancy in a database?
Question 89
Essay
Describe a wildcard in Access.Mention at least two wildcards that are available in Access.
Question 90
Essay
Describe how sort order in an Access table is determined.
Question 91
Matching
Match the first part of each sentence with the following part:
Premises:
Responses:
A table is a collection
of a constant.
Each record of a table is made up
of fields.
Interest amount is often an example
of a calculated field.
Premises:
A table is a collection
Each record of a table is made up
Interest amount is often an example
Responses:
of a constant.
of fields.
of a calculated field.
Question 92
Matching
Match the following terms to their meanings:
Premises:
Responses:
data type
date of birth is a common field example
foreign key
determine the type of entry that can be made into a field
data redundancy
produces a value from one or more existing,often numeric,fields
Premises:
data type
foreign key
data redundancy
Responses:
date of birth is a common field example
determine the type of entry that can be made into a field
produces a value from one or more existing,often numeric,fields
Question 93
Matching
Match the following terms to their meanings:
Premises:
Responses:
number data type
can hold up to 255 characters
AutoNumber
creates a label more readable than a field
caption property
can be set to Integer
Premises:
number data type
AutoNumber
caption property
Responses:
can hold up to 255 characters
creates a label more readable than a field
can be set to Integer
Question 94
Matching
Match the following data types to their definitions:
Premises:
Responses:
Short Text
creates a field to choose a value from another table
Long Text
limits field values to on and off,for example
Yes/No
contains something created by another application
Premises:
Short Text
Long Text
Yes/No
Responses:
creates a field to choose a value from another table
limits field values to on and off,for example
contains something created by another application