Business Computer Applications
Exam Questions
Course Introduction
Business Computer Applications introduces students to essential computer concepts and software tools commonly used in the business environment. The course covers fundamental topics such as word processing, spreadsheets, presentation software, and databases, emphasizing practical skills for effective communication, data analysis, and decision-making. Students will gain hands-on experience with industry-standard applications, develop proficiency in creating professional documents, managing information, and solving business problems through technology. By the end of the course, students will understand how to leverage computer applications to enhance productivity, collaborate effectively, and support business operations across various industries.
Recommended Textbook
Exploring Microsoft Excel 2013 Comprehensive 1st Edition by Mary Anne Poatsy
Available Study Resources on Quizplus 22 Chapters
1288 Verified Questions
1288 Flashcards
Source URL: https://quizplus.com/study-set/1852
Page 2
Chapter 1: Introduction to Access: Hands-On-Exercise
Videos
Available Study Resources on Quizplus for this Chatper
20 Verified Questions
20 Flashcards
Source URL: https://quizplus.com/quiz/37009
Sample Questions
Q1) The Filter by Selection returns:
A) only records matching the set criteria.
B) results filtered from a selected range.
C) specific query results.
D) any data with a comparison operator.
Answer: A
Q2) Which one of the following objects allows users to add data to the database?
A) Table
B) Record
C) Query
D) Form
Answer: D
Q3) What is a relationship?
A) Two Excel spreadsheets with similar data
B) A database and a spreadsheet with similar data
C) Similar queries applied to the same table
D) A connection between two tables with a common field
Answer: D
To view all questions and flashcards with answers, click on the resource link above. Page 3
Hands-On-Exercise Videos
Available Study Resources on Quizplus for this Chatper
19 Verified Questions
19 Flashcards
Source URL: https://quizplus.com/quiz/37011
Sample Questions
Q1) A primary key field CANNOT be deleted.
A)True
B)False
Answer: False
Q2) When using Datasheet view,what determines sort order when sorting more than one field?
A) The order is determined from right to left.
B) The order is determined from left to right.
C) The order is determined by the first selected field to the last selected field.
D) The order is determined by the last selected field to the first selected field.
Answer: B
Q3) To count the number of records that satisfy a query,you click the Total button and select Count in the Total row in the query grid.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above.
4
Chapter 3: Customize, analyze, and Summarize Query
Data: Hands-On-Exercise Videos Available Study Resources on Quizplus for this Chatper 15 Verified Questions 15 Flashcards
Source URL: https://quizplus.com/quiz/37013
Sample Questions
Q1) Which of the following is NOT an Access arithmetic operator?
A) ÷
B) +
C) *
D) ^
Answer: A
Q2) A(n)________ function performs a calculation on an entire column and returns a single result.
A) compound
B) aggregate
C) summary
D) abridged
Answer: A
Q3) You can use the Expression Wizard to supply fields,operators,and functions to help you create expressions.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos
Source URL: https://quizplus.com/quiz/37015
Sample Questions
Q1) You can sort the data in a form by double-clicking a field and selecting Sort A to Z or Sort Z to A.
A)True
B)False
Q2) Which of the following is NOT a form view?
A) Form
B) Edit
C) Layout
D) Design
Q3) The results of PricePerRoom: [ListPrice]/([Beds]+[Baths]+3)will appear in a column with the heading ________.
A) PricePerRoom
B) ListPrice
C) Beds
D) Baths
Q4) When Access creates a form with two related record sources,the main form is displayed with a stacked layout,while the subform with a datasheet layout.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Data Validation and Data Analysis:
Hands-On-Exercise Videos
Available Study Resources on Quizplus for this Chatper
18 Verified Questions
18 Flashcards
Source URL: https://quizplus.com/quiz/37017
Sample Questions
Q1) When creating a parameter query,you are limited to a single parameter in the Criteria row for a given field.
A)True
B)False
Q2) The table that contains the values for a lookup field CANNOT be modified.
A)True
B)False
Q3) A(n)________ allows the user to select a field value from a list of options.
A) input mask
B) lookup field
C) field property
D) data macro
Q4) When most people in a database reside in New York,you should make NY the ________ value for the State field.
A) data validation rule
B) default
C) lookup field
D) input mask
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter
6: Action and Specialized Queries:
Hands-On-Exercise Videos
Study Resources on Quizplus for this Chatper 14 Verified Questions 14 Flashcards
Source URL: https://quizplus.com/quiz/37019
Sample Questions
Q1) You would use a(n)________ query to remove the records of former employees from a table.
A) erase
B) dispose
C) delete
D) exclude
Q2) To find the same values in a table,you would use the Find ________ Query Wizard.
A) Repeated
B) Alike
C) Matching
D) Duplicates
Q3) A(n)________ query is used to display aggregate data in a row-and-column layout.
A) summary
B) crosstab
C) action
D) outline
Q4) You CANNOT edit a crosstab query.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Advanced Forms and Reports:
Hands-On-Exercise Videos
Available Study Resources on Quizplus for this Chatper
12 Verified Questions
12 Flashcards
Source URL: https://quizplus.com/quiz/37021
Sample Questions
Q1) The expression IIf(IsNull([ClosedDate]),"Open","Closed")displays ________.
A) Closed when the ClosedDate field has no value and Open otherwise
B) Open when the ClosedDate field has no value and Closed otherwise
C) Closed when the ClosedDate field has no value and nothing otherwise
D) Open when the ClosedDate field has no value and nothing otherwise
Q2) By using a ________,you can create a form that displays records from two related tables.
A) linked form
B) subordinate form
C) subform
D) mini-form
Q3) A combo box is used to display a drop-down menu containing a list of options from which users choose a single option.
A)True
B)False
Q4) Form headers or report footers are examples of form or report ________.
A) subdivisions
B) divisions
C) segments
D) sections
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Get Connected: Hands-On-Exercise Videos
Available Study Resources on Quizplus for this Chatper
17 Verified Questions
17 Flashcards
Source URL: https://quizplus.com/quiz/37023
Sample Questions
Q1) When preparing an Excel spreadsheet to be imported into an Access database,the first row of the spreadsheet must have column headings that are recognized as field names by Access.
A)True
B)False
Q2) When an Access query is exported to Word,it is saved as a(n)________ file.
A) RTF
B) DOCX
C) PDF
D) XPS
Q3) You can export an Access query to an Excel spreadsheet,but you CANNOT export a report.
A)True
B)False
Q4) When you ________ an external table,you connect to the table without actually importing the table's data.
A) link
B) embed
C) join
D) associate
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Fine-Tuning the Database: Hands-On-Exercise
Videos
Available Study Resources on Quizplus for this Chatper
17 Verified Questions
17 Flashcards
Source URL: https://quizplus.com/quiz/37025
Sample Questions
Q1) If you lose the password of an encrypted database,you can contact Microsoft to unlock the database.
A)True
B)False
Q2) A primary key that consists of more than a single field is called a ________ key.
A) merged
B) compound
C) composite
D) combined
Q3) A digitally signed database requires a password to open it.
A)True
B)False
Q4) Which normal form requires that all non-key fields are functionally dependent on the entire primary key?
A) First Normal Form
B) Second Normal Form
C) Third Normal Form
D) Fourth Normal Form
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 10: Using Macros and SQL in Access:
Hands-On-Exercise Videos
Available Study Resources on Quizplus for this Chatper
16 Verified Questions
16 Flashcards
Source URL: https://quizplus.com/quiz/37027
Sample Questions
Q1) A named macro is displayed as an object in the Navigation Pane.
A)True
B)False
Q2) Which of the following is NOT a SQL SELECT keyword?
A) WHO
B) WHERE
C) FROM
D) ORDER BY
Q3) Which of the following events CANNOT be used as a trigger for a macro?
A) On Click
B) Before Change
C) After Update
D) While Open
Q4) You can use the Macro ________ to edit a macro.
A) Analyzer
B) Documenter
C) Designer
D) Wizard
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 11: Introduction to Access: Finding Your Way
Through an Access Database
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/37008
Sample Questions
Q1) Access' ________ feature creates a duplicate copy of a database.
A) Back Up Database
B) RDBMA
C) Compact and Repair
D) Relationship
Q2) A primary key:
A) must include letters.
B) must contain a unique value for each record within a table.
C) has the same value for all records in a relational database.
D) is a unique record within a relational database.
Q3) What is an Access Web app?
Q4) Information is what is typically entered into a database.Data is the finished product of the database.
A)True
B)False
Q5) The process of saving in Access is nearly the same as it is in other Microsoft Office applications.
A)True B)False
Q6) Describe comparison operators in Access. Page 13
To view all questions and flashcards with answers, click on the resource link above.
Page 14
Chapter 12: Office Fundamentals and File Management:
Hands-On-Exercise Videos
Available Study Resources on Quizplus for this Chatper
30 Verified Questions
30 Flashcards
Source URL: https://quizplus.com/quiz/37028
Sample Questions
Q1) Sizing,spacing,color,and boldfacing are examples of font attributes.
A)True
B)False
Q2) When using an Office 2013 application,the title bar displays the current file and which application is being used.
A)True
B)False
Q3) The Save command allows you to name a file and determine the location where it is stored.
A)True
B)False
Q4) The blank areas at the top,bottom,left,and right of a document are the ________.
A) borders
B) boundaries
C) Decrease Decimal
D) margins
Q5) SkyDrive is the default location for saving a file created in an Office 2013 application.
A)True
B)False
Page 15
To view all questions and flashcards with answers, click on the resource link above.
Chapter 13: Office Fundamentals and File Management
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/37029
Sample Questions
Q1) In Office 2013,the Help button is located on the Ribbon.
A)True
B)False
Q2) When dragging a group of tiles on the Windows 8 Start screen,a light gray vertical bar displays to indicate where the new group will be located.
A)True
B)False
Q3) What does clicking the pushpin next to each file name on the Recent Documents list do?
A) The file will remain on the Recent Documents list for one full week.
B) The file will remain on the Recent Documents list indefinitely.
C) The file can be "pinned" to a particular folder that you designate.
D) The file is available to be "pinned" to the Quick Access Toolbar.
Q4) By default,after you click the SkyDrive tile on the Windows 8 Start screen,which of the following items will NOT display?
A) Documents
B) Pictures
C) Public Shared
D) Libraries
To view all questions and flashcards with answers, click on the resource link above. Page 16
Chapter 14: Tables and Queries in Relational Databases:
Designing Databases and Extracting Data
Available Study Resources on Quizplus for this Chatper
90 Verified Questions
90 Flashcards
Source URL: https://quizplus.com/quiz/37010
Sample Questions
Q1) A relationship cannot be established between two tables unless a primary key has been set in the first table.
A)True
B)False
Q2) Describe a wildcard in Access.Mention at least two wildcards that are available in Access.
Q3) You can set a(n)________ to create a label more readable than a field.
Q4) A(n)________ operator,such as the greater than or less than symbol,can be used in a query criterion to limits the results produced by the query.
A) operand
B) wildcard
C) comparison
D) delimiter
Q5) A(n)________ relationship requires a table called a junction table.
Q6) A(n)________ relationship consists of a primary key value in a primary table and numerous foreign key values in a related table.
Q7) Spaces should be included in field names.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 17
Chapter 15: Customize, analyze, and Summarize Query
Data: Creating and Using Queries to Make Decisions
Available Study Resources on Quizplus for this Chatper
95 Verified Questions
95 Flashcards
Source URL: https://quizplus.com/quiz/37012
Sample Questions
Q1) A constant is a value that remains the same in an expression.
A)True
B)False
Q2) A(n)________ contains an additional row in the query design grid and displays aggregate data when the query is run.
Q3) An expression or integer value specifying total number of payments in a loan is the ________ argument in the PMT function.
A) rate
B) num_periods
C) present_value
D) future_value
Q4) Which of the following is NOT a Pmt function argument?
A) rate
B) present_value
C) future_value
D) loan_payment
Q5) The ________ aggregate functions return the item with the lowest value.
Q6) PEMDAS is a mnemonic device used to remember the ________.
Q7) Explain what a totals query is and the steps necessary to create one.
Q8) Function arguments are separated by ________. Page 18
To view all questions and flashcards with answers, click on the resource link above.
Page 19
Chapter 16: Creating and Using Professional Forms and Reports:
Moving Beyond Tables and Queries
Available Study Resources on Quizplus for this Chatper
96 Verified Questions
96 Flashcards
Source URL: https://quizplus.com/quiz/37014
Sample Questions
Q1) Form view allows changes to the data and layout.
A)True
B)False
Q2) To sort fields in a report,click Group & Sort in the:
A) Fields group on the DESIGN tab.
B) Grouping & Totals group on the DESIGN tab.
C) Fields group on the CREATE tab.
D) Grouping & Totals group on the CREATE tab.
Q3) All of the following are report creation tools EXCEPT:
A) Report Design.
B) Report Wizard.
C) Report Layout.
D) Blank Report.
Q4) The ________ view is used to add,edit,and delete data in a form,but it cannot be used to change the layout and design of the form.
A) Insert
B) Edit
C) Modify
D) Form
Q5) ________ is used to see exactly what a report will look like when it is printed.
To view all questions and flashcards with answers, click on the resource link above. Page 20
Chapter 17: Data Validation and Data Analysis: Reducing
Errors and Extracting Better Information
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/37016
Sample Questions
Q1) [Enter city] on the criteria line of a query is an example of the criteria in a parameter query.
A)True
B)False
Q2) When you use the ________ operator,each criterion must be true for the compound criterion to be true.
A) Like
B) Between
C) And
D) Not
Q3) When using the Lookup Wizard to create a lookup field,Access creates a hidden relationship between two tables-the table that contains the lookup field and the table that holds the options.
A)True
B)False
Q4) ________ is the correct syntax for the Round function.
A) Round(expression, precision)
B) Round(expression)
C) Round(expression, truepart, falsepart)
D) Round(expression, interval)
To view all questions and flashcards with answers, click on the resource link above. Page 21
Chapter 18: Action and Specialized Queries: Moving Beyond the Select Query
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/37018
Sample Questions
Q1) A(n)________ query can be used to archive older records that need to be stored outside of the current table.
A) make table
B) update
C) delete
D) append
Q2) Which query identifies multiple instances of the same information in a table?
A) Find duplicates
B) Crosstab
C) Append
D) Make table
Q3) Choosing the wrong matched field in an unmatched query will cause you to query incorrect information.
A)True
B)False
Q4) It is usually better to enter the value of zero rather than have a null value in a field.
A)True
B)False
Q5) What are the four types of action queries?
To view all questions and flashcards with answers, click on the resource link above. Page 22
Chapter 19: Advanced Forms and Reports: Moving Beyond the Basics
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/37020
Sample Questions
Q1) What will cause a group to print on a separate page?
Q2) Which view do you use to modify lines or rectangles?
A) Design view
B) Layout view
C) Datasheet view
D) Form or Report view
Q3) If you would like to include a mathematical equation in a report,you would include a(n)________.
Q4) To move a text box label,what action must you take?
A) Click the Tabular Layout in the Table group of the Arrange tab while both the label and text box controls are selected.
B) Click the Tabular Layout in the Arrange group when the label is selected.
C) Click the Tabular Layout in the Arrange group when the text box is selected.
D) Click the Tabular Layout in the Arrange group of the Table group while the label and text box are selected.
Q5) When a relationship exists between two tables,the Form wizard automatically includes a(n)________.
Page 23
Q6) What is the difference between a form header and a page header?
Q7) How can you add emphasis to a form or report?
To view all questions and flashcards with answers, click on the resource link above.
Chapter 20: Get Connected: Exchanging Data Between
Access and Other Applications
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/37022
Sample Questions
Q1) A linked file opens in Access even though the data resides in an external Excel file.
A)True
B)False
Q2) What is the main reason for exporting data to Excel instead of Word?
A) You are not able to analyze the data as you can in Excel.
B) The data can be manipulated the same as in Excel.
C) Charts can be made in Word just as in Excel.
D) Table information looks the same in both Word and Excel.
Q3) ________ allocate a certain number of characters for each field.
A) Fixed-length text files
B) CSV text files
C) Linked files
D) Excel tables
Q4) If you have data in Excel that you would like in an Access table,you can ________ the Excel worksheet into Access.
Q5) A hyperlink field enables you to attach multiple files of different types.
A)True
B)False
Q6) What is one of the reasons you import directly into Access from Excel?
To view all questions and flashcards with answers, click on the resource link above. Page 24
Chapter 21: Fine-Tuning the Database: Analyzing and Improving Database Performance
Available Study Resources on Quizplus for this Chatper
98 Verified Questions
98 Flashcards
Source URL: https://quizplus.com/quiz/37024
Sample Questions
Q1) The Database Documenter saves its report in a number of formats including PDF or XPS formats.
A)True
B)False
Q2) Name two situations that violate 1NF.
Q3) What do the Performance Analyzer Analysis Notes tell you?
Q4) First normal form is a table that contains no repeating groups or repeating columns.
A)True
B)False
Q5) One reason why you may not be able to create a relationship is because there may be an issue with the way you have normalized the database.
A)True
B)False
Q6) What does the Table Analyzer do?
A) Analyzes the tables in a database and normalizes them for you
B) Gives you notes and specifications recommended and then fixes them
C) Provides a brief description of potential problems and possible solutions
D) Lists three kinds of analysis results
Q7) A(n)________ database contains only the tables of a database.
To view all questions and flashcards with answers, click on the resource link above. Page 25
Chapter 22: Using Macros and SQL in Access: Advanced Techniques
Available Study Resources on Quizplus for this Chatper
97 Verified Questions
97 Flashcards
Source URL: https://quizplus.com/quiz/37026
Sample Questions
Q1) What are the two methods of programming with Access?
Q2) Which SQL statement determines how the rows will be sorted?
A) ORDER BY
B) SELECT
C) FROM
D) WHERE
Q3) All SQL statements must end with a:
A) semi-colon (;).
B) colon (:).
C) question mark (?).
D) bracket({}).
Q4) The SELECT keyword instructs Access to return the specific fields from one or more tables or queries.
A)True
B)False
Q5) Macros can be converted to VBA without having to write any complex programming code.
A)True B)False
Q6) What are the two methods for creating an embedded macro? Page 26
To view all questions and flashcards with answers, click on the resource link above. Page 27