Information Technology Fundamentals
Exam Bank
Course Introduction
Information Technology Fundamentals offers a comprehensive introduction to the essential concepts and components that form the basis of modern computing environments. Students explore hardware, software, networks, data management, security, and ethical issues related to technology. The course covers topics such as computer architecture, operating systems, networking concepts, the Internet, databases, and basic programming. Emphasis is placed on practical applications of technology in business, education, and everyday life. By the end of the course, students will have a foundational understanding of how information systems operate, enabling them to use technology more effectively and serving as a strong base for advanced courses in the field.
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 your Office account,in which of the following service categories would you find Office365 SharePoint?
A) Images & Video
B) Storage
C) Sharing
D) none of the above
Answer: B
Q2) What is a SkyDrive group? What must group members have in order to join the group?
Answer: When you create a SkyDrive group,your group has a name,web address,and group email address.After you create a group,you can invite members and establish a role for each member.Members you invite to your group must have a Microsoft account to access the group.Members can store and share documents in this group on SkyDrive.People you invite as members receive an email that invites them to join the group.When they accept the invitation,they are listed in the Group membership area of the group.
Q3) SkyDrive group members have the same access as owners and co-owners.
A)True
B)False
Answer: False
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) What does encryption do and how is it implemented?
Answer: Encryption converts data into a coded format that can't be understood unless it is decoded.If you open an encrypted file,it appears as scrambled characters and numbers.Access implements encryption through password protection.When you assign a password to a database,Access encrypts the database,saves the new file,and closes the database.When you reopen the database,you must enter the password in order to have Access decrypt and open the database.
Q2) Which of the following are considerations when using passwords to protect a database?
A) You may need to remove a password assigned to a database.
B) You may need to periodically change a password.
C) Some companies have policies that establish the frequency with which you must change a password.
D) all of the above
Answer: D
Q3) A database that is signed and packaged has a file extension of .accde.
A)True
B)False
Answer: True
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) Which of the following is not true of RTF files?
A) An RTF file preserves the formatting of the data.
B) The default extension of an RTF file is .rtf.
C) While you can export tables,forms,reports,and queries,it works best to limit your selection to objects that have a tabular format.
D) all of the above
Answer: D
Q2) When you initiate a mail merge,Access opens the Microsoft Access Mail Merge Wizard.
A)True
B)False
Answer: False
Q3) In a mail merge,which of the following is the table or query used in the merge?
A) mail merge
B) merge fields
C) main document
D) data source
Answer: D
To view all questions and flashcards with answers, click on the resource link above.
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) 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
Q2) The order that Access navigates from one control to another is determined by the value in the Tab Stop property.
A)True B)False
Q3) Navigation buttons can be removed from any form.
A)True
B)False
Q4) After applying a new theme,you can modify any parts that you don't like. A)True B)False
Q5) The linking fields are typically the primary key in the "one" table and the foreign key in the "many" table.
A)True B)False
Q6) Provide an example of when you might want to create a one-to-many form.
Page 6
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) A running total is not the same as an aggregate function.
A)True
B)False
Q2) When the report is in Design view,the expression is visible inside of the control.
A)True
B)False
Q3) Which of the following Access date functions converts values into a date value?
A) DateSerial()
B) DateAdd()
C) DateDiff()
D) DatePart()
Q4) Which of the following Access date functions determines the difference between two dates?
A) DateSerial()
B) DateAdd()
C) DateDiff()
D) DatePart()
Q5) What are calculated controls? Explain what you know about using calculated controls in reports.
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) A stand-alone macro is a separate Access object that appears in the Navigation pane.
A)True
B)False
Q2) When you create a database built from one of these templates,you must link it to a SharePoint server running Access Services.
A)True
B)False
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) SQL is the underlying language in a relational database system.
A)True B)False
Q5) Comments affect the logic or functionality of macros.
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 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.
Q2) Which of the following can you use to print the current form,close the current form,navigate to the next record,or open another form?
A) text box
B) label
C) command button
D) check box
Q3) Use the Property Sheet of the form to select the desired settings to limit actions available in a form.
A)True
B)False
Q4) What are some of the tasks you might perform when customizing a report in Layout view?
Q5) What is a split form and why is it useful?
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) 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
Q2) What is the name for a hardcoded value entered into a formula?
A)constant
B)parameter
C)criterion
D)function
Q3) What is a calculated field? Where are calculated fields stored?
Q4) Which of the following is a valid criterion for the Number data type?
A)5
B)$5
C)5t
D)5n
Q5) Use the ? wildcard character to match any number of characters.
A)True
B)False
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) When data is entered that violates a validation rule,Access automatically displays a message box alerting the user to the problem.
A)True
B)False
Q2) 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
Q3) Which of the following must you use to print the contents of a database?
A) File tab
B) View tab
C) Backstage view
D) none of the above
Q4) Which of the following is used to enter records into a table?
A) Datasheet view
B) Design view
C) Lookup view
D) Validation view
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) To edit field properties in Datasheet view,select the cell containing the field name you wish to change and then click the ____________.
A) Home tab
B) File tab
C) Name & Caption button
D) Properties button
Q2) Access is a relational database management system.
A)True
B)False
Q3) Each object in your database application is shown in the
A) Navigation pane
B) File tab
C) datasheet
D) Navigation menu
Q4) The Navigation pane displays your objects by categories and groups.
A)True
B)False
Page 12
Q5) The Navigation pane shows each object in your database.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 13