Instant assistance for all your computer science questions, assignments, simulations and projects is now available from our qualified experts. Search for anything from a set of flashcards to whole textbook guides and you will be able to find it in our collection of computer science study resources.

You are watching: To save a query, tap or click the save button on the ____.


*

 139. To resize columns in a subform, press and hold or right-click the subform in the Navigation Pane, and tap or click ____ on the shortcut menu.a. Openb. Modifyc. Change Columnsd. Resize   140. To change the size mode for a picture, tap or click the control, tap or click the Property Sheet button on the FORM DESIGN.


 11. To find all customers whose names begin with S, enter ____ in the Criteria row of the Customer Name field.a.S?b.S*c.S#d.S&   12. To find all individuals whose name is Robin or Robyn, enter ____ in the Criteria row of the appropriate column.a.Rob#nb.Rob%nc.Rob$nd.Rob?n   13. To create a parameter query, enter a parameter rather than a specific.


 21. A(n) ____ field is a field that can be computed from other fields.a. aggregateb. combinedc. totald. calculated   22. To create an update query, create a new query and then tap or click the ____ button on the DESIGN tab.a. Query Typeb. Actionc. Updated. Data Definition   23. To use the shortcut menu to create an update query, press and hold or right-click any.


 11. To insert data into an Attachment field, use the ____ command on the Attachment field’s shortcut menu.a. Insert Attachmentsb. Insert Objectsc. Manage Objectsd. Manage Attachments   12. To convert a picture from a Bitmap Image to Picture (Device Independent Bitmap), press and hold or right-click the field, tap or click ____, tap or click Convert, and then.


 Critical Thinking QuestionsCase 5-1An employee at Bavant Publishing would like to add some additional fields to the Customer table. He needs to add fields that will store the web page for a customer, as well as whether or not the customer participates in a preferred customer program. 99. What data type should.


 Modified Multiple Choice 41. When working with a report in Access, the different ways you can view the report include ____.a. Report viewb. Print Previewc. Design viewd. Layout view   42. For both grouping and sorting, there is a More button that you can tap or click if you need to specify additional options. The options you then could.


 31. You can include ____ in calculations to indicate which calculation should be done first.a.curly braces b.brackets < >c.parentheses ( )d.slashes //   32. To change the caption for a field in a query, click the field in the design grid, click the ____ button on the Design tab, click the Caption box,.


 31. To change the Tab Stop property for a control, select the control, tap or click the ____ button on the FORM DESIGN TOOLS DESIGN tab, and change the value of the Tab Stop property from Yes to No.a. Tabb. Orderc. Arrangementd. Property Sheet   32. To change the tab order in which fields are encountered on a.


 91. In ____________________ files, the width of any field is the same on every record.  92. The type of join that finds records from both tables that have identical values in matching fields is called a(n) ____________________ join.  93. The ____________________ is an Access tool that helps you create complex expressions.  94. The ____________________ function finds the.


 Modified Multiple Choice 41. The special criteria that can be used in queries are ____.a.ANDb.INCLUSIVEc.BETWEENd.IN    42. In the accompanying figure, Amount Paid is the ____ key.a.majorb.primary sortc.minord.secondary sort   43. In the accompanying figure, Book Rep Number is the ____ key.a.majorb.minorc.primary sortd.secondary sort   44. The arithmetic symbols for use in query calculations are ____.a.asterisk (*)b.ampersand (&)c.slash (/)d.question mark (?)   45. For.


 61. When you sort data, duplicates are not included.a.Trueb.False   62. To create a top-values query, use the Top Values box on the DESIGN tab to change the number of records to be included from All to the desired number.a.Trueb.False   63. Joining tables in a query creates an ad hoc relationship, that is, a relationship between.


