Which type of join is used to show all the entries in the table containing the primary key regardless of whether that ID has an entry in the second table
left outer join
Which is an organizational unit that is useful for collecting and aggregating similar data on separate forms
Tab pages
Barbara is enabling password protection on a database. Which option is not a secure password
apples
Which file type is used when forwarding a contact as a business card to another user to share their information
VCF
Which statement accurately describes the Clutter feature in Outlook 2016
It analyzes a user’s interaction with particular messages to provide a more focused inbox.
Cleo finds herself frequently searching for messages from particular senders or with specific subjects. What should she create to increase efficiency for these searches
Search folder
Which term refers to the use of expressions to check consistency in relation to other fields in the same record
record validation
Which statement best describes the Tell Me feature in PowerPoint 2016?
It is primarily used to locate options in the menu.
Which option is created specifically for giving a slide presentation in front of an audience and works when the speaker is utilizing multiple monitors or a projector
presenter view
Which type of query should be used to select fields from one or more related tables in a database
simple
Which command group on the Format tab of the SmartArt Tools contextual tab allows a user to change the fill and outline of SmartArt shapes
Shape and style
Michael needs to ensure that those items that are automatically archived are still easily accessible within Outlook. Which option should he configure
Show archive folder in folder list
Which option should Gina click to edit the text contained in a text box on a slide in her presentation
text box
Which feature refers to a combination of colors, fonts, and effects that a user can define and apply to slides, slide masters, and slide layouts
custom theme
Which option is used to collaborate with other authors by comparing different versions of the same document
Revisions
An Access table contains rows of table data that contain a complete set of data for a single entity. Which term is used for a row of table data
record
Which sensitivity level is not a default available in Outlook 2016
Company Only
Which option is used to determine whether information that should remain private is included in the final version of a PowerPoint presentation
Document Inspector dialog box
Which option is the easiest way to configure macros in Access 2016
Use the Macro Builder.
Which tab on the ribbon is used to access the global Access 2016 options
Database Tools
Which option in PowerPoint allows users to configure the number of columns and rows manually, using numerical values
Insert Table dialog box
Which feature should be used prior to finalizing a presentation to ensure that audience members with disabilities will be able to understand the message that a presenter is trying to get across
Accessibility Checker
Which tab group is used to modify the background of a chart that is contained in a PowerPoint presentation
Chart styles
Which type of control has its source of data found in a field in a table or query
bound
Shantel is trying to implement the use of data bars on a report that she created. She has selected the Conditional Formatting Rules Manager dialog box. What should she do next
Create a rule.
Lynn would like to insert a hyperlink into an email message without using the ribbon. What is the keyboard shortcut to do so
Control k
Dennis would like to include a video in a presentation. The source of the video is on the internet, but he would like to ensure that the video will play even if an internet connection is not active during the presentation. What should he do
Use the Video from my PC command in the Media group.
Which gallery will allow a user to access a variety of preconfigured formatting styles for images that are added to a PowerPoint presentation
Picture Styles gallery
Hoda is creating a report in Access using the Report Wizard. Which option is not available for adding fields using the wizard
reports
What is a new option in PowerPoint 2016 that provides the ability to add multiple pictures into a slide, complete with transitions and captions
Photo Album feature
Which type of VBA code is common for grouping statements that perform a certain task
procedure
Kathy would like to export a report that she created into an easy-to-use file format that is supported on multiple platforms and will retain the image quality of the report. Which option should she choose
PDF
Instead of manually moving an item on a slide, which command on the Shape Options tab can be used to determine location on the slide
Size and properties
Janis needs to select all the text in a single bullet point. Which action describes the easiest method to perform this task
Triple-click the text in the bulleted item
