Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
due in 48 hours Microsoft office application i need correct answers
Lesson 1:
1. The outline pane shares its portion of the screen with the _____ pane.
a. Slides
b. Task
c. Shortcuts
d. Notes
2. A thumbnail preview of all of the slides in the PowerPoint presentation can be seen in the:
a. Slides/task pane.
b. Preview pane.
c. Slides/outline pane.
d. Status bar.
3. Clicking the mouse button on the vertical scroll button will display a Screen Tip that shows:
a. Notes the presentation author has made.
b. Bibliography notes that may pertain to the current slide.
c. The slide number and title.
d. A thumbnail view of the current slide.
4. You have just created a new blank slide and intend to title it awards. Now, you decide instead that you want awards to be a bullet point under the heading Major Accomplishments. To make this change in the outline, you would place the insertion point to the right of the new blank slide and press the _______ key(s).
a. Shift and Enter
b. Enter
c. Control and Tab
d. Tab
5. Your company, burtshardware.com, was just purchased by tomshardware.com. You need to edit all of your PowerPoint presentations to replace burtshardware.com with tomshardware.com. Where is the search and replace utility in PowerPoint?
a. The Edit tab ribbon
b. The Home tab ribbon
c. The Insert tab ribbon
d. The References tab ribbon
6. You have highlighted a line of text in PowerPoint slide. You then click the italicized button. What will happen to the selected text?
a. The text will be indented.
b. The text will be italicized.
c. A first level bullet will be created for the text.
d. The text will be formatted in small caps.
7. When creating a PowerPoint presentation, you would click the line spacing button when configuring the:
a. Vertical slide margins
b. Horizontal slide margins
c. Line spacing between text lines
d. Line spacing between paragraphs
8. You have used the word “amazing” twice in the same paragraph to describe your company’s sales report in a PowerPoint presentation. You have now created a third instance of the word and you want to find an alternative word for “amazing”. What can you do to accomplish this?
a. Click the research button on the Review tab ribbon.
b. Click the Synonym button on the Review tab ribbon.
c. Click the Thesaurus button on the Review tab ribbon.
d. Click the thesaurus button on the References tab ribbon.
9. Clicking the add slide button will:
a. Create a new slide using the layout of the previous slide.
b. Create a new slide layout.
c. Create a bullet list format for the current slide.
d. Highlight the current slide header for easy viewing.
10. PowerPoint offers you a variety of preconfigured layout options. They can be accessed by clicking the Layout button located in the:
a. Slides group on the home tab ribbon.
b. Slides group on the design tab ribbon.
c. Layout group on the home tab ribbon.
d. Layout group on the design tab ribbon.
11. When you insert an image into a slide and activate the image, you will see eight:
a. Vertical pointers.
b. Horizontal pointers.
c. Sizing handles.
d. Display handles.
12. Contextual tools can be applied to ________ in PowerPoint.
a. Text
b. Page content
c. Footers and headers
d. Image objects
13. You want to select slides 1, 3, and 5 from your presentation from the slide Sorter View. How would you accomplish this?
a. Hold down the shift key and click slides 1,3, and 5
b. Hold down the ctrl key and click slides 1, 3, and 5.
c. Hold down the alt key and click slides 1, 3, and 5.
d. Click slides 1, 3, and 5 with the right mouse key.
14. The most efficient way to select all the slides between 3 and 9 in the slide sorter view is to click on slide 3, then:
a. Hold down the ctrl (Control) key and click slide 8.
b. Drag to slide 9, and then release the mouse button.
c. Hold down the shift key and click on slide 9.
d. Click on each slide until you get to slide 9, when you would release the mouse button again.
15. You can toggle between the normal view and the slide sorter view by clicking their designated buttons located in the:
a. Slides group on the home tab ribbon.
b. Slides group on the design tab ribbon.
c. View group on the review tab ribbon.
d. Lower right-hand corner of the PowerPoint window.
16. Transitions:
a. Have to do with the way text or graphic objects enter and exit a slide.
b. Refer to the method of embedding objects in a PowerPoint slide.
c. Are the links between objects that maintain a dynamic connection with object in a source application?
d. Control the way individual slides present themselves on the screen.
17. It is very common today for presenters to hand out a ________ to the audience to accompany a PowerPoint presentation.
a. Slide sort preview sheet
b. Slide handout
c. Slide print preview sheet
d. Printed slide sorter sheet
18. The print command for PowerPoint is accessed:
a. From the home tab ribbon
b. from the page layout ribbon
c. from the print tab ribbon
d. by clicking the office button
19. Note pages will print slides as well as text that you have typed into the:
a. Supplementary pane
b. Notes handout
c. Notes pane
d. Presenter notes pane
20. You want to print only slides 1, 2, 5, and 6 from your PowerPoint presentation. How would you choose these slides within the Print dialog box?
a. Check the checkboxes of the designated slides.
b. Click the radio buttons of the designated slides.
c. Click the slide icons for the designated slides.
d. Type the slide numbers separated by commas.
Lesson 2:
1. You are creating a PowerPoint presentation for your sales team. You want all of the slides to have more than just a white background and you want them all to conform to the same look. What is the easiest way to do this?
a. Choose a background by clicking the Background button in the Styles group in the Home tab ribbon.
b. Choose a background by clicking the Background button in the Styles group in the Design tab ribbon.
c. Choose a background by clicking the Background Styles button in the Background group in the Design tab ribbon.
d. Choose a background by clicking the Background Styles button in the Background group in the slide show tab ribbon.
2. You have created a bullet list on a PowerPoint slide. You want to decrease the list level of one of your bullets. Which button in the Paragraph group would you select to do this?
a. Multilevel list
b. Decrease indent
c. Increase indent
d. Bullets
3. You are creating a PowerPoint slide presentation for the year-end annual company meeting. You want to use some of the slides you created in a PowerPoint presentation you made last year in a PowerPoint file called December09.pptx. What is the easiest way to accomplish this?
a. Click the New Slide arrow on the Home tab ribbon and click Reuse Slides, browse to the December09.pptx file and select the designated slides.
b. Click the insert tab and select the reuse slide button in the slides group, browse to the December09.pptx file and select the designated slides.
c. Click the insert tab and select the object arrow and click PowerPoint slide, browse to the December09.pptx file and select the designated slides.
d. Click the office button and select open, browse to the December09.pptx and find the designated slide, copy the designated slides and paste into the current presentation.
4. The Clip Art function in PowerPoint 2007 refers to:
a. Jpg files downloaded from the internet.
b. Jpg files purchased from a clip art vendor.
c. Images included with Microsoft office.
d. Images that reside in the clipboard.
5. You wish to insert a Windows Bitmap file from your hard drive into a PowerPoint slide. Which media type would you check in order to browse for this file?
a. Clip art
b. Images
c. Pictures
d. Photographs
6. Selecting an image in one your slides in PowerPoint 2007 will trigger the appearance of a new tab on the ribbon called:
a. Image
b. Format
c. Design
d. Object
7. You would use the picture shape button located in the picture styles group if you wanted to:
a. Format a slide into the shape of a square.
b. Format an image into the shape of a star.
c. Insert a rectangular graphic file.
d. Insert clip art file that is a particular shape.
8. An example of a picture effect for images in PowerPoint 2007 would be a(n):
a. Border.
b. Explosion
c. Soft edge
d. Background contour.
9. You are creating a square shape by sizing it with the mouse. What key do you hold down while moving the mouse?
a. Shift
b. Ctrl
c. Esc
d. Alt
10. What is the best way to insert text into a PowerPoint slide in order to place it anywhere on the slide?
a. Type the desired text, highlight it, and hit the computer key arrows to move the text to its desire placement.
b. Click on the desired spot for the text and being typing.
c. Type the desired text, highlight it, and use the mouse to move the text to its desired placement.
d. Insert a text box; use the mouse to move it to the desired placement, and type inside the text box.
11. Nudging a text box involves:
a. Single clicking the mouse key quickly on the outer edge of the box.
b. Double clicking the mouse key quickly on the outer edge of the box.
c. Clicking the outer edge of the box and using the arrows keys on the computer.
d. Clicking the outer edge of the box and using the plus and minus keys on the computer.
12. You have two images on a slide and you want to be able to format and move the images in an identical fashion. What is the easiest way to do this?
a. Click on each object and click the group button under the format tab.
b. Click on each object while holding down the ctrl key and click the group button under the format tab.
c. Click on each object while holding down the shift key and click the align button under the design tab.
d. Select both images while holding down the mouse key and click the align button under the design tab.
13. You have multiple images selected on a slide in PowerPoint 2007. You click the align left right button without selecting the align to slide option. What happens as a result?
a. The images will align to the right edge of the slide.
b. The images will align to the .5-inch right margin.
c. The images will align to the one-inch right margin.
d. The images will align themselves with right-most image.
14. You are creating a PowerPoint presentation and want to create a slide using a SmartArt graphic that will show how the various departments relate to the organization. What graphic type will you select?
a. Matrix
b. Hierarchy
c. Cycle
d. Pyramid
15. The insertion of a SmartArt graphic will result in an additional _______ tab appearing on the ribbon.
a. Image
b. Animation
c. Design
d. Format
16. You want to utilize various WordArt styles for the text in your SmartArt graphics. Under which tab ribbon are these options available?
a. Image
b. Animation
c. Design
d. Format
17. You want to liven up your slides by turning your bullet lists into SmartArt graphics. You can accomplish this by highlighting the list with the mouse and:
a. Selecting the convert to SmartArt Graphic button on the Home tab ribbon.
b. Selecting the convert to SmartArt Graphic button on the Format tab ribbon.
c. Selecting the SmartArt Graphic button on the Insert tab ribbon.
d. Inserting a SmartArt Graphic and clicking the Combine Object button on the Format tab ribbon.
18. The SmartArt tools are made up of two tabs on the ribbon. What are they?
a. Home tab and Design tab
b. Format tab and Design tab
c. Design tab and SmartArt tab
d. SmartArt tab and WordArt tab
19. The transition options on the animation tab ribbon are utilized to control:
a. The movement of animated motions within the slide.
b. The movement of the animated images within the slide.
c. How the slide contents appear on the slide.
d. How the slide fades to black after a designated time.
20. You have utilized a series of JPEG files taken by your camera in a slide presentation you are creating. The sized of the files is very large and you would like to diminish the file size. How would you accomplish this?
a. Covert the JPEG files to PNG files.
b. Convert the JPEG files to TIFF files.
c. Compress the JPEG files.
d. Resized the JPEG files.
LESSON 3:
1. You create a table that has 4 rows and 3 columns. How many cells will be in this table?
a. 4
b. 7
c. 12
d. 43
2. Which ribbon menu in PowerPoint 2007 offers the ability to create a table within a slide?
a. Home
b. Design
c. View
d. Insert
3. You wish to add an additional row in a table you have configured in your slide. Which button on the ribbon would accomplish this?
a. Insert below
b. Insert row
c. Insert cell range
d. Insert left
4. The Table Tools Menu Group is made up of which tab ribbons?
a. Layout and design
b. Table and design
c. Table and layout
d. Insert and layout
5. You have been modifying a table you are working on in PowerPoint with the mouse and somehow the columns are no longer of equal proportion. The easiest way to reapportion them is to click the _______ button.
a. Resize table
b. Resize columns
c. Distribute columns
d. Equalized columns
6. You want the data in your table to be centered vertically within the cells. Which button will you click to accomplish this?
a. Top align
b. Middle align
c. Centered
d. Table
7. You have created a table within a slide in PowerPoint. All of the cells have background fill applied to them. You want all of your cells to be clear except for the column headers. The easiest way to accomplish this is to:
a. Uncheck the gradient fill box in the Table Styles Options group.
b. Uncheck the gray fill box in the Table Styles Options group.
c. Uncheck the Branded Rows checkbox in the Table Styles Options group.
d. Check the Clear Data Cells checkbox in the Table Styles Options group.
8. You have created a basic table within a slide and you want to apply special effects to the column headers such as beveling and shadowing. How do you accomplish this in PowerPoint 2007?
a. Click on the effects buttons in the table styles group on the layout tab ribbon.
b. Click on the effects button in the table styles group on the design tab ribbon.
c. Click on the effects button in the table styles group on the table tab ribbon.
d. Click on the effects button in the table styles group on the home tab ribbon.
9. You are creating a PowerPoint presentation for your company meeting. You want to create a chart that compares the gross sales of your three sales divisions over the last four years. Which type of chart in PowerPoint 2007 will be ideal in this situation?
a. Line chart
b. Pie chart
c. Area chart
d. Column chart
10. You are reviewing a chart made by one of your associates for the sales meeting. The chart illustrates information for more than twenty products. Each product is represented by a different color. To confirm which color represents which product, you could refer to the :
a. Color labels.
b. Category labels.
c. Legend.
d. Header reference notes.
11. What is the easiest way to jump from cell to cell when inputting data into your table cells?
a. Click on each cell with the mouse.
b. Move the mouse over each cell while holding the mouse key.
c. Press the Tab key on the keyboard.
d. Press the Ctrl key on the keyboard.
12. A data marker in a bar chart in PowerPoint 2007 is directly related to a:
a. Data point in an excel worksheet.
b. Data series in an excel worksheet.
c. Data series in a PowerPoint table.
d. Legend in a PowerPoint chart.
13. PowerPoint offers you many chart style options that are available within the ______ group on the _______ tab ribbon.
a. Chart options; design
b. Chart styles; design
c. Chart options; layout
d. Chart options; table tools
14. You are creating a PowerPoint presentation for your year-end company meeting. Your first slide represents company revenue. In your second slide you want to show how the total revenue was broken up into your various product divisions. Which chart type would be ideal for this?
a. Column chart
b. Bar chart
c. Pie chart
d. Area chart
15. Which type of reference information found in other tables such as bar charts is omitted in a pie chart?
a. Data labels
b. Column headers
c. Style labels
d. Legend
16. Which of the keys below are used to trigger animation effects in PowerPoint 2007?
a. Spacebar
b. Up arrow
c. Down arrow
d. F5 key
17. The final slide in your PowerPoint presentation announces the salesperson of the year. The slide has two animations. The first one fades in the words “And the Winner is” while the second animation fades in “Brad Davenport.” Which automatic start option would you select for the second animation?
a. After 10 seconds
b. After previous
c. Last
d. On click
18. You are creating an animated slide containing a pie chart showing the profitability of each company division. You want each slice of the pie chart to be treated individually within the animated action. Which option would you select?
a. By slice
b. By data label
c. By category
d. By data point
19. While giving a slide presentation, someone in the audience asks you a question pertaining to an earlier slide in the presentation. What is the easiest way to show this slide immediately?
a. Hold the Ctrl key while pressing the shift key
b. Hold the Ctrl key while pressing the F5 key
c. Choose the slide from the go to slide option in the navigation tools
d. Click the down arrow repeatedly until the desired slide is displayed.
20. What will be the result of pressing the B key during a live slide presentation using PowerPoint 2007?
a. The screen will go black
b. The presentation will go back one slide
c. The presentation will go back to the first slide
d. The text within the slide will show in bold font
Lesson 4:
1. You are about to create your first PowerPoint presentation and you want to utilize the default templates to help you in your slide design. How do you access the templates?
a. Click the office button, click new, and then click installed templates.
b. Click the new presentation button on the home tab ribbon, and click installed templates.
c. Click installed templates from the design tab ribbon.
d. Click the layout button in the slide group on the home tab ribbon, and click installed templates.
2. You can select a slide layout from a gallery of basic selections for an individual slide by clicking the:
a. Office button and selecting the desired slide design after hitting the new slide command.
b. Lower part of the slide button on the home tab ribbon and selecting the desired slide.
c. Slide gallery button in the slides group on the design tab ribbon.
d. New slide button on the slide show tab ribbon and selecting the desired slide.
3. You are creating a new PowerPoint presentation and you want to make sure that all of the slides have a unified presentation theme. Which tab ribbon allows you the opportunity to select a presentation theme?
a. Home tab
b. Insert tab
c. Design tab
d. Slide show tab
4. You are working on a PowerPoint presentation with a partner. The partner calls you as you are working on it to ask which presentation theme you are using. Where can you look to see which theme you currently are working with?
a. It is displayed above the ribbon at the top of the screen.
b. It is displayed just below the ribbon near the top of the screen.
c. It is displayed on the task bar in the bottom right-hand corner of the screen
d. It is displayed on the status bar in the bottom left-hand corner of the screen
5. Selected color themes in PowerPoint are applied to:
a. Backgrounds only
b. Objects only
c. Backgrounds and objects only
d. Backgrounds, objects, and text
6. changing the headings font will modify the text and then the:
a. slide titles
b. headers and footers
c. body section
d. image captions
7. You must access the _______ to change the headings font.
a. Headers and footers group on the home tab ribbon
b. Font group on the home tab ribbon
c. Font theme group on the design tab ribbon
d. Text theme group on the design tab ribbon
8. By default, a background style is applied to:
a. Any slides created after the selection of the background style
b. Any slides that have not been previously saved
c. The slide currently appearing in the slide pane only
d. All slides in the presentation
9. You have changed the background style of some of your slides but you now wish to change them back to your original choice. How do you accomplish this?
a. Click the rest slide background button in the Background group
b. Uncheck the checkbox selection for the unwanted background style.
c. Click the undo button in the editing group.
d. Click the reset button in the editing group
10. Once you apply an image as a background for a slide you are unable to:
a. Reverse the selection
b. Hide the image from view
c Change the size of the image
d. Apply it as a background for other slides
11. Which of the selections below is NOT a background option when clicking the format background button?
a. solid
b. gradient
c. picture or texture fill
d. no background
12. The WordArt Styles group is located on the _______ tab ribbon.
a. Home
b. Design
c. Format
d. Text
13. To create WordArt in a slide, click on the ________ tab and click the WordArt button.
a. Insert
b. Drawing tools
c. Format
d. Design
14. Clicking the Character Spacing tab allows you to configure the:
a. Vertical spacing between the lines of text.
b. Horizontal spacing between the font characters.
c. Vertical spacing between the list levels.
d. Vertical spacing between the paragraphs.
15. Clicking the underlined A button will allow you too:
a. Select a font
b. Select from the WordArt gallery
c. Underline highlighted text
d. Change the color of highlighted text
16. You can change the color of the bullets in a bullet list by clicking the:
a. Bulleted tab after clicking bullets and numbering.
b. Colors tab after clicking bullets and numbering.
c. Filled square bullets tab after clicking bullets and numbering.
d. Bullet color button in the paragraph group.
17. Clicking the cut button on the home tab ribbon will:
a. Delete all text from the selected slide.
b. Delete all text from the PowerPoint presentation.
c. Remove selected text and send it to the clipboard.
d. Copy selected text and send it to the clipboard.
18. You have copied a selection of text from a slide and you now want to paste it to another slide. Which key combination will allow you to paste the text?
a. Ctrl + P
b. Ctrl + C
c. Ctrl + X
d. Ctrl + V
19. You have changed the formatting for the text on a slide you are working on. You now decide to revert back to the default text format. What is the easiest way to do this?
a. Click the clear all formatting button.
b. Click the undo text formatting button.
c. Click the clear all text styles button.
d. Check the default text formatting checkbox.
20. You want to change the format for every slide in a previously created PowerPoint presentation. The easiest way to do this is to modify the:
a. Format for each slide individually.
b. Template that the presentation was created from.
c. Slide master of the presentation.
d. Draft page that the presentation was created from.
Lesson 5:
1. The most important function of a database is the ability to _______ the data in order to find the responding data that relates to the question.
a. Create
b. Query
c. Delete
d. Macro
2. _______ are displayed in rows, and each category is known as a field.
a. Files
b. Data types
c. Records
d. Designs
3. when in the single form layout, you will be viewing a:
a. record
b. table
c. field
d. macro
4. An easy way to skip to the last record in a table is to click the forward button in the Navigation:
a. Bar at the bottom of the screen
b. Bar at the top of the screen
c. Pane
d. Group on the home tab ribbon
5. The easiest way to jump from field to field in order to input data when in the single form layout is to use the:
a. Mouse
b. Tab key
c. Ctrl key
d. Spacebar
6. You are nearly finished inputting a new record when you find that you are inputting the wrong information. The easiest way to start over is to press the:
a. Tab key
b. Spacebar
c. Page up key
d. Esc key
7. In order to perform a query on an access database, you must provide a list of:
a. Records
b. Tables
c. Forms
d. Criteria
8. Which of the selections below describes a key difference between viewing data in a table and viewing in a report?
a. The data displayed in a report doesn’t match the data found in a table.
b. Tables only show data that has been queried.
c. The data in a report cannot be changed, unlike a table.
d. The data in a table cannot be changed, unlike a report.
9. You want to make formatting changes to the table in your access database by the datasheet formatting dialog box. You need to access this dialog box in the dialog box launcher in the _____ group on the home tab ribbon.
a. Table
b. Cell
c. Font
d. Datasheet
10. What is the maximum number of alpha-numeric characters that you can type into a field in access 2007?
a. 16
b. 55
c. 199
d. 255
11. You click the right arrow button while viewing a table. What happens as a result?
a. A new record is created and displayed as an append row.
b. A new field is created and displayed as an append row.
c. A new field is created and displayed as an append column.
d. A new table is created and is displayed in a new window.
12. What will happen to the data you are viewing in an access table as a result of clicking the A-Z button?
a. Access will perform a search and replace operation.
b. Access will sort the data in alphabetical order.
c. Access will show all the data that matches the input criteria.
d. Access will delete all of the data in the selected field.
13. You are viewing a table made up of nearly two dozen columns. You only want to view half of them in access 2007. you need to highlight the undesired columns and:
a. Press the delete key
b. Click the delete columns button
c. Click the hide fields button
d. Click the hide columns button
14. How do you know if you are viewing filtered or unfiltered data in a table?
a. Look at the filter checkbox in the sort and filter group.
b. Look at the filter button in the sort and filter group.
c. Look at the filter status bar.
d. Look to see if the filter tab appears on the ribbon.
15. You wish to print the filtered data you are viewing. How do you access the print command?
a. Click the print table button on the home tab ribbon.
b. Click the office button and select the print command.
c. Click the print records button on the home tab ribbon.
d. Press the shift + p keys on the keyboard.
16. In order to have a relational database, you must have two or more tables that share:
a. A common field
b. A common record
c. The same data
d. The same filter group
17. You are looking at two tables that are connected to each other after clicking the relationships tab. What does this mean?
a. The two tables were created from the same template.
b. The two tables share date redundancy.
c. The two tables are related.
d. One of the tables was created from the other.
18. What is the easiest way to display fields within a table that has been assigned the date/time data type?
a. Click the filter toggle button and select date and time.
b. Click the filter toggle button and check the date and time checkbox.
span style="mso-list: Ignore;">c. Click the date picker button.
d. Click the date and time button in the data group.
19. When in report layout view, how can you tell if a label is selected?
a. The label blinks
b. The label is highlighted
c. The label is active
d. The label has an orange border
20. What is a key benefit of the compact and repair tool in access 2007?
a. It eliminates data redundancy
b. It decreases the size of the database file
c. It eliminates non alpha-numeric characters from the records.
d. It converts a 2007 database to the 2003 file format.
Lesson 6:
1. The first step anyone should take in building a database is to:
a. Determine the version of access to use.
b. Determine the number of table that will be required.
c. Determine the purpose of the database.
d. Run an ERD analysis of the data information.
2. A data entry such as the last name of a customer should be:
a. Hosted in a singe record in a single table.
b. Hosted in two separate records in a single table.
c. Hosted in a separate record in two separate tables.
d. Input as a text file entry into a single table.
3. How does access identify each record within a database?
a. By the first field created for each record
b. By its primary key
c. By the table number
d. By the table’s tabular chart ID
4. You are creating a series of fields for your customer database. You want to make sure that the data entry person always inputs a last name for each field. What is the most effective way to do this?
a. Format the filed to a different background color than the other fields.
b. Make it the first field in the table.
c. Make it the last field in the table.
d. Set it as a required field.
5. You need to configure the properties of a field that will list the hiring date for each employee so that the date is always displayed in the format. Which tab ribbon do you access to accomplish this?
a. Design tab
b. Format tab
c. Database tools tab
d. Description tab
6. You have a database comprised of thousands of records; each record representing a purchase by a customer, there is a field in the database that displays the shipping charge applied to each purchase. You have only three shipping charges, $5, $10, $15. You want to ensure that your data entry person inputs only one of these three numbers. You can accomplish this by setting ______ the field.
a. The format property of
b. The caption property of
c. A validation rule for
d. A default value for
7. Now that you know how to use access 2007, your boss wants you to convert many of the excel worksheets you used to create for data information to access databases. How do you do this?
a. Import the excel worksheets by clicking the office button and selecting import.
b. Click the excel button in the import group on the external data tab ribbon.
c. Click the excel button in the conversion group on the external data tab ribbon.
d. Click the excel button in the office application group on the design tab ribbon.
8. You create a table in access 2007 and link it to the source data in an excel worksheet that is stored on the same computer that hosts access 2007. What is the benefit of doing this?
a. Any future changes made to the worksheet will be reflected within the access table.
b. Once the import process is complete, excel will archive the worksheet.
c. Once the conversion process is complete, excel will archive the worksheet.
d. Access will open the excel program whenever this table is opened in access.
9. You have a field in your customer database for phone numbers. You want the field to display a hyphen within the number requiring the data entry person to enter it. How do you do this?
a. Set the hyphen as a default value for the field.
b. Create a validation rule for the field.
c. Format the field for the hyphen character.
d. Use the input mask wizard and select the hyphen.
10. What is the purpose of creating a lookup column in access?
a. To create a field that will compare itself to other fields within the same database
b. To create a field that will compare itself to other fields from other databases
c. To retrieve values from other sources such as other table or a list
d. To lookup format and style setting that match the data being inputted
11. What is the benefit for your data entry people by providing their data entries via combo boxes?
a. They can choose which formatting style they need by the click of a mouse.
b. It eliminates typing errors since data entries are selected by the mouse.
c. It combines multiple fields into one simple input box.
d. It will add the field entry into all other related fields upon entering the data.
12. The most common relationship in access 2007 is:
a. One-to-one
b. One-to-many
c. Many-to-many
d. Many-to-one
13. You modify the primary key values in one table of your database and all the related records in another table are automatically updated. You have just witnessed an example of a (n) _______ update.
a. Cascading
b. Relational
c. Intermediate relation
d. Intermediate integrity
14. One of your suppliers has gone out of business. You want to delete its record from your database and ensure that it is deleted from all related tables. The best way to accomplish this is to implement a (n) ________ delete.
a. Intermediate relation
b. Relational
c. Cascading
d. Total
15. You wish to create a form in access 2007. The easiest way to do this is to click the form button on the ________ tab ribbon.
a. Home
b. Design
c. Database
d. Create
16. You want to use the snipping tool application to do a screen capture of your open access screen. To access it you need to select it from the:
a. Office button
b. Design tab ribbon
c. Accessories folder from the start menu
d. Administrative tools in the start menu
17. You have created a form in access 2007 but the form is blank. What could be the reason?
a. The table for the form has no data
b. A table has not been assigned to the form
c. A column has not been assigned to the form
d. A database has no been assigned to the form
18. You want to insert a text box into a form you are creating in access 2007. You can do this by clicking the text box button from the_______ group on the _______ tab ribbon.
a. Object; insert
b. Object; design
c. Controls; create
d. Controls; design
19. You want to modify the tab order of a form you are creating. You need to access the tab order button from the _______ layout group on the _______ tab ribbon.
a. Control; design
b. Control; arrange
c. Form; design
d. Form; arrange
20. You have opened the snipping took and want to capture the entire screen of your computer and save it to your computer. You can do this by click the:
a. New button and click full-screen snip
b. Snip button and click the full-screen snip
c. New button and drag the mouse across the entire screen
d. Snip button and drag the mouse across the entire screen
Lesson 7
1. What is the easiest way to view all the relationships between the tables in your access database?
a. Click the relationships button on the database tools tab ribbon
b. Click on relationships button on the home tab ribbon
c. Click on trust design button on the home tab ribbon
d. Click the table layout button on the database tool tab ribbon
2. The easiest way for the access novice to create a query in access 2007 is to click the ______ button on the _______ tab ribbon.
a. Query wizard; database tools
b. Query wizard; create
c. Simple query; database tools
d. Simple query; create
3. When you create a query in access, you are essentially:
a. Finding relationships between multiple tables
b. Finding related data among multiple tables
c. Asking the database a question
d. Creating a relationship report
4. You wish to create a label report. Labels in access 2007 are identified by:
a. How they relate to a table
b. How they are related to the database
c. Manufacturer and product number
d. The auto number assigned by access
5. You wish to print the first two pages of a label report created in access 2007. The place to specify the pages to print is in the :
a. Office button menu
b. Label report view box
c. Print preview box
d. Print dialog box
6. Which of the mathematical operators below is used as a comparison operator for queries in access?
a. +
b. >
c. *
d. /
7. You are inputting date/time data type criteria for the desired fields when creating a query. What is special about the date/time data type?
a. The date and time must be separated by commas.
b. The date values are surrounded by the # symbol.
c. The date and time values are surrounded by the % symbol.
d. The time must inputted in military time format.
8. You have just run a query on your database and you want to save the results. The save button is on the:
a. Quick access tool about the ribbon tabs
b. Query report toolbar
c. Query status toolbar
d. Data view toolbar
9. You have run a report using the report wizard in access 2007. The report has a column showing a series of dollar amounts but all that shows is a series of ####### symbols instead. What must you do to correct this?
a. Rerun the report using the correct data type format
b. Rerun the report, this time checking the show currency checkbox
c. Drag the column border to make the column wider
d. Rerun the report selecting the correct fields
10. When running reports, the _______ view allows for more precision.
a. Layout
b. Design
c. Precision
d. Details
11. The controls group is located on which access taps ribbon?
a. nbsp; Home
b. Create
c. External data
d. Design
12. Rather than dragging controls with the mouse to their desired position, you can utilize the:
a. Control alignment tools
b. Control placement tools
c. Control insert drop box
d. Control group insert button
13. You are running a query in access 2007. A dialog box is requesting you to input your criteria. What type of query are you running?
a. Control group query
b. Input query
c. Parameter query
d. Results query
14. The following button in access 2007, the run button is use to run:
a. Reports
b. The analyzer tool
c. Macros
d. Queries
15. One benefit of building a report on a parameter query is that you can:
a. Select from multiple database sources
b. Display a variety of results from a single query
c. Display the results with input from the user
d. Run reports in silent mode
16. The text button use to align text within a report is located in the ____ group.
a. Text
b. Font
c. Control
d. Styles
17. The group and sort button is located on the ______ tab ribbon.
a. Database tools
b. Format
c. Arrange
d. Page setup
18. You have assigned a null value to a field for a report. This means the field:
a. Has a negative value
b. Has a non-numeric value
c. Has been configured for sorting
d. Is empty and has no value
19. You want to export an access report that will preserve the text formatting of the report. What type of file should you choose?
a. RTF file
b. TXT file
c. DOC file
d. DOCX file
20. To make the file visible in a web browser, you should export the report as a:
a. RTF file
b. Notepad tile
c. HTML document
d. TXT file
Lesson 8:
1. In which type of scenario would you place two criteria in the criteria row when creating a query?
a. When looking for two separate values
b. When using the AND logical operator for both values
c. When each criterion is designated for a separate database
d. When using the OR logical operator for the two values
2. In which type of scenario would you place two criteria in different rows in the query design grid?
a. When looking for two separate values
b. When using the AND logical operator for both values
c. When each criterion is designated for a separate database
d. When using the OR logical operator for the two values
3. You need to access the property sheet button to modify the settings for a form you are creating in order to change the background color of the form. You would access this button in the ______ group of the ________ tab ribbon.
a. Tools; arrange
b. Tools; format
c. Formatting; arrange
d. Formatting; format
4. You need to access the align text center button in order to center the text at the top of a form. You need to access this button in the _______ group of the _________ ribbon.
a. Font; arrange tab
b. Font; form layout
c. Font; format tab
d. Font; home tab
5. You are running a query on your database. You want to query any customer’s last name that starts with an R. What wildcard characters would you type?
a. [R]
b. *
c. R#
d. R*
6. You are tracking what numbers have won the lottery every night. There are three numbers in a row and you want to see how many times the winning numbers started with the number 5. How would you query this using a wildcard?
a. 5$$
b. *
c. 5##
d. 5&&
7. When you add a calculated field to a query it creates a new:
a. Column
b. Table
c. Form
d. Report
8. You have just run a query to find out how many customers spent over $500 this year with you. You now want to see how many of these same customers live in Atlanta. What is the easiest way to do this?
a. Run a second query with Atlanta as criteria
b. Run a second query using the wildcard phrase At*
c. Click the find button in the editing group and search for Atlanta
d. Run the report wizard using Atlanta as the primary key criteria
9. A summary statistic could provide which of the following?
a. The number of records within a table
b. The batting average for the players on a team
c. Customers whose first name starts with a J
d. The number tables a record is related to
10. What does this button, Aa represent in the control group?
a. A text box
b. A caption
c. A label
d. A font property
11. You are creating a report in access 2007 but you see all of the tools you need to configure the report as you want. What can you do?
a. Import the tools you need from the Microsoft web site.
b. Click on the additional tool button on the database tools tab ribbon
c. Click on the hidden tool button on the database tools tab ribbon
d. Switch to design view to see additional tools on the design tab ribbon
12. You have added a textbox to a report using the control group tools. You want to change the placement of the text box. How do you do this?
a. Click the indent buttons on the home tab ribbon.
b. Click the movement buttons on the home tab ribbon.
c. Press the arrow keys on the keyboard.
d. Press the tab key on the keyboard.
13. You insert a label into the report footer of an access report. Where will it be displayed?
a. On the first page of the report
b. On the last page of the report
c. In the footer section of every page
d. In the report notes summary
14. You insert a text box into the page header. Where will it be displayed?
a. On the first page of the report
b. On the last page of the report
c. In the header section of every page
d. In the page notes summary
15. You want to configure conditional formatting for the fonts in an access report. How do you access this setting?
a. Click the conditional button in the font group on the design tab ribbon
b. Click the conditional button in the font group on the home tab ribbon
c. Click the font button arrow on the home tab ribbon and choose conditional formatting.
d. Click the font button arrow on the design tab ribbon and choose conditional formatting.
16. Which view will you be working in by default when you use the blank report tool?
a. Design
b. Layout
c. Form
d. Report
17. Which of the selections below is NOT a tool found in the controls group?
a. Date and time button
b. Title button
c. Gridlines button
d. Logo button
18. You want to use a chart in a report to visually display the data from a recent query. What is the easiest way to do this?
a. Click the import chart button in the controls group and select excel chart
b. Click the import chart button in the controls group and select PowerPoint Chart.
c. Use the PowerPoint chart wizard tool located on the create tab ribbon
d. Click the chart wizard button in the controls group.
19. How do you access the access options dialog box?
a. Click the access options button on the design tab ribbon
b. Click the access options button on the arrange tab ribbon
c. Click the access options button on the create tab ribbon
d. Click the access options button after pressing the office button
20. In which section of the access options can you access navigation options?
a. Popular
b. Current database
c. Advanced
d. Navigation
