Complete your AES Financial Literacy course with these practice questions and answers. This guide covers student loan basics, repayment options, budgeting, and financial planning.
Q: Inventory table
Answer: A store tracks coustomers and their orders in a database. Which table would not be part of this database?
Q: Database
Answer: A store tracks customers and their orders in a database. What can be created to store this collection of related data?
Q: Forms
Answer: Which of the following is an easy way to enter and browse data in a large database?
Q: Information about one customer
Answer: A database contains a customer table. What would be stored in a record of the customer table?
Q: New
Answer: Where would you click to enter a new record?
Q: Select Shelia Hagar’s records and then right clicking the record
Answer: If you wanted to delete Shelia Hagar’s record from the table, what would you do first?
Q: A field
Answer: The image represents a database. What does item A indicate in the database?
Q: Susan Lindross
Answer: In the table which customer does not have a company associated with their information?
Q: Data integrity
Answer: You discover many erors in a database table. What has been lost?
Q: Row next to Smith
Answer: In the table wherewould you click to start entering a company name for Jeff Smith?
Q: So the data can be found when needed
Answer: Why does data inside a database need to be organized?
Q: Database Management System
Answer: A store needs to keep track of suppliers and inventory. What software can be used to create the database, tables, fields and records?
Q: No
Answer: Is it OK to have a database of unrelated data?
Q: Fields to a table
Answer: You specify data types when adding__________.
Q: Datasheet View
Answer: Which database view can be used to enter data?
Q: False
Answer: Forms can be used to browse data, but they cannot be used to add, update or delete records.
Q: Product ID
Answer: Given these two views of the same database table, which field in the Datasheet View will cause a data integrity problem?
Q: Navigation pane
Answer: In the image what is the highlighted area of the screen called?
Q: Form
Answer: Data can be entered into the Datasheet view, but it can be easier to use a_____________instead.
Q: Primary Key
Answer: Every record must have a different__________value in a table.
Q: Create
Answer: Which ribbon do you use to make a new table?
Q: The tables in a relationship
Answer: A primary key field from one table appears in a second table. What can be said about these tables ?
Q: Largest to smallest
Answer: Descending means sorting from:
Q: Smallest to largest
Answer: Ascending means sorting from:
Q: City
Answer: Look at the information in the database table. What field is being used to FILTER the table?
Q: Query
Answer: What is it called when you “ask the databasae a question”?
Q: False
Answer: Queries can only use data form one table at a time.
Q: Sort
Answer: What is it called when you want to see database records in a certain order?
Q: A foreign key
Answer: Look at the information in the database table. What is the field in the second table called?
Q: Reports can be formatted
Answer: What is the advantage of reports over queries?
Q: A foreign key
Answer: A primary key field from one table appears in a second table. What is the field in the second table called?
Q: Filter
Answer: What is it called when you view some records and hide others?
Q: Search
Answer: In the image where would you click to look for a name in the database?
Q: False
Answer: Sorting from A-Z is also called a descending sort.
Q: Yes, relationships need to be defined
Answer: Does Microsoft Access need to be told about relationships between tables?
Q: False
Answer: You cannot change the order of fields on a report.
Q: True
Answer: A query for a report can come from multiple tables.