Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
26 Cards in this Set
- Front
- Back
|
Jadon has a table with information about each class at school. Within each record he wants to capture a brief description of the course–about 175 characters. Which data type should he select for his course description field?
|
Text
|
|
|
In order to identify who your best clients are, where these customers are located, and what kind of commercials or advertisement would
appeal to these customers. What resource will of fer all of this information? |
Big Data
|
|
|
If you want to transfer informationonto a small place card. What report option should you select?
|
Labels
|
|
|
What language will you use to access and modify information in a database through a website?
|
SQL
|
|
|
If you entered the following information in the table for 3 students: Name, Street Address, City, State, Zip code and Phone number. How many records did you create?
|
Three
|
|
|
Which application is best for grouping data by month, calculate the total sales, define the average sales per quarter and show your results in a chart?
|
Excel
|
|
|
Multiple tables with common fields that are joined to form relationships are a
|
Relational Database
|
|
|
Which database component can help make data entry easier?
|
Form
|
|
|
In a record of financial transactions the following records are captured: date & type of transaction, the person who recorded it & the amount. Which data type should she set for the field containing the transaction amount?
|
Currency
|
|
|
When someone clicks on an email address, it should open a new email message and populate the To field with the selected email address. What data type should be selected to enable this functionality?
|
Hyperlink
|
|
|
If you entered the following information in the table a student: Name, Street Address, City, State, Zip code and Phone number. How many records did you create?
|
One
|
|
|
Data can consist of multiple data types, including text, numbers, graphics, sound clips & video.
|
Relational Database
|
|
|
Carmen wants to alter the "look and feel" of her report. Which operation should she perform?
|
Add a report theme
|
|
|
Data sets that cannot be stored or processed
using traditional database software |
Big Data
|
|
|
Dustin is creating a database that includes all of his friends' names, birthdates and ages. Which three data types does Dustin needs to use?
|
Text, Date/Time and Memo
|
|
|
What is a unique identifier that is assigned to a field when a user creates a database table?
|
Primary Key
|
|
|
Kairi is preparing the data in her database to be used in another program. Which operation is she performing?
|
Exporting
|
|
|
A single entry of information of a particular data type in a database table is a
|
Field
|
|
|
Which data type may contain text, numbers and/or certain special characters?
|
Text
|
|
|
Which query type allows you to retrieve, view and print data?
|
Select query
|
|
|
Jessica needs to create a presentation that summarizes the data in her database. What does she need to create?
|
Report
|
|
|
Jordan has converted a spreadsheet into a
database. Which operation did he perform? |
Importing
|
|
|
When you see an error in your database and you change the value of your database from 500 to 50. What task are you completing?
|
Updating a record
|
|
|
Josiah wants to change his report to include his company logo, group the sales by month & display a calculated field of the total trading card sales. Which view will allow Josiah to make all of these changes?
|
Design View
|
|
|
Jana wants to be able to quickly review past
results, filter by experiment date, and sort her results in multiple orders. What Access object should Jana chose that best meets her needs? |
Table
|
|
|
Which database component is used to define your information by data type?
|
Field
|
