1 of 25Access will always give you step-by-step instructions to help you fix err

1 of 25Access will always give you step-by-step instructions to help you fix errors in formulas.TrueFalseQuestion2 of 25Which of the following is not an argument used in the PMT function?RateTotal_dueTypeFuture_valueQuestion3 of 25Which of the following cannot be included on a form?Drop-down listCheck boxButtonSub reportQuestion4 of 25What type of query will allow you to see statistics by category?Update queryStatistical queryDelete queryTotals queryQuestion5 of 25On a form the text box and its label would be considered two different controls.TrueFalseQuestion6 of 25The Expression Creator tool helps you create complex expressions.TrueFalseQuestion7 of 25The easiest way to find information is to search the table directly.TrueFalseQuestion8 of 25Which of the following is a popular label-producing company?Easy LabelsOkidataMakeIt LabelsAveryQuestion9 of 25What punctuation do you use to separate the arguments in a function?;:,.Question10 of 25You cannot prevent a record from being deleted in Access.TrueFalseQuestion11 of 25What type of form control do you normally use to display data?ButtonLabelText boxDataQuestion12 of 25When you want to add a condition to a Totals query, which option do you select from the Totals row list?WhenWhereGroupConditionQuestion13 of 25Which of the following tasks is not easily accomplished using a form?Move dataEnter dataEdit dataDelete dataQuestion14 of 25Which of the following is not a report view?Design viewLayout viewSQL viewReport viewQuestion15 of 25Which form (that includes the existing fields from the data source) can you create with just one click?Stacked LayoutForm WizardTabular LayoutBlank FormQuestion16 of 25A Totals query allows you to see only the results of aggregate functions, not the detail.TrueFalseQuestion17 of 25What allows you to summarize data by the values of a field?Adding a summarizing fieldAdding an update fieldAdding the proper calculated fieldAdding grouping to a queryQuestion18 of 25Access refers to aggregate functions as which of the following?Whole column functionsTotalsComplex functionsSumsQuestion19 of 25Which view do you normally use for data entry?Design viewSQL viewForm viewLayout viewQuestion20 of 25Most forms allow you to enter data into more than one record at a time.TrueFalseQuestion21 of 25Normally, when you Print Preview a report, the program will generate a report with how many pages?Only the first pageAll the pages only if they will all fit on the screen at one timeOnly the first two pagesAll the pagesQuestion22 of 25Which of the following is not true when designing a report or form?You should provide a visual separation between the primary key and the rest of the form.All text boxes should be the same length for consistency of look.Adding a bright color draws attention to a field.Changing the color of a border adds contrast.Question23 of 25The sort order in a report’s source overrides any sort order applied to the report.TrueFalseQuestion24 of 25What can the phrase “Please Excuse my Dear Aunt Sally” help you remember?Naming convention for cell rangesThe various printing options available in ExcelThe order of operationsHow to do date calculationsQuestion25 of 25Access will identify logical errors in calculated fields.TrueFalse1 of 25Access will always give you step-by-step instructions to help you fix errors in formulas.TrueFalse2 of 25Which of the following is not an argument used in the PMT function?RateTotal_dueTypeFuture_value3 of 25Which of the following cannot be included on a form?Drop-down listCheck boxButtonSub report4 of 25What type of query will allow you to see statistics by category?Update queryStatistical queryDelete queryTotals query5 of 25On a form the text box and its label would be considered two different controls.TrueFalse6 of 25The Expression Creator tool helps you create complex expressions.TrueFalse7 of 25The easiest way to find information is to search the table directly.TrueFalse8 of 25Which of the following is a popular label-producing company?Easy LabelsOkidataMakeIt LabelsAvery9 of 25What punctuation do you use to separate the arguments in a function?;:,.10 of 25You cannot prevent a record from being deleted in Access.TrueFalse11 of 25What type of form control do you normally use to display data?ButtonLabelText boxData12 of 25When you want to add a condition to a Totals query, which option do you select from the Totals row list?WhenWhereGroupCondition13 of 25Which of the following tasks is not easily accomplished using a form?Move dataEnter dataEdit dataDelete data14 of 25Which of the following is not a report view?Design viewLayout viewSQL viewReport view15 of 25Which form (that includes the existing fields from the data source) can you create with just one click?Stacked LayoutForm WizardTabular LayoutBlank Form16 of 25A Totals query allows you to see only the results of aggregate functions, not the detail.TrueFalse17 of 25What allows you to summarize data by the values of a field?Adding a summarizing fieldAdding an update fieldAdding the proper calculated fieldAdding grouping to a query18 of 25Access refers to aggregate functions as which of the following?Whole column functionsTotalsComplex functionsSums19 of 25Which view do you normally use for data entry?Design viewSQL viewForm viewLayout view20 of 25Most forms allow you to enter data into more than one record at a time.TrueFalse21 of 25Normally, when you Print Preview a report, the program will generate a report with how many pages?Only the first pageAll the pages only if they will all fit on the screen at one timeOnly the first two pagesAll the pages22 of 25Which of the following is not true when designing a report or form?You should provide a visual separation between the primary key and the rest of the form.All text boxes should be the same length for consistency of look.Adding a bright color draws attention to a field.Changing the color of a border adds contrast.23 of 25The sort order in a report’s source overrides any sort order applied to the report.TrueFalse24 of 25What can the phrase “Please Excuse my Dear Aunt Sally” help you remember?Naming convention for cell rangesThe various printing options available in ExcelThe order of operationsHow to do date calculations25 of 25Access will identify logical errors in calculated fields.TrueFalse

You may also like