Databases

Dana is creating a table that will show books for sale on a bookstore’s website. Which field in the table would best serve as its primary key?

ProductID

Explanation: A primary key uniquely identifies each record in a table. A ProductID is the best choice for a primary key because it ensures each product can be uniquely identified.

Which data type would be best suited to a field that lists a product’s clearance price?

Currency

What is a query in database terminology?

A question you ask a database. - A query is a request for data or information from a database, formatted to retrieve specific results based on criteria.

T/F: A database is a collection of related information, but a database management system is a type of software program.

True - A database management system (DBMS) is software that interacts with end users, applications, and the database itself to capture and analyze data.

In a database, each __________ contains a collection of related data.

Table

What are the different views to display a table?

Datasheet View, Design View, Pivot Table & Pivot Chart View

A relationship in a database connects how many tables?

Two

In a record, each separate piece of data, such as a last name, a first name, or an address, is called a _____________.

Field

One disadvantage of computerized databases is that they limit your ability to arrange information.

False

Malisa is designing a database for a doctor’s office where receptionists, office managers, and other office staff will need to manage patient data. Which database object should Malisa create to make it easy for these non-technical users to add patient records?

Forms

Is it true that a database is an organized collection of information?

True

Sawyer is looking at a table of students in his class, but it seems like the list is way too short. What is the most likely problem?

The table is filtered.

Which data type is best suited storing customer email addresses?

Hyperlink

What are the columns in a Microsoft Access table called?

Fields

T/F: A computerized database can store millions of telephone numbers.

True

Xavier is designing a Students table that will continue to track students even after they have completed their programs. Which of the following fields would work best with the Yes/No data type?

Graduated

Ibraheem works for a music store. Which of the following tables will give him the company contact information he needs to place a custom order for a guitar?

Vendors

Which of the following is NOT a part of a database?

Worksheets

T/F: A field's data type determines what kind of information can be stored there.

True

Which of the following is a way to sort data?

Chronologically, Numerically, and Alphabetically

Contact information for all people taking a class is stored in a ________ called Students.

Table

T/F: Databases typically store their data in one big table.

False

Which of the following is LEAST likely to be a field in a Customers table?

EmploymentDate

What does a filter in a database do?

Hide records from view

What sort order will show the oldest patients first based on birthdate?

Smallest to Largest

What does SQL stand for?

Structured query language

T/F: A query lets you speed up the browsing process by finding information that matches specifically to your criteria.

True

All the pet names in a veterinarian’s database are stored in a _______ called PetName.

Field

Queries in access can be used

as a sources of records for forms and reports and to view, change and analyze data in different ways

Which field could serve as the primary key for a list of students in your school?

Student ID number