Business Computer Applications
Question Bank
Course Introduction
Business Computer Applications explores the fundamental concepts and practical skills necessary for leveraging computer technology in a business environment. The course covers essential software applications such as word processing, spreadsheets, databases, presentation tools, and email management. Students learn to create professional documents, analyze and manage data, design presentations, and utilize collaboration tools effectively. Emphasis is placed on real-world scenarios and problem-solving to enhance productivity and efficiency in business operations, preparing students for technology-driven workplaces.
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) You create a custom tab with groups and add command buttons you regularly use into groups on that tab.
A)True
B)False
Answer: True
Q2) Members you invite to your SkyDrive group do not need a Microsoft account to access the group.
A)True
B)False Answer: False
Q3) If you upgrade from Office 2010 to Office 2013,many of your settings are automatically transferred for you.
A)True
B)False Answer: True
Q4) The working environment in Office Web Apps is very similar to Microsoft Office.
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 Access,which of the following processes the fastest?
A) short text fields
B) long text fields
C) number fields
D) date fields
Answer: C
Q2) Which of the following file types the extension given to an Access executable file?
A) .accdb
B) .accde
C) .accdc
D) .xls
Answer: B
Q3) You can rename or delete the built-in Tables and Related Views or the Object Type categories or the groups within those categories.
A)True
B)False
Answer: False
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) How can you export specific records from Access to Excel?
A) Open the table or query in Datasheet view.
B) Select the records you want to export.
C) Start the export process after selecting records.
D) all of the above
Answer: D
Q2) What is XML and how does it compare to HTML?
Answer: Extensible Markup Language (XML)is one of several markup languages.As you know,HTML is the markup language used to build web pages.Like other markup languages,XML uses tags to define the structure of the data.However,XML does not use predefined tags,such as title,p,or table,which exist in other markup languages.In XML,you create the tags that you need to describe the data.Those tags usually incorporate the table and field names from your database.
Q3) In HTML,which of the following defines a paragraph and is used to display text on the web page?
A) p tag
B) tags
C) /
D) start tag
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 statements is true of the Locked property?
A) If the Locked property is set to Yes,a user can tab into that field and also change the field.
B) If the Locked property is set to Yes,a user can still tab into that field,but not change the field.
C) If the Locked property is set to Yes,a user can't tab into that field.
D) none of the above
Q2) Which of the following properties determines whether a control can have the focus?
A) Locked property
B) Enabled property
C) Cycle property
D) Border Color property
Q3) The Insert Image button inserts an embedded image.
A)True
B)False
Q4) If you make changes to the properties of a form,be sure to save the form after you make the changes.
A)True
B)False
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) In a report that shows data from a one-to-many relationship,which of the following is a report from the "one" side of the relationship?
A) subreport
B) main report
C) separate object
D) SQL object
Q2) In a Top Values query,which of the following is necessary to return the bottom values?
A) sorting the results in ascending order
B) sorting the results in descending order
C) sorting on the primary key
D) the top values will be returned automatically
Q3) A delete query deletes the entire record.
A)True
B)False
Q4) Creating a report in Layout view provides you with the most flexibility.
A)True
B)False
Page 7
Q5) Provide some examples of when you might need to use an action query.
Q6) Why is it sometimes necessary to change the height of a report section?
To view all questions and flashcards with answers, click on the resource link above.
Page 8
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) Explain what submacros are and why they are useful.
Q2) Which of the following Lookup field properties determines whether a user can edit the list of items?
A) Display Control
B) List Width
C) Limit to List
D) Allow Value List Edits
Q3) Which of the following statements is true?
A) When a report or form opens,the On Open event occurs.
B) When a user hovers the mouse over a button on a form,the On Mouse Move event occurs.
C) When a user pushes a button on a form,the On Click event occurs.
D) all of the above
Q4) Which of the following lets you integrate conditional logic into the execution of a macro?
A) group
B) argument
C) submacro
D) If block
Q5) What are data macros?
To view all questions and flashcards with answers, click on the resource link above. Page 9
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) When working with forms,Form view allows you to make changes to the form.
A)True
B)False
Q2) Which of the following should you use to create a report if you are short on time?
A) Report view
B) Report Wizard
C) Form Wizard
D) Command Button Wizard
Q3) Which of the following would you change in order to view a report using a landscape orientation?
A) page size
B) margins
C) page orientation
D) headers and footers
Q4) To organize controls vertically on a form,use a tabular layout.
A)True
B)False
Q5) Once created,why is it important to test a form? What is involved with testing a form?
To view all questions and flashcards with answers, click on the resource link above. Page 10
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) In the simplest criterion expression,when you only enter the criteria value,Access evaluates this criterion as an "equal to" comparison.
A)True
B)False
Q2) Which of the following should you add to a query to search for records that meet a specific value?
A)criterion
B)Like comparison
C)wildcard symbols
D)expression
Q3) Which of the following is a valid criterion for the Long Text data type?
A)hello
B)"hello"
C)*hello*
D)#hello#
Q4) Making changes to the data shown in Datasheet view of a query changes the actual table data.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
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) The Format property indicates the way a field displays in a table; it doesn't change what is actually stored.
A)True
B)False
Q2) In what is data in a relational database system organized?
A) fields
B) records
C) tables
D) Design view
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) As a database grows larger,what are three concerns you should be aware of?
Q5) What is the Caption property and when might you want to use it?
To view all questions and flashcards with answers, click on the resource link above. Page 12
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 should you do to the database file when you are finished working on it?
A) save
B) back up
C) close
D) rename
Q2) What must you create for each of the different pieces of information you want to keep in your table?
A) field
B) record
C) object
D) query
Q3) Which of the following data types is used to attach pictures,images,and Office files?
A) Hyperlink
B) Attachment
C) Calculated
D) Lookup Wizard
Q4) Share everything you know at this point about the four major objects in Access,namely tables,forms,queries,and reports.
To view all questions and flashcards with answers, click on the resource link above. Page 13