Computer Applications in Business
Exam Questions
Course Introduction
Computer Applications in Business explores the practical use of computer technology to enhance efficiency, productivity, and decision-making within the business environment. This course covers foundational concepts in information systems, word processing, spreadsheets, databases, presentation software, and basic business analytics. Students learn how to leverage common business software and online tools to create reports, analyze data, manage information, and support business operations. Emphasis is placed on developing digital literacy, effective communication through technology, and understanding ethical considerations in the use of computer applications for business purposes.
Recommended Textbook
Microsoft Office Access 2013 Complete In Practice 1st Edition by Randy Nordell
Available Study Resources on Quizplus
10 Chapters
996 Verified Questions
996 Flashcards
Source URL: https://quizplus.com/study-set/2881
Page 2
Chapter 1: Creating a Database and Tables
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/57328
Sample Questions
Q1) Which of the following have full access to create,edit,and delete files and folders in the group?
A) owners
B) co-owners
C) members
D) both A and B
Answer: D
Q2) Which of the following must be true in order to access your SkyDrive account from Windows?
A) The Save As dialog box must be displaying.
B) The Open dialog box must be displaying.
C) You must be logged into your Microsoft account.
D) none of the above
Answer: C
Q3) The difference when printing in Office Web Apps and in Office 2013 is that Office Web Apps creates a PDF file.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above.
Page 3
Chapter 2: Using Design View, Data Validation, and Relationships
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/57329
Sample Questions
Q1) In what ways can you customize the Navigation pane and how can it be used as a security pane?
Answer: The Navigation pane displays the objects in your database.It is organized into categories and groups.The default settings in Access show all of the objects grouped by the type of object.You can customize the Navigation pane to make a database more efficient for the users.To do this,you first create categories and groups that reflect the needs of the user.Next,you organize the database objects into the groups.You can limit the number of objects a user sees,which helps users find needed objects more quickly.While not designed as a security mechanism,a customized Navigation pane can also add a degree of security and protection to the database by hiding objects you don't want users to accidentally modify or delete.For example,a user is likely to only need to open the main form in a database that contains both a main form and a subform.In these cases,you can hide the subform object from the user.
Q2) In ERD terminology,what is another name for relationship's type?
A) circle symbol
B) cardinality
C) single line symbol
D) modality
Answer: B
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Creating and Using Queries
Available Study Resources on Quizplus for this Chatper
99 Verified Questions
99 Flashcards
Source URL: https://quizplus.com/quiz/57330
Sample Questions
Q1) One of the simplest ways to create and view an HTML file is in a text editor,such as Notepad.
A)True
B)False
Answer: True
Q2) The process for importing a fixed-width text file is the same as the process for importing a delimited text file.
A)True
B)False
Answer: False
Q3) Which of the following may display in Access when you import data from an Excel column that contains mixed values?
A) #Num!
B) *****
C) 11111
D) Error!
Answer: A
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Creating and Using Forms and Reports
Available Study Resources on Quizplus for this Chatper
99 Verified Questions
99 Flashcards
Source URL: https://quizplus.com/quiz/57331
Sample Questions
Q1) Which of the following rules should you consider when adding a calculated control to a form?
A) Enter the expression directly into the Control Source property.
B) If you need more space to enter the expression,you can open the Expression Builder or Zoom window.
C) Assign a name to the control in the Name property.
D) all of the above
Q2) Which of the following statements is true about modifying a navigation form?
A) When a navigation form is created,it includes an Auto_Header()label added into the Form Header section.
B) Edit the contents of the Caption property to change the wording of the label at the top of the navigation form.
C) By default,the navigation tab displays as a rectangle.
D) all of the above
Q3) The #Error error means that you have used a name for a field,control,form,or function that is not valid.
A)True
B)False
Q4) When might you want to integrate data validation with form controls?
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Templates, Advanced Relationships, and Macros
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/57332
Sample Questions
Q1) Describe some situations in which you may end up with duplicated data.
Q2) In a concatenation formula,how would you insert a comma and a blank space between two fields?
A) &" "&
B) &","&
C) =","&
D) [","]
Q3) Which of the following can the data fields for a report come from?
A) reports
B) queries
C) tables
D) both B and C
Q4) Use the Subform/ Subreport button to launch the SubReport Wizard to add the subreport.
A)True
B)False
Q5) An action query makes a temporary change to the data in the database and the Undo button is available to reverse the action.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Creating Advanced Queries and Reports and Using SQL
Available Study Resources on Quizplus for this Chatper
99 Verified Questions
99 Flashcards
Source URL: https://quizplus.com/quiz/57333
Sample Questions
Q1) The join type property determines how to match the data in the two related tables. A)True
B)False
Q2) A many-to-many relationship exists when one row of data in one table can be associated with many rows of data in a second table.
A)True
B)False
Q3) When building a macro,which of the following must you do?
A) decide what event will cause the macro to execute
B) plan out the logic behind the steps,or tasks,the macro will perform
C) determine the type of macro needed and the best way to build the macro
D) all of the above
Q4) Which of the following lets you write and edit he content of all macros?
A) program flow statement
B) Action
C) Comment
D) Macro Builder
Q5) Why are junction tables important?
Q6) When working with macros,what is an event? Provide a few examples.
To view all questions and flashcards with answers, click on the resource link above. Page 8
Chapter 7: Creating Advanced Forms
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/57334
Sample Questions
Q1) Which of the following options in the Group,Sort,and Total pane calculates overall totals for all records?
A) Select the field and type of calculation
B) Show grand totals
C) Show group totals as percent of grand total
D) Show in header or footer section
Q2) Which of the following would you want to use in a report to include all properties from the same city together in a real estate database?
A) sorting
B) conditional formatting
C) a split form
D) grouping
Q3) The Command Button Wizard creates a button and attaches all of the necessary functionality to the button.
A)True
B)False
Q4) You can have a maximum of one conditional formatting rule in a report.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Integrating Applications
Available Study Resources on Quizplus for this Chatper
99 Verified Questions
99 Flashcards
Source URL: https://quizplus.com/quiz/57335
Sample Questions
Q1) What is a calculated field? Where are calculated fields stored?
Q2) To create a new query,use the Create tab.
A)True
B)False
Q3) How does Access evaluate a criterion expression that just includes a criteria value?
A)equal to
B)not equal to C)equal to or greater than D)equal to or less than
Q4) Which of the following is a valid criterion for the Long Text data type?
A)hello
B)"hello"
C)*hello*
D)#hello#
Q5) When entering a criterion expression,the IntelliSense tool may suggest a list of possible values.
A)True
B)False
Q6) Explain what you know about using wildcards in a parameter query.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Designing and Managing Databases
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/57336
Sample Questions
Q1) Which of the following input mask characters requires a user to enter a letter?
A) 0
B) L
C) A
D) a
Q2) Which of the following number data types stores numbers from 0 to 255?
A) Byte
B) Integer
C) Long Integer
D) Decimal
Q3) Which of the following relationships describes one row of data in Table A being associated with only one row of data in Table B?
A) one-to-one
B) one-to-many
C) many-to-many
D) none of the above
In a one-to-one relationship,one row of data in Table A is associated with only one row of data in Table
Q4) What steps are required to design a relational database?
Q5) What is the Caption property and when might you want to use it?
11
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Customizing Access and Using Skydrive and Office Web Apps
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/57337
Sample Questions
Q1) Which of the following is used to store data records?
A) report
B) form
C) query
D) table
Q2) Which of the following is a field that contains a unique value for each record?
A) primary key
B) secondary key
C) index
D) record selector
Q3) Which of the following buttons can you use to undo the deletion of a table field?
A) Undelete Field
B) Undo
C) Redo
D) none of the above
Q4) How do you know how many tables you need or which fields belong in which tables? What techniques can you use?
Q5) What are the general steps for creating and using a table in datasheet view?
Q6) What is Microsoft Access used for? Provide an example.
To view all questions and flashcards with answers, click on the resource link above. Page 12