AES Study Guide AES

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

Information about one customer

A database contains a customer table. What would be stored in a record of the customer table?

The tables in a relationship

A primary key field from one table appears in a second table. What can be said about these tables ?

A foreign key

A primary key field from one table appears in a second table. What is the field in the second table called?

True

A query for a report can come from multiple tables.

Database Management System

A store needs to keep track of suppliers and inventory. What software can be used to create the database, tables, fields and records?

Inventory table

A store tracks coustomers and their orders in a database. Which table would not be part of this database?

Database

A store tracks customers and their orders in a database. What can be created to store this collection of related data?

Data integrity

You discover many erors in a database table. What has been lost?

Fields to a table

You specify data types when adding__________.

Form

Data can be entered into the Datasheet view, but it can be easier to use a_____________instead.

Largest to smallest

Descending means sorting from:

Yes, relationships need to be defined

Does Microsoft Access need to be told about relationships between tables?

Primary Key

Every record must have a different__________value in a table.

False

Forms can be used to browse data, but they cannot be used to add, update or delete records.

Product ID

Given these two views of the same database table, which field in the Datasheet View will cause a data integrity problem?

Select Shelia Hagar's records and then right clicking the record

If you wanted to delete Shelia Hagar's record from the table, what would you do first?

Navigation pane

In the image what is the highlighted area of the screen called?

Search

In the image where would you click to look for a name in the database?

Row next to Smith

In the table wherewould you click to start entering a company name for Jeff Smith?

Susan Lindross

In the table which customer does not have a company associated with their information?

No

Is it OK to have a database of unrelated data?

City

Look at the information in the database table. What field is being used to FILTER the table?

A foreign key

Look at the information in the database table. What is the field in the second table called?

False

Queries can only use data form one table at a time.

False

Sorting from A-Z is also called a descending sort.

A field

The image represents a database. What does item A indicate in the database?

Query

What is it called when you "ask the databasae a question"?

Filter

What is it called when you view some records and hide others?

Sort

What is it called when you want to see database records in a certain order?

Reports can be formatted

What is the advantage of reports over queries?

New

Where would you click to enter a new record?

Datasheet View

Which database view can be used to enter data?

Forms

Which of the following is an easy way to enter and browse data in a large database?

Create

Which ribbon do you use to make a new table?

So the data can be found when needed

Why does data inside a database need to be organized?

False

You cannot change the order of fields on a report.

Smallest to largest

Ascending means sorting from:


संबंधित स्टडी सेट्स

Conjunctions and Interjections Test

View Set

Chapter 2: Assessing Community Need and Establishing a Program

View Set