Information Systems Fundamentals
Final Test Solutions
Course Introduction
Information Systems Fundamentals introduces students to the basic concepts, technologies, and organizational roles of information systems in todays digital world. The course explores the components of information systems, including hardware, software, data, people, and processes, as well as how these elements interact to support business operations and decision-making. Emphasis is placed on the strategic role of information systems in achieving business objectives, improving efficiency, and gaining competitive advantage. Through practical examples and case studies, students develop an understanding of system development, data management, cybersecurity, and ethical considerations in the use of technology.
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) In the Access Options dialog box,which of the following categories can you use to add functionality to your Office programs?
A) Language
B) Advanced
C) Add-Ins
D) Trust Center
Answer: C
Q2) In the Page Setup dialog box,you can set SkyDrive as the default save location.
A)True
B)False
Answer: False
Q3) In the Access Options dialog box,which category lets you show or hide horizontal and vertical gridlines between cells,modify the appearance of a cell,and change the default column width?
A) General
B) Datasheet
C) Proofing
D) Object Designers
Answer: B
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) If you are working with Short Text fields,be sure to change the default size from 255 to a number that better matches the needs of your data.
A)True
B)False
Answer: True
Q2) Access includes a Database Splitter tool that analyzes objects in the database and suggests potential solutions to improve performance.
A)True
B)False
Answer: False
Q3) Normalization helps ensure that the fields describe only the entity represented in the table.
A)True
B)False
Answer: True
Q4) Text data types process more quickly than number data types.
A)True
B)False
Answer: False
Page 4
To view all questions and flashcards with answers, click on the resource link above.
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) If the data in an Excel column contains mostly numbers,but also includes some dates,every cell in the column will display in the date format.
A)True
B)False
Answer: False
Q2) Which of the following errors occurs when you attempt to add records where the primary key column contains inconsistent,missing,or duplicated data?
A) error with importing the file
B) subscript out of range
C) primary key error
D) truncated text value
Answer: C
Q3) Which of the following is a starting document in a mail merge?
A) mail merge
B) merge fields
C) main document
D) data source
Answer: C
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 is a common modification that users need to make to forms?
A) adjust the size and spacing of the text box and label controls
B) modify the font characteristics of the text boxes
C) change the border property
D) all of the above
Q2) To aggregate over a group of records on the subform,you must place the aggregate function calculation in the Detail section of the subform.
A)True
B)False
Q3) Which of the following do lines and rectangles help with on forms?
A) separating controls
B) providing a logical grouping around multiple controls
C) differentiate areas in a form
D) all of the above
Q4) Setting the Enabled property to No does not affect the way the label displays. A)True
B)False
Q5) Why might you want to create a form to capture parameter data?
Q6) Provide an example of when you might want to create a one-to-many form.
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) Concatenation combines different parts of an expression using the $ operator. A)True
B)False
Q2) Describe some situations in which you may end up with duplicated data.
Q3) Which of the following statements is not true about append queries?
A) An append query moves records from one table to another.
B) An append query puts a copy of the records into a destination table.
C) An append query adds records into an existing table in a database.
D) Using an append query,you can copy records from one or multiple tables into the destination table.
Q4) In a concatenation formula,how would you insert a comma and a blank space between two fields?
A) &" "&
B) &","&
C) =","&
D) [","]
Q5) Use the Subform/ Subreport button to launch the SubReport Wizard to add the subreport.
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) Which of the following is an individual command inside of a macro?
A) program flow statement
B) Action
C) Comment
D) Macro Builder
Q2) Which of the following lets you copy an action?
A) Ctrl+C
B) Ctrl+X
C) Ctrl+V
D) Ctrl+P
Q3) Which of the following categories of user interface macros relates to importing,exporting,sending,and collecting data?
A) Data Entry Operations
B) Data Import/ Export
C) Database Objects
D) Filter/ Query/ Search
Q4) What is a named data macro? What characteristics do named data macros have?
Q5) Design view is an available option for objects in web databases.
A)True
B)False
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 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
Q2) On the Design tab,selecting the Title button adds a title into the header section of the report.
A)True
B)False
Q3) What is a text box that gets its value from an expression?
A) bound control
B) unbound control
C) calculated control
D) stacked control
Q4) Which of the following indicates that a control has been selected?
A) an orange border
B) a green border
C) a red border
D) a red dashed border
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) Which of the following parameters is the most user-friendly?
A)[Enter the Music Genre]
B)[ ]
C)[Genre?]
D){Genre?}
Q2) When structuring a criteria expression with a parameter that includes one or more wildcards,where can the wildcards be positioned?
A)at the end
B)at the beginning
C)at the beginning and end
D)any of the above
Q3) Which of the following criterion expressions searches for a YearsWorked field that is between 10 and 20?
A)In(10,20)
B) >10< 20
C)Between #10 and 20#
D)Between 10 and 20
Q4) To see the results of a query,you must run it.
A)True
B)False
Page 10
To view all questions and flashcards with answers, click on the resource link above.
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 must you do before adding a field between existing fields?
A) enter a field name
B) enter a data type
C) select a primary key
D) insert a new row
Q2) When using validation rules it is important that the rules are tested.
A)True
B)False
Q3) What must you do if you make any changes to the relationships between tables?
A) print them
B) save them
C) copy them
D) delete them
Q4) What is a table called that matches up the records across two other tables?
A) foreign table
B) joining table
C) infinity table
D) junction table
Q5) When might you want to use the Default Value property?
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) The AutoFit feature helps visually frame the rows and columns in a datasheet with a border.
A)True
B)False
Q2) Form objects are used to find data in a database.
A)True
B)False
Q3) Which of the following tabs provides information about your database and additional functions to help you manage the database?
A) File
B) Create
C) Database Tools
D) External Data
Q4) To change the name of a field in a datasheet,_____________ the field name.
A) click
B) double-click
C) select
D) delete
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