Applied Computer Technology
Study Guide Questions
Course Introduction
Applied Computer Technology explores the practical applications of computing systems in various professional environments. The course covers fundamental concepts in hardware, software, and networking, emphasizing how these elements integrate to solve real-world problems. Students will gain hands-on experience with productivity tools, basic programming, databases, and web technologies, as well as learn about cybersecurity practices and troubleshooting methodologies. Through case studies and project-based learning, participants develop the skills necessary to effectively utilize and manage technology in business, education, and other fields.
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) If you're using SkyDrive on a public computer,do not check the Keep me signed in check box.
A)True
B)False
Answer: True
Q2) Which of the following statements is true about resetting the Ribbon and the Quick Access toolbar?
A) You can reset your Ribbon to their original settings.
B) You can reset your Quick Access toolbar to their original settings.
C) When resetting the Ribbon,it is possible to reset a specific tab.
D) all of the above
Answer: D
Q3) What happens when you download items from SkyDrive?
A) The items are removed from SkyDrive.
B) The items are not removed from SkyDrive.
C) You are prompted to give the files new names.
D) You will be asked whether you want to add a password to the files.
Answer: B
To view all questions and flashcards with answers, click on the resource link above.
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) What is the Performance Analyzer tool and how is it used?
Answer: Access includes a Performance Analyzer tool that analyzes objects in the database and suggests potential solutions to improve performance.The tool categorizes analysis results as recommendations,suggestions,and ideas,each identified with an icon.Recommendations are solutions that can be carried out automatically by Access and do not have potential consequences on the database.Adding an index to a field is an example of a recommendation.Suggestions are solutions that can also be carried out automatically by Access.However,suggestions may have consequences or tradeoffs that you must consider.Creating a relationship between tables is an example of a suggestion.Ideas are also solutions that may have consequences or tradeoffs that you must consider,but Access cannot automatically perform an idea.You must perform these changes in the database by following the necessary steps.Changing a field's data type is an example of an idea.
Q2) Which of the following contains the database tables?
A) back-end database
B) front-end database
C) query
D) form or report
Answer: A
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) In an XML file,which of the following appears second after the XML tag?
A) root tag
B) dataroot tag
C) tags
D) schema
Answer: B
Q2) Once you create an RTF file,you can edit it in Word.
A)True
B)False
Answer: True
Q3) Which of the following specify what information from the data source to include in the document?
A) mail merge
B) merge fields
C) main document
D) data source
Answer: B
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) When you create a form in Design view,all sections,including the Detail section,are automatically added to the form.
A)True
B)False
Q2) In which of the following can you see the expression inside of a control?
A) Design view
B) Layout view
C) Print Preview view
D) both A and B
Q3) In which of the following views can you change the width of the labels on the subform?
A) Design view
B) Layout view
C) Print Preview view
D) both A and B
Q4) When you click a tab in a navigation form,the most current data is loaded.
A)True
B)False
Q5) Provide an example of when you might want to create a one-to-many form.
Page 6
Q6) What is an aggregate function? How do you aggregate over a group of records?
To view all questions and flashcards with answers, click on the resource link above.
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) To number rows using a running total,which of the following should you type in the Control Source property?
A) =1
B) =2
C) =3
D) =4
Q2) What is a parameter report? Why are parameter reports useful?
Q3) Which of the following operators is used to concatenate data?
A) [
B) +
C) &
D) (
Q4) Which of the following is a tool that makes it easier to build four different types of queries?
A) Query Wizard
B) crosstab query
C) find duplicates query
D) unmatched records query
To view all questions and flashcards with answers, click on the resource link above. Page 7
Q5) What are calculated controls? Explain what you know about using calculated controls in reports.
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) Which of the following categories of user interface macros relates to changing the database system?
A) Database Objects
B) Data Entry Operations
C) System Commands
D) User Interface Commands
Q2) The Row Source Type and Row Source properties are not set automatically by the Lookup Wizard.
A)True
B)False
Q3) Which of the following happens after completing the Lookup Wizard?
A) Access automatically creates a relationship between the two tables.
B) Access does not create a relationship between the two tables.
C) Access sometimes creates a relationship between the two tables,depending on your selections.
D) Access gives you the option of creating a relationship between the two tables.
Q4) SQL is the underlying language in a relational database system.
A)True
B)False
8
To view all questions and flashcards with answers, click on the resource link above.
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 viewing a report,Design view is a more visually-oriented mode you can use to alter the design of a report and see the effects of the changes in real time.
A)True
B)False
Q2) When working with multiple conditional formatting rules,Access stops evaluating when a match is found.
A)True
B)False
Q3) A split form allows you to see many records at once in the Datasheet view while giving you access to edit a single record.
A)True
B)False
Q4) Which of the following is true of adding conditional formatting to a report?
A) The order of rules is not important.
B) Access continues evaluating rules even when a match is found.
C) You can only set rules one field at a time.
D) You can select multiple fields and apply the same rule to all selected fields.
Q5) What are control layouts? What are the two primary control layout options?
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 does the type of criterion you enter,along with the way you enter the criterion,depend on?
A)table size
B)data type of the field
C)parameter text
D)calculated field
Q2) Which symbol must be used to specify criterion for the Date/ Time data type?
A)($)
B)(?)
C)(*)
D)(#)
Q3) Which of the following functions rounds a value?
A)Left
B)UCase
C)iif
D)Round
Q4) At times no records will display when you run a query.
A)True
B)False
Q5) What is a summary query? What functions are commonly used in summary queries?
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) The notation 1:1 is used to describe the one-to-many relationship.
A)True
B)False
Q2) New tables always open in Design view.
A)True
B)False
Q3) When you add a new field,you must give the field a name,but you do not have to assign a data type.
A)True
B)False
Q4) When using validation rules it is important that the rules are tested.
A)True
B)False
Q5) Design view is used to enter records into a table.
A)True
B)False
Q6) A Short Text field can have a size from 0-50.
A)True
B)False
Q7) What is an input mask and what are its three parts?
To view all questions and flashcards with answers, click on the resource link above. Page 11
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) If you open a table with a previously saved sort,clicking Remove Sort on the Home tab removes the sort.
A)True
B)False
Q2) When working with a new table,you can save it by clicking the File tab and clicking the Save button.
A)True
B)False
Q3) What is a collection of related records called?
A) field
B) record
C) table
D) database
Q4) Which of the following is a type of software application?
A) hierarchy of data
B) database
C) database management system
D) Entity-Relationship Diagram
Q6) What is Microsoft Access used for? Provide an example. Page 12
Q5) What are the general steps for creating and using a table in datasheet view?
To view all questions and flashcards with answers, click on the resource link above. Page 13