Scheduled maintenance: Thursday, December 8 from 5PM to 6PM PST
Home
Subjects
Expert solutions
Create
Log in
Sign up
Upgrade to remove ads
Only ₩37,125/year
- Science
- Computer Science
-
Flashcards
-
Learn
-
Test
-
Match
-
Flashcards
-
Learn
-
Test
-
Match
Terms in this set (73)
when is a database used
to store and organize large amounts of information for quick searching
what are tables
where databases store information which are made up of columns and rows
relational databases consist of multiple tables of information that are related through what
common fields
which type of application would you use if you need to "crunch" relatively small volumes of numbers to analyze numeric data
spreadsheet
which type of application should you use if you need to store a large quantity of data in an organized format that you can easily query
database
True or False spreadsheet files can contain only a limited number of records
true
what is big data
a collection of data so large and complex that it is difficult to manage using traditional database management systems
which microsoft office application would you use for database creation and manipulation
access
what do search engines consist of that contain information about webpages
databases
advertisers use Big Data to do what
focus target markets
T/F search engines are suitable for crunching numbers
False
the title bar in access usually consists of what
the names of the applications and the database
the options on the ribbon will do what
change depending on the tab
t/f you will find a create option on the backstage view of access
false
retailers use big data to do what
offer special promotions
what options are available by default on the Quick Access Toolbar
print, save and redo
what is an advantage of using a database
more than one person can use it at a time
what is an advantage of using a spreadsheet
you can easily sort and query
Name a search engine
bing
In a database, yes/no, text and date/time are examples of what
data types
which database component is used to organize information by data type
field
what is another name for a table row in a database
record
what is a query
A command to retrieve data from tables from a database
what is a report
what you can use to summarize and print data for presentation or sharing
what language is used to develop and manage databases
SQL
what does a database use to provide a simplified interface for the user to enter modify and view database records
forms
when does the data need to be unique
with the primary key
in what table relationship does a record in table A have multiple matching recored in table B but a record in table B has only one matching record in table A
one-to-many
what database application would most likely be used in large organizations
Oracle
which data types is best for calculations
number
how many characters are allowed in the text field
1-255
what is a foreign key
a field in a related database table that refers to the primary key in the primary table
what data type is used for monetary values
currency
what data type is used to provide links to other resources
hyperlink
what data type allows object linking and embedding
OLE Object
how many data types are there in access
10
What does SQL stand for?
Structured Query Language
the tables of information in a relational database are joined or linked to one another by
a common field
How is each record in a database identified?
By the number in the ID column
which operation would you perform to change your age in a database field
update a record
which operation would you use to insert information into a database table for a new student in your class
add a record
which operation would you use to remove information from a database table for a student who leaves your class
delete a record
what should you do if you want to view a database records in alphabetical order by last name
sort the records in the database by the Last Name field
what happens to the unique ID field when a record is deleted
the ID is deleted
what view allows you to make changes to the database
design view
what information is considered when naming a database table
the purpose of the table
after starting access, what operations would you perform to create a new blank database
click new, blank desktop database
what operations would you perform name a database
type the name in the file name box
why is the text data type appropriate for the student name field
when the field is alphanumeric with less than 255 characters
why is the number data type appropriate for siblings field
it has numeric data
how are the record relationships preserved once a record is deleted
the unique ID values of the other records remain the same
what operations would you perform to delete a record
select the entire record, right click the record, and select delete record
what operations would you perform to add a record
in the database view enter the appropriate information for each filed in the row of the table
what is a common error when creating database tables
entering the wrong data type in a field
what should you choose to display specific information from a database table
a select query
what should you choose to perform an action on specified records in a database table
an action query
what does query mean
question
how can you add two unrelated tables to a query
create a table join
what operation would allow you to convert a spreadsheet into a database
import
which operation would allow you to convert a database into a spreadsheet
export
what should you create if you need to see a printout of the current data in a database
a report
what should you do if you want to alter the "look and feel" of a report
add a report theme
why would you create a database report
To share and present database information in print form
what operation would you perform to rename a field
open the table in design view, click into the field name column, type the new name, click the save button
what operation combines two records and displays them as one record in the querys result set
join
why would you export data
to use in other applications
what are your options when importing data from excel
create, append or link to a database
what is a common error when creating and query
mistyping the name of a table or field
t/f a list is a type of query
false
t/f the Primary Key is a type of error that prevents a join from working correctly
false
what happens when you select the link option while importing data
the access data updates when the source file updates
t/f you can use export to modify the look of a report
false
why would you create an append query
to add records to a table
Database Essentials Lesson 2
20 terms
PoofyPentil
Database
15 terms
SSophieF1
Lesson 4: Manipulating and Sharing Data in a Datab…
10 terms
fans610
Database Lesson 4
18 terms
Talbotm2
Other sets by this creatorReading (Quarter 3)
21 terms
julie_moody5
Final Review Project
36 terms
julie_moody5
Climate Change
29 terms
julie_moody5
Unit 9 Unit review quiz
31 terms
julie_moody5
Verified questions
chemistry
What type of survivorship curve characterizes humans? What other characteristics are associated with this type of survivorship curve? Do humans show many of these other characteristics?
Verified answer
computer science
Write and implement a recursive version of the sequential search algorithm.
Verified answer
health
Identify the components of the skeletal system and the functions of the bones. Choose the correct organ or tissue being described. Firm connective tissue found mostly in joints. a. muscle b. ligament c. tendon d. cartilage
Verified answer
biology
Because you are a biology student, your nonscientist neighbors are confident that you know all about plants. A neighbor brings you a potted plant he bought 3 weeks ago from a nursery. The leaves have brown spots. He bought another plant of the same species from a different nursery 3 weeks ago, and that plant has no spots. You go to the nursery where the neighbor bought the infected plant and find several pots of plants with no brown spots on their leaves. What plant characteristics might account for the absence of spots?
Verified answer
Recommended textbook solutionsIntroduction to Algorithms
3rd EditionCharles E. Leiserson, Clifford Stein, Ronald L. Rivest, Thomas H. Cormen
726 solutions
Service Management: Operations, Strategy, and Information Technology
7th EditionJames Fitzsimmons, Mona Fitzsimmons
103 solutions
Information Technology Project Management: Providing Measurable Organizational Value
5th EditionJack T. Marchewka
346 solutions
Starting Out with Python
4th EditionTony Gaddis
629 solutions
Other Quizlet setsCivil Rights Movement Study Guide
14 terms
mb4040
Lecture 10 (Growth Control)
72 terms
brookegrigsby
Government Quiz #4
53 terms
lyndsichang