AES Study Guide AES fully solved graded A+ 2023/2024

AES Study Guide AESInventory table - correct answer A store tracks customers and their orders in a database. Which table would not be part of this database? Database - correct answer A store tracks customers and their orders in a database. What can be created to store this collection of related data? Forms - correct answer Which of the following is an easy way to enter and browse data in a large database? Information about one customer - correct answer A database contains a customer table. What would be stored in a record of the customer table? New - correct answer Where would you click to enter a new record? Select Shelia Hagar's records and then right clicking the record - correct answer If you wanted to delete Shelia Hagar's record from the table, what would you do first? A field - correct answer The image represents a database. What does item A indicate in the database? Susan Lindross - correct answer In the table which customer does not have a company associated with their information? Data integrity - correct answer You discover many erors in a database table. What has been lost? Row next to Smith - correct answer In the table wherewould you click to start entering a company name for Jeff Smith? So the data can be found when needed - correct answer Why does data inside a database need to be organized? Database Management System - correct answer A store needs to keep track of suppliers and inventory. What software can be used to create the database, tables, fields and records? No - correct answer Is it OK to have a database of unrelated data? Fields to a table - correct answer You specify data types when adding__________. Datasheet View - correct answer Which database view can be used to enter data? False - correct answer Forms can be used to browse data, but they cannot be used to add, update or delete records. Product ID - correct answer Given these two views of the same database table, which field in the Datasheet View will cause a data integrity problem? Navigation pane - correct answer In the image what is the highlighted area of the screen called? Form - correct answer Data can be entered into the Datasheet view, but it can be easier to use a_____________instead. Primary Key - correct answer Every record must have a different__________value in a table. Create - correct answer Which ribbon do you use to make a new table? The tables in a relationship - correct answer A primary key field from one table appears in a second table. What can be said about these tables ? Largest to smallest - correct answer Descending means sorting from: