Fundamentals of Information Systems Solved
Exam Questions
Course Introduction
Fundamentals of Information Systems introduces students to the core concepts and technologies that underpin modern information systems within organizations. The course explores how information systems support business operations, decision-making, and competitive strategies, while examining key components such as hardware, software, data management, networking, and security. Students will also learn about system development, ethical issues, and the impact of emerging technologies on businesses and society. By the end of the course, learners will have a foundational understanding of how information systems contribute to organizational effectiveness and innovation.
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) Which of the following is NOT a method for creating a new database?
A) A blank desktop database
B) A database from a style
C) A custom Web app
D) A database from a template
Answer: B
Q2) The purpose of a database is to:
A) manage, store, sort, and query information.
B) help provide access to the internet.
C) compose e-mail messages.
D) create presentations.
Answer: A
Q3) In the Relationships window,join lines indicate the relationships between tables.
A)True
B)False
Answer: True
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) Table modification may be needed after an Excel spreadsheet has been imported such as:
A) renaming a field.
B) changing the font size.
C) changing the font type.
D) updating hyperlinks.
Answer: A
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) A primary key field CANNOT be deleted.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3:
Query
Source URL: https://quizplus.com/quiz/37013
Sample Questions
Q1) Which of the following is NOT an aggregate function?
A) COUNT
B) AVG
C) MINIMUM
D) PMT
Answer: D
Q2) The order of operations specifies that any exponents are performed first.
A)True
B)False
Answer: False
Q3) When using date data,the date is surrounded by ________.
A) parentheses ( )
B) pound signs # #
C) brackets [ ]
D) braces { }
Answer: B
Q4) You can use Pmt to find the future value of a mortgage.
A)True
B)False
Answer: False
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:
Source
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 report view?
A) Report
B) Design
C) Layout
D) Print
Q3) Which database object is used to add data into or edit data in a table?
A) report
B) query
C) form
D) macro
Q4) Which of the following is NOT a form view?
A) Form
B) Edit
C) Layout
D) Design
To
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,the prompt is enclosed in ________.
A) parentheses ( )
B) braces { }
C) brackets [ ]
D) quotations " "
Q2) The DatePart function has ________ required parameters.
A) 1
B) 2
C) 3
D) 4
Q3) If a validation rule is not met,you CANNOT continue until the data value meets the rule.
A)True
B)False
Q4) The IIf function requires ________ parameters.
A) 0
B) 1
C) 2
D) 3
7
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Action and Specialized Queries:
Hands-On-Exercise Videos Available Study Resources on Quizplus for this Chatper 14 Verified Questions 14 Flashcards
Source URL: https://quizplus.com/quiz/37019
Sample Questions
Q1) A make table query selects records from one or more tables and uses them to create a new table.
A)True
B)False
Q2) You would use a find duplicates query to find the same values in a table.
A)True
B)False
Q3) You should back up your database before testing an action query.
A)True
B)False
Q4) To find the same values in a table,you would use the Find ________ Query Wizard.
A) Repeated
B) Alike
C) Matching
D) Duplicates
Q5) A purge query is used to remove records from a table. 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) A locked form displays data but does not allow any changes to the data.
A)True
B)False
Q2) A text box can be converted into a combo box.
A)True
B)False
Q3) If you want users to view a form but not make any changes to its data,you would use a ________ form.
A) protected
B) locked
C) secure
D) read-only
Q4) To prevent any changes to a form,select the No option for Allow Additions,Allow Deletions,and Allow Edits in the ________.
A) Changes dialog box
B) Property Sheet
C) Protection dialog box
D) Attributes Sheet
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) If you make a mistake when entering a hyperlink,you can edit the link by clicking and correcting it.
A)True
B)False
Q2) When displaying a form or report,you would use an attachment control to manage your attached files.
A)True
B)False
Q3) To remove an attachment from a record,you ________.
A) click the paperclip press Delete
B) double-click the paperclip and click Remove
C) right-click the paperclip and select Delete from the menu
D) right-click the paperclip and select Remove from the menu
Q4) You are limited to one attachment per record.
A)True
B)False
Q5) You can export an Access query to an Excel spreadsheet,but you CANNOT export a report.
A)True
B)False
10
To view all questions and flashcards with answers, click on the resource link above.
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) When you use the Database Splitter tool,it splits a database into two files:
A) major and minor
B) primary and secondary
C) independent and dependent
D) front-end and back-end
Q2) Which of the following tools is used to create a report that details information on relationships between tables?
A) Performance Analyzer
B) Database Splitter
C) Table Analyzer
D) Database Documenter
Q3) You should consider using the Database Splitter tool to see if the performance of a database can be improved.
A)True
B)False
Q4) You would use the Performance Analyzer tool to help reduce data redundancies.
A)True
B)False
11
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10:
Macros and SQL
Source URL: https://quizplus.com/quiz/37027
Sample Questions
Q1) A(n)________ macro can be designed to automatically open several tables,forms,or reports.
A) internal
B) independent
C) stand-alone
D) embedded
Q2) A(n)________ macro can be attached to a command button control on a form.
A) dependent
B) external
C) embedded
D) stand-alone
Q3) A command button is triggered by the On Click event.
A)True
B)False
Q4) You can only create data macros from within a table.
A)True
B)False
Q5) You use the Macro Wizard to create and edit macros.
A)True
B)False
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) Objects that are part of an Access database are available from the ________ within Access.
Q2) A comparison operator in Access is used to evaluate the relationship between two primary keys.
A)True
B)False
Q3) What does a custom Web app enable you to do?
A) Create databases through Access' Web app.
B) Create relational tables that can be distributed through the Web.
C) Create a database and share with others through the Web.
D) Share and distribute database files without the need for Access to be installed on every computer.
Q4) Irene is working in a database that organizes city court case information.Irene must find court cases in either Jackson county or Jefferson county.Irene should use the Filter by Form ________ condition.
A) query
B) sort
C) OR
D) AND
To view all questions and flashcards with answers, click on the resource link above.
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) When displaying a document in Print Preview,the Magnifier can be used enlarge or shrink the size of the previewed page.
A)True
B)False
Q2) You would use the thesaurus to find misspelled words.
A)True
B)False
Q3) A word underlined with a red wavy line indicates a ________.
A) formatting error
B) potentially misspelled word
C) grammatical problem
D) word usage error
Q4) A ________ such as a calendar is a predesigned file that includes formatting elements and may include some content.
A) style
B) template
C) theme
D) layout
To view all questions and flashcards with answers, click on the resource link above. Page 14
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) ________ storage is technology used to store files and work with programs that are accessed through the Internet.
Q2) A(n)________ is a Windows 8 feature that allows you to share music,pictures,and libraries with other people within a home network.
Q3) Windows 8 is an Intel operating system.
A)True
B)False
Q4) The mouse pointer changes to a four-headed arrow when you resize an object.
A)True
B)False
Q5) By default,the Quick Access Toolbar displays above the Ribbon in Office 2013. A)True
B)False
Q6) Desktop and SkyDrive are examples of Windows 8 apps. A)True
B)False
Q7) What happens when you press Ctrl+F in a Word file?
Q8) ________ are made up of five icons that provide functionality to the Start button in Windows 8.
To view all questions and flashcards with answers, click on the resource link above. Page 15
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) The ________ data type should be applied to fields that contain a combination of characters and will be 255 characters or less.
Q2) Creation of the order of fields within a table and specific field names given are significant because it's very difficult to change these after the database has been created.
A)True
B)False
Q3) All Excel spreadsheets are ready to import into an Access database.
A)True
B)False
Q4) Which of the following statements is TRUE about how Access and Excel share data?
A) Access can import data from Excel, but cannot export data to Excel.
B) Access can export data to Excel, but cannot import data from Excel.
C) Access can import data from Excel, and export data to Excel.
D) Access cannot import data from Excel and cannot export data to Excel.
Q5) ________ queries contain two or more tables and allow users to take advantage of relationships that have been set between these tables.
To view all questions and flashcards with answers, click on the resource link above. Page 16
Q6) Describe a wildcard in Access.Mention at least two wildcards that are available in Access.
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) Sum,Count,and Avg are all examples of aggregate functions.
A)True
B)False
Q2) When designing an expression for a calculated field,field names are surrounded by:
A) parentheses.
B) brackets.
C) braces.
D) double-quotation marks.
Q3) When viewing the results of a query,a series of ________ symbols indicates that a column is too narrow to display the complete results.
A) &
B) #
C) !
D) @
Q4) Exponents are evaluated first according to the order of operations.
A)True
B)False
Q5) ^ is the symbol for ________.
To view all questions and flashcards with answers, click on the resource link above. Page 17
Q6) Explain how the Pmt function is used and identify two of its required arguments.
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) The table or query that supplies the underlying data for a form or report is called the ________ or data source.
Q2) In Form view,to sort a field containing names from A to Z,click Ascending in the:
A) Arrange group on the HOME tab.
B) Sort & Filter group on the HOME tab.
C) Arrange group on the DATABASE TOOLS tab.
D) Sort & Filter group on the DATABASE TOOLS tab.
Q3) The Ascending and Descending buttons are located in the ________ group on the HOME tab.
Q4) If you need to sort the records contained in a report,you can do so from either the Design view or the ________ of the report.
A) Sort View
B) Layout View
C) Print preview
D) Report view
Q5) A subform combines two views of the same record source
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 18
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) Which data validation method enables you to execute programming tasks whenever data in a table is changed?
A) Data macro
B) Validation rule
C) Input mask
D) Default value
Q2) When creating a lookup list for the State field,what must you also consider?
Q3) To ensure the integrity of records in a table,you should set the required property to Yes for critical fields.
A)True
B)False
Q4) When using an input mask,parentheses and hyphens are automatically stored with the data.
A)True
B)False
Q5) A query where the user provides the criterion at run time is called a(n)________ query.
Q6) The Date function is commonly used as a default value for a date field.
A)True
B)False Page 19
To view all questions and flashcards with answers, click on the resource link above.
Page 20
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) You should NOT rerun an action query.
A)True
B)False
Q2) Which type of query calculates data using a sum,average,or other function and groups the results by two sets of values?
A) Crosstab query
B) Append query
C) Make table query
D) Find duplicates query
Q3) There is no way to verify that the correct records will be updated when using an update query.
A)True
B)False
Q4) What summarizes a data source into a grid of rows and columns?
A) Crosstab query
B) Append query
C) Make table query
D) Find duplicates table
Page 21
Q5) What should you do before running a delete query?
Q6) Why must care be taken when running a delete query?
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) The Tab order of a form cannot be changed.
A)True
B)False
Q2) A(n)________ is text not tied to a specific field.
A) label
B) text box
C) calculated control
D) control box
Q3) A(n)________ contains an expression that generates a calculated result.
A) calculated control
B) rectangle control
C) bound control
D) unbound control
Q4) Where is the Page Header located?
A) Top of each page
B) Top of form/report
C) At the end of each group
D) Bottom of each page
Q5) What are group headers and footers used for?
Q6) What will cause a group to print on a separate page? Page 23
To view all questions and flashcards with answers, click on the resource link above.
Page 24
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) When you save an RTF file,you might want to change the file type to a Word document in order to make formatting and editing easier.
A)True
B)False
Q2) What happens to the size of an Access database when a table is linked to an Excel spreadsheet?
A) The size of the database remains the same.
B) The linked table adds space to the database size.
C) The linked table adds space byte for byte.
D) The size of the database decreases in size.
Q3) Why would you export the structure of a table to a different database and not the data?
Q4) What do you do if you only want to export part of a table to Excel?
A) Filter the table first
B) You cannot export only part of a table
C) Only reports can be exported
D) Access cannot export to Excel
Q5) What is one of the reasons you import directly into Access from Excel?
Q7) What is the disadvantage of storing attachments in your database? Page 25
Q6) What is the major difference between a linked file and an imported file?
To view all questions and flashcards with answers, click on the resource link above. Page 26
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) A ________ is a combination of the date and time that is encrypted as part of the digital signature.
A) timestamp
B) certificate
C) navigation
D) password
Q2) When a file is saved as an Access Database Executable file,VBA code can be executed,but it cannot be modified.
A)True
B)False
Q3) The Table Analyzer analyzes the database and normalizes it for you.
A)True
B)False
Q4) What is the main reason for splitting a database?
Q5) Which Performance Analyzer result requires manual changes?
A) Ideas
B) Suggestions
C) Recommendations
D) Indexes
Q6) What is the purpose of a password? Page 27
To view all questions and flashcards with answers, click on the resource link above. Page 28
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) Data macros are used to ensure the accuracy of data in a(n):
A) table.
B) report.
C) embedded macro.
D) stand-alone macro.
Q2) ________ is the industry standard language for defining,manipulating,and retrieving data in a database.
Q3) Data macros can only be used with report events.
A)True
B)False
Q4) ________ can be converted to VBA without having to write any complex programming code.
A) Macros
B) Tables
C) Forms
D) Reports
Q5) The type of macro that is used to validate and ensure the accuracy of data that is entered into a table is called a(n)________ macro.
Q6) What are the two methods of programming with Access?
To view all questions and flashcards with answers, click on the resource link above. Page 29