61. When you sort data, duplicates not included.a.Trueb.False62. To create a top-valuesComputer Science

 163. Rows in a datasheet may be different sizes.a. Trueb. False   164. When you insert data in an OLE field, you either can create a new object or insert an already created object in the field.a. Trueb. False   165. Only pictures that have been created in Microsoft Drawing can be inserted into OLE fields in Access.a. Trueb. False   166. When data, such as.


 51. Rows in a datasheet may be different sizes.a. Trueb. False   52. When you insert data in an OLE field, you either can create a new object or insert an already created object in the field.a. Trueb. False   53. Only pictures that have been created in Microsoft Drawing can be inserted into OLE fields in Access.a. Trueb. False   54. When data, such as.


 81. To create a lookup field, select ____________________ from the menu of available data types.  82. If you plan to move your data to SQL Server at a later date, do not use ____________________ fields.  83. To create a multivalued field, create a(n) ____________________ field being sure to check the Allow Multiple Values check box.  84. A(n).


 81. To find all customers whose names begin with Sr, enter ____________________ as the criterion for the Customer Name field.  82. ____________________ are symbols that represent any character or combination of characters.  83. The ____________________ wildcard represents any collection of characters.  84. The ____________________ wildcard represents any individual character.  85. A(n) ____________________ query is a query that prompts for.


 Critical Thinking QuestionsCase 4-1 An employee at Bavant Publishing has created the report shown in the accompanying figure but needs some assistance in adding subtotals and grand totals. Bavant also would like some way to identify customers easily who have a current due amount of zero. 99. How can the employee add subtotals.


 11. The ____ aggregate function finds the smallest value.a. Smallestb. Minc. TinyIntd. Least   12. The ____ aggregate function finds the largest value.a. Mostb. Largestc. Maxd. Grand   13. To add totals or other statistics to a report, use the ____ button on the DESIGN tab.a. Aggregateb. Statisticsc. Sumd. Totals   14. To display the Conditional Formatting Rules Manager dialog box, tap or click the ____ button on the FORMAT tab.a. IFb. Conditional Formattingc. Formatd. Condition   15. To.


11. The ____ aggregate function finds the smallest value.a. Smallestb. Minc. TinyIntd. LeastComputer Science

 71. A multilookup field is a field that contains more than one value. ____________________  72. A default value is a value that Access will display on the screen in a particular field before the user begins adding a record. ____________________  73. To display the Total row in a datasheet, tap or click the Sum button.


1. If a SECURITY WARNING appears when you open a database, tap or click the ____ option button.a. Customizeb. Enable Contentc. Securityd. Unlock   2. To create a split form, select the table in the Navigation Pane, tap or click CREATE on the ribbon, tap or click the ____ button on the CREATE tab to display a menu,.


   87. On a custom form, such as that shown in the accompanying figure, ____________________ controls have attached labels that typically display the name of the field that supplies the data for the control.  88. When working with a form, such as that shown in the accompanying figure, there are three different ways to.


 71. To add totals to the Amount Paid column in a report, tap or click the Aggregate button on the DESIGN tab. ___________________  72. A control layout consists of a selection of colors and fonts for the various sections in a report or form. ___________________  73. A report that includes the group calculations such as.


1. The ____ data type can store up to a gigabyte of text.a. Variableb. Attachmentc. VarChard. Long Text   2. To modify the design of a table, press and hold or right-click the table in the Navigation Pane, and click ____ on the shortcut menu.a. Modify Tableb. Change Tablec. Design Viewd. Modify View   3. To use the Input Mask Wizard, select the Input Mask.


 31. ____ allows you to make changes, but it does not show you the actual form.a. Form viewb. Layout viewc. Design viewd. Screen view   32. A(n) ____ layout arranges controls vertically with the labels to the left of the control.a. arrangedb. stackedc. formattedd. vertical   33. A(n) ____ layout arranges controls horizontally with the labels across the top, typically in the Form Header section.a. arrangedb. horizontalc. tabulard. top.


 31. If the Customer Number field in a record always should display the three characters in the customer number in uppercase, then the correct format for this field is ____.a.    32. To save validation rules, default values, and formats, tap or click the Save button on the ____ to save the changes.a. HOME tabb. status.


