AES Study Guide AES
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: