Devry BIS245 All Quizzes Latest 2021 March

BIS245 Database Essentials for Business with Labs

Week 2 BIS245 Chapter 1 Quiz

1              Which of the following s is used to add a new record?

2              Which of the following data types is used to store the results of a calculation?

3              Which of the following should you use if you are going to apply several changes to the datasheet layout?

4              Which of the following enables you to enter, modify, delete, or view data records?

5              What is another name for a single unit of data?

6              Which of the following enables you to build or modify the basic structure or functionality of an object?

7              If the active cell is the last field of a record, which key moves to the first field of the next record in a datasheet?

8              What must you create for each of the different pieces of information you want to keep in your table?

9              When you make a change to the row height in Access, which of the following changes to the new height?

10           Which of the following describes a pre-designed database?

11           Which of the following is used to store data records?

12           In Datasheet view, which of the following keys moves the pointer to the next field?

13           Which of the following data types is used to instruct Access to insert a unique, sequential number each time a new record is added?

14           To initiate the automatic saving of data records, what must be done to the table at least once?

15           Which of the following shortcuts opens the Backstage view with the New button selected?

16           Which of the following data types is used for storing text longer than 255 characters?

17           Which of the following terms automatically adjusts the width of the column(s) to accommodate the widest entry?

18           Which of the following is a collection of related records?

19           Which of the following data types is used to attach pictures, images, and Office files?

20           In Access, what are the different parts of a database application called?

BIS245 Database Essentials for Business with Labs

Week 3 BIS245 Chapter 2 Quiz

1              Which of the following field validation rules requires the user to enter a value that is less than 5?

2              Which of the following prints a table in a database?

3              In Access, which of the following is used to relate, or connect, tables?

4              Which of the following contains a unique value for each record?

5              How is data in a relational database system organized?

6              Which of the following print options enables you to check that formatting is appropriate and to make changes to any settings before printing?

7              In Access, what are field validation rules called?

8              Which of the following field validation rules requires the user to fill in a field?

9              Which of the following options forces a user to enter data using a specific format?

10           Which of the following characters separates the parts of an input mask?

11           Which of the following print options bypasses the Print dialog box?

12           Which of the following wildcard characters does Access use in validation rules to match any number of characters?

13           Which of the following properties automatically inserts a specified value into a new record in a table?

14           Which of the following print options enables you to select different print options before sending the contents of the current object immediately to the printer?

15           Which of the following print options sends the contents of the current object immediately to the printer?

16           Which of the following properties contains the text that displays in the column header to identify a field in Datasheet view?

17           Which of the following properties controls the way a field displays in a table?

18           What can you do if you create a relationship in error?

19           Which of the following is not true when creating validation text?

20           When using wildcards in validation rules, which of the following must surround the criteria of your expression?

BIS245 Database Essentials for Business with Labs

Week 4 BIS245 Chapter 3 Quiz

1              Which of the following is used to locate data in a database?

2              Which of the following Ribbon tabs do you use to create a query?

3              Which of the following functions finds the total value of a field?

4              Which of the following functions finds a specific number of characters from the left of the field?

5              How does Access evaluate a criterion expression that just includes a criteria value?

6              Which of the following functions converts a value to uppercase?

7              Which of the following logical operators requires a record to meet at least one of the individual conditions specified to be included in the results?

8              Which of the following functions counts the number of records that have a value in the field?

9              Which of the following comparison operators means "similar to this value"?

10           Which of the following functions rounds a value?

11           How many fields can you add to the query design grid?

12           Which of the following functions performs a comparison and does one of two alternatives?

13           Which of the following logical operators requires that a record meet all the individual conditions specified in order to be included in the results?

14           What should you use to write criterion into a query?

15           Which of the following keyboard shortcuts opens the Save As dialog box?

16           Which of the following cannot be changed in Datasheet view of a query?

17           What determines the type of criterion you enter, along with the way you enter the criterion?

18           What is created when values are entered on the same Criteria row of the query design grid?

19           Which of the following should you add into a query to search for records that meet a specific value?

20           Which of the following requires you to enter the specific criteria value when you run the query?

BIS245 Database Essentials for Business with Labs

Week 5 BIS245 Chapter 6 Quiz

1              Which of the following must you use to view the expression inside a calculated control?

2              On how many dimensions does a crosstab query summarize data?

3              Which of the following would you use to conceal repeated values in a report?

4              Which of the following is not a common report modification?

5              Which of the following report sections prints the group title/value at the top of each group?

6              Which of the following Access date functions determines the difference between two dates?

7              Which of the following formatting properties of a control sets the fill color of a control?

8              Which of the following chart types is used to show data as a percentage of the whole?

9              Which of the following is inserted within another report?

10           Which of the following report sections prints page numbers or dates at the bottom of each page?

11           Which of the following chart types is used for comparisons among items or comparisons over time?

12           Which of the following font characteristics is not listed in the Property Sheet?

13           Which of the following views is not used to edit a main report?

14           Which of the following creates a new table in a database and also copies the records into the new table?

15           Which of the following formatting properties of a control sets a fixed number of decimal places to display?

16           Which of the following is used to enclose fields in a calculated expression?

17           Once you add a subreport to a main report, how does it exist?

18           Which of the following must go at the beginning of calculated expressions in Access?

19           Which of the following deletes records from a table in a database?

20           Which of the following is a tool that makes it easier to build four different types of queries?

BIS245 Database Essentials for Business with Labs

Week 6 BIS245 Chapter 4 Quiz

1              Which of the following options is the quickest way to create a form?

2              Which of the following form controls is used to perform an action such as Close Form, Open Form, Delete Record, and so on?

3              Which of the following should you use to create a report if you are short on time?

4              Which of the following creates a button and attaches all the necessary functionality to the button?

5              Which of the following form properties determines whether a form is restricted to data entry?

6              What is the default sort order for date fields?

7              Which of the view options for forms shows the completed structure of the form?

8              Which of the following grouping options groups records by the first character of a field?

9              Which of the following enables you to format only values that meet a certain condition?

10           When using multiple conditional formatting rules, which of the following statements is true?

11           What is a text box that gets its value from a field in a table?

12           Which of the following form controls is used to display or accept data for a field with a Yes/No data type?

13           Which of the following controls can print the current form, close the current form, navigate to the next record, or open another form?

14           Which of the following report layouts displays fields in one column?

15           Which of the following report views shows how the report will look in print and enable you to make modifications to the print settings?

16           Which of the following would you change in order to view a report using a landscape orientation?

17           In a report with grouping or sorting, which of the following options in the Group, Sort, and TotalPane do you select to add totals?

18           Which of the following is true about blank reports?

19           What is a text box that gets its value from an expression?

20           Which of the following options in the Group, Sort, and Total Pane calculates overall totals for all records?

BIS245 Database Essentials for Business with Labs

Week 7 BIS245 Chapter 8 Quiz

1              Which of the following provides a simple means to create and view an HTML file?

2              How is data that has been exported from Access to Word formatted in Word?

3              Which of the following field code characters informs the document that number formatting should be applied to the merge field?

4              Which of the following options is not available in the Get External Data - Text File dialog box?

5              Which of the following is not a true statement to export specific records from Access to Excel?

6              Which of the following is not a main step required to perform a mail merge?

7              Which of the following may display in Access when you import data from an Excel column that contains mixed values?

8              In HTML, which of the following defines a paragraph and is used to display text on the web page?

9              Which of the following field code characters informs the document to format a number with two decimal places?

10           Which of the following specifies the information the data source includes in the main document?

11           In a mail merge, how is the Access table or query used?

12           In HTML, which of the following is always used in an end tag?

13           Which of the following errors occurs when you attempt to add records where the primary key column contains inconsistent, missing, or duplicated data?

14           Which of the following is not true of RTF files?

15           Which of the following modifications is not made after the import process?

16           In an XML file, which of the following tells the program what version of XML is being used?

17           Which of the following is not a common error when importing into a linked table?

18           Which of the following is not typically used to create text files?

19           Which of the following is the process of getting data from an outside source into an Access database?

20           Which of the following is the starting document in a mail merge?