1. ____ shows the report on the screen but also allows you to make changes to the report.a. Print Previewb. Layout viewc. Report viewd. Design view   2. ____ shows the report as it will appear when printed.a. Report viewb. Layout viewc. Design viewd. Print Preview   3. To specify grouping and sorting for a report, tap or click the ____ button on the DESIGN.


 21. To change the background color of a form, you can use the ____ button on the FORM DESIGN TOOLS FORMAT tab.a. Background Colorb. Colorc. Filld. Format   22. To use the shortcut menu to change the background color of a form, press and hold or right-click the form and select the ____ command on the shortcut menu.a. Backgroundb. Formatc. Back.


 81. You can enter data in a long text field using the ____________________ dialog box.  82. To insert data into an OLE Object field, you use the ____________________ command on the OLE Object field’s shortcut menu.  83. To insert data into an Attachment field, use the ____________________ command on the Attachment field’s shortcut menu.  84. To insert.


 Modified Multiple Choice 153. A field with the Attachment data type can contain ____.a. Word documentsb. Excel spreadsheetsc. Picturesd. Boolean operators   154. You can use the ____ data type for a Picture field.a. OLE Objectb. Short Textc. Long Textd. Attachment   155. An OLE Object field can store ____.a. video clipsb. Access tablesc. soundd. pictures   156. A field with the Hyperlink data type can contain links to ____.a. web pagesb. Office documentsc. email addressesd. fields.


 11. To clear a filter, tap or click the ____ button on the HOME tab and then tap or click Clear All Filters.a. Filterb. Removec. Advancedd. Select   12. To use a common filter to find only those customers whose city begins with G, tap or click the arrow to the right of the field name and point.


 Critical Thinking QuestionsCase 3-1Bavant Publishing has decided to add some additional validation rules to the Customer table shown in Design view in the accompanying figure. They have asked you to create these validation rules.  99. Because many of the customers that Bavant Publishing services are located in Pennsylvania, management would like to.


 Modified Multiple Choice 41. A field with the Attachment data type can contain ____.a. Word documentsb. Excel spreadsheetsc. Picturesd. Boolean operators   42. You can use the ____ data type for a Picture field.a. OLE Objectb. Short Textc. Long Textd. Attachment   43. An OLE Object field can store ____.a. video clipsb. Access tablesc. soundd. pictures   44. A field with the Hyperlink data type can contain links to ____.a. web pagesb. Office documentsc. email addressesd. fields.


 71. To include all fields in the design grid, double-click the question mark (?) in the field list.  ____________________  72. Wildcards are symbols that represent any character or combination of characters. ____________________  73. A summary function is a function that performs some mathematical function against a group of records. ____________________  74. A crosstab query calculates a statistic for.


 119. In the accompanying figure, the rows have been resized. To resize a row so that more data can appear, press and hold or right-click the record selector, and tap or click ____ to change the row spacing.a. Heightb. Row Spacingc. Row Heightd. Size   120. To undo changes to the row height, press and hold or right-click.


 51. A query that prompts for input whenever it is run is a dialog query.a.Trueb.False   52. To create a parameter query that will prompt users to enter a city name as input, place as the criterion in the City field.a.Trueb.False   53. To enter a number in a criterion, type the number without any.


   91. To open the Relationships window in the accompanying figure, tap or click the _________________________ button on the DATABASE TOOLS tab.  92. To add the Book Rep and Customer tables to the Relationships window shown in the accompanying figure, tap or click the Add button in the ___________________ dialog box.  93. The relationship in the.


 Modified Multiple Choice 41. Maintaining a database can include ____.a. filtering recordsb. changing the appearance of a datasheetc. adding new recordsd. changing the data for existing records   42. You can add a record to a table by ____.a. tapping or clicking the New (blank) record button on the Navigation barb. pressing CTRL+PLUS SIGN (+)c. tapping or clicking the New buttond. pressing the.


