Kori wants to know how many students in FBLA are seniors, but does not want to save the information. Which operation would she perform?
What is filter
100
Ashton needs to add a footer to his gaming database. Which view will allow Ashton to add a footer?
What is Design View
100
After a query is created, which action must take place to display the results of the query?
What is Run
100
Tanya created a report to show people signed up for a 5K race. She needs to increase the size of the report header so she can add the race logo control. Which view will allow her to resize the header?
What is Design View
100
Dean needs to add the FBLA logo to the top of his membership form. Which type of control should he use?
What is Unbound
200
Amanda wants to ensure there are only two characters for state abbreviation. What should she do?
What is limit field size
200
You are employed as an assistant at Doggie Daycare. Your boss has asked you to update the new pet patient information. If you opened the form in Design View, which view should you switch to in order to enter patient information?
What is Form View
200
Marci is searching a Planet Database. She wants to find out how many moons Saturn has and the names. Which comparison operator would she use?
What is And
200
Barney would like to create a report in layout view so that he can easily modify contents and formatting. Which option uses layout view and gives the user greater control over the report's appearance while displaying the data?
What is Blank Report
200
Ann 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?
What is Add Existing Fields
300
Which type of field enables a user to select from a list of values when updating the contents of a field?
What is lookup field
300
Jeremy needs to create a quick form based on a single table in his baseball card database. Which option will automatically include all the fields from a single table?
What is Form Tool
300
Sam completed a query on the UNC School system and wants to narrow his search to find which schools have a maximum tuition of $15,000 for in-state students. Which operator would he use?
What is < =
300
20. Wendy wants to view how the report will look like without producing a hard copy. Which option would she choose?
What is Print Preview
300
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?
What is Blank form
400
DJ Khaled says this unique identifier will help create relationships between tables
What is primary key
400
Michelle wants to change back color, add descriptions and captions, and change alternate row colors. Where can she complete these tasks?
What is Property Sheet
400
What action would Donna perform to create a new table named Customer Appreciation from the existing Customer Information table and Order History table?
What is Make Table query
400
You are the owner of Ima Graphic Animator, Inc., a graphic design company. You want to place your logo at the top of the first page on a report. Where would you place the logo in the Report Design View?
What is Report Header Section
400
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:
What is Subform
500
Input mask, zero-length strings, validation text are examples
What is field properties
500
Juan wants to view one record at a time in his database. Which view should he be in?
What is Form View
500
Anna is doing a search of the bed and breakfasts in Southport, NC. She wants to know which bed and breakfast is less than one mile from the waterfront and allows pets. Which comparison operator would she use?
What is < and
500
Mrs. Porter wants her students to be arranged in alphabetical order and by class period. What feature should be used in the Report.
What is Group and Sort
500
Terry's form needs to display the FBLA member's exact age based on today's date and their birth date. Which type of control would allow Terry to display information that would change every day?