Ashawn has created a table from his database to know the number of products currently available for sale in his spring catalog. Which aggregate function should he use?

Ashawn has created a table from his database to know which product has the lowest quantity in inventory from his spring catalog. Which aggregate function should he use?

What is the purpose of a primary key in a database?

Carol has created a table from her database to see all information about FBLA chapters in her region. She needs to know the mean number of active members in the region. Which aggregate function should she use?

Ashawn has created a table from his database to see his company's income and expenses for the year and now would like to see the totals for each category. Which table feature should he use?

Aaron needs to duplicate a field that is used in his customer table in the business database for a new form he is creating for entering customer orders. Which item from the tools group would enable him to perform this operation?

Jackson is starting a new company database to manage his fall line of products. What form tool could he use to quickly create a set of tabs a user could click to access forms and reports in the database?

Amy would like to quickly create a form in layout view so that she can easily modify contents and formatting. Which option uses layout view and gives the user greater control over the form's appearance while displaying the data?

Cathy needs to duplicate a column that is used in her spring sports table in the athletic database for a new form she is creating for fall sports. Which item from the tools group would enable her to perform this operation?

Sally is the National Technical Honor Society president. She is creating a database to manage her membership information. What form tool could she use to quickly create a set of tabs a user could click to access forms and reports in the database?

Susie has a relational database for her catering business. She wants to create a form which shows the customer information at the top and any orders for that customer at the bottom. The orders section of the form is a:

Susie has a relational database for her catering business. She wants to create a form which shows the data in a customer table one record at a time. This type of form is a:

Margaret wants to send an address change to all the customers in her current database. She wants to create address labels to accomplish this. Which would she use?

Frank needs to know the number of service calls he has received from 123 Walnut Street in one week. Using a calculated field, which total function would he use to answer this question?

Mrs. Wilson needs to create a report that lists students by their homeroom teacher. Each teacher needs a separate list for attendance. Which option would allow Mrs. Wilson to put students together by homeroom on separate sections of the report?

Which type of operation performs mathematical functions, such as MAX, MIN, or COUNT, on a group of records?

Frank needs an estimated number of services his company performs each month. Using a calculated field, which total function would he use to answer his question?

Sam enters a numeric criterion in a query to find out which UNC schools have an enrollment that equals 5,000 or greater. What would he enter?

What action would Donna perform to create a new table named Customer Appreciation from the existing Customer Information table and Order History table?

What type of query enables a user to add the results of a query to an existing table in a database?

John wants to create a query that will display the total number of hamburger patties in stock at two different locations. The results should display the sum of the values from each location. Which solution should John use for his query?

What type of query enables a user to make the same change to all records satisfying a certain criterion?

The manager of Doggie Donuts needs to group inventory by types of dog food in stock. He needs a subtotal for each group. Which query action will display this information?

Which type of operator enables a user to compare two values in a query criterion?

Juan is creating a chart which graphs attendance at FBLA State Leadership conferences from the past five years from his database. He wants to display a list of colors, shapes, or patterns used as categories in a chart on the right side. Which tab in Chart Options would he select?

Maria needs to share a form from her database to other members of her work team, but she is not sure everyone has Microsoft Access. In which file format should she save the form to ensure everyone can read the information?

Juan is creating a chart which graphs attendance at FBLA State Leadership conferences from the past five years which he has in a database. He wants to show individual data values. Which tab in Chart Options would he select?

Juan is creating a chart graphing his inventory database. He needs to name the chart “August Inventory Report.” Which tab in Chart Options would he select?

Juan is creating a chart that graphs attendance at FBLA State Leadership conferences from the past five years, which he has in a database. He wants to remove the y-axis value. Which tab in Chart Options would he select?

What is the process of transferring data from an Microsoft Access database for use in another application called?

Which file type places each record on a separate line and uses a special character to separate fields?

Mary needs to export the table of FBLA members from the Southeast Region database to a document that does not allow editing. Which format should she use?

Which is not a file type that may be imported into Microsoft Access?

Marty has spent a lot of time creating a database to track her sales contacts.She has been asked by management to share the database with her colleagues as an example to follow. What would be the best method of sharing the structure of a database, including relevant tables, queries, and forms?

Rachel has spent a lot of time creating a membership database for her FBLA chapter, which she has been asked to share with other chapters in her region as an example. What would be the best method of sharing the structure of a database, including relevant tables, queries, and forms?

Ali has worked for years cataloging his comic book collection into a database. Recently his computer crashed, but fortunately he has a backup in his OneDrive cloud storage. Which method should he use to restore his database on his new computer?

What term describes the process of repairing and removing wasted space from a database?

Kurt has worked for years cataloging his music collection into a database. During a recent storm, Kurt's computer was damaged, but fortunately he has a backup on his flash drive. Which method should he use to restore his database on his new computer?