Modified Multiple Choice41. Maintaining a database can include ____.a. filtering recordsb. changing theComputer Science

 149. The condition, ____, entered in the Criteria row of a long text field in a query window would retrieve all records where the long text field had any mention of education.a. *educationb. ?educationc. *education*d. ?education?   150. To create a simple form with a datasheet, select the table that is the “one” part of a one-to-many relationship.


 Critical Thinking QuestionsCase 2-1Bavant needs to gather some additional statistics on its customers. An employee at Bavant has created an initial query as shown in the accompanying figure that calculates the average amount paid. The employee is unsure what aggregate functions to use for additional calculations. 99. Which aggregate function will find.


Critical Thinking QuestionsCase 2-1Bavant needs to gather some additional statisticsComputer Science

 51. The contents of the Page Header section print once at the top of each page and typically contain the column headings.a. Trueb. False   52. The contents of the Report Footer section print once at the bottom of each page and often contain a date and a page number.a. Trueb. False   53. Once you decide on a general report.


 129. To create a form in Design view, select the table for the form, tap or click CREATE on the ribbon, and then tap or click ____ on the CREATE tab.a. Design Viewb. Form Designc. Blank Formd. New Form   130. To display a field list in Design view, tap or click the ____ button on the FORM.


1. To create a new query in Design view, tap or click CREATE on the ribbon to display the CREATE tab and then tap or click the ____ button to create a new query.a.Queryb.Design Viewc.Query Designd.Select Query    2. In the accompanying figure, the lower pane in the window where you enter criteria is.


 91. To add a title to a form, tap or click the ____________________ button on the FORM DESIGN TOOLS DESIGN tab.  92. To add a Form Header section to a form, press and hold or right-click anywhere on the form background and tap or click ____________________ on the shortcut menu.  93. The best size mode.


 21. To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.a.Nob.Yesc.Offd.On    22. The accompanying figure illustrates using a query to ____ tables; that is, to find records in two tables that have identical values in matching fields.a.combineb.concatenatec.interleaved.join   23. In the accompanying figure, the ____ line between matching.


 61. You can use the asterisk (*) wildcard in a filter but not the question mark (?) wildcard.a. Trueb. False   62. You can convert a Number field to a Currency field but you cannot convert a Currency field to a Number field.a. Trueb. False   63. A lookup field allows the user to select from a list of values when.


 81. When the data in a report is grouped, the contents of the ___________________ section are printed before the records in a particular group.  82. When the data in a report is grouped, the contents of the ___________________ section are printed after the group.  83. ___________________ are objects that display data and perform actions. They.


 61. You can use the filter buttons in the Sort & Filter group on the Home tab to filter records in a report.a. Trueb. False   62. To adjust margins or change the page orientation of a report, open the report in Layout view and click the ARRANGE tab.a. Trueb. False   63. You cannot use the Report Wizard to create.


 21. A ____ consists of a selection of colors and fonts for the various sections in a report or form.a. templateb. stylec. themed. persona   22. To add a title to a report, tap or click CREATE on the ribbon and then tap or click the ____ button on the DESIGN tab.a. Add Titleb. Add Headerc. Titled. Header   23. To find themes that are.


 Critical Thinking QuestionsCase 1Min has to give a PowerPoint presentation about climate change during his science class later today. 54. While on the bus on his way to class, Min remembers a slide he wants to add. What feature of Office 365 allows him to open the PowerPoint presentation on his smartphone,.


 51. Looking for the customer whose number is PLI22 is an example of searching.a. Trueb. False   52. You can search for a record in Form view but not in Datasheet view.a. Trueb. False   53. To open a form in Form view from the Navigation Pane, press and hold or right-click the form and tap or click Form View on.

See more: Fernanda Gómez: Quién Es La Esposa De Canelo Alvarez Mama De Su Hija


 109. Button on the FORM DESIGN TOOLS DESIGN tab that allows you to change the special effect for a label.  110. Key or key combination that will move from the subform back to the last field in the main form.  111. Button on the CREATE tab that creates a new form in Design view.  112. Key or.