MS Access

Review: Formatting Fonts with the Formatting Toolbar

To Change Font Size: Select the control and select the pt. size from the Font Size list on the Formatting toolbar.

To Change Font Type: Select the control and select the font from the Font list on the Formatting toolbar.

To Format Text with Bold, Italics, or Underlining: Select the control and click the Bold, Italic, or Underline button on the Formatting toolbar.

Changing Text Alignment

To Change Text Alignment: Select the control and click the Align Left, Center, or Align Right button.

Using AutoFormat

To Format a Form or Report with AutoFormat: Display the form or report you want to format in Design View, click the AutoFormat button on the Report Design toolbar, select one of the AutoFormats from the list, and click OK.

Changing Colors

To Change a Control's Colors: Select the control and click one of the following buttons on the Formatting toolbar:

  • Fill/Back Color

  • Font/Fore Color

  • Line/Border Color

Applying Special Effects

To Apply a Special Effect to a Control: Select the control, click the Special Effect button list arrow, and select the desired special effect.

Using the Format Painter

To Copy Formatting with the Format Painter: Select the control with the formatting options you want to copy, click the Format Painter button on the toolbar, and select the control where you want to apply the copied formatting.

To Copy Selected Formatting to Several Locations: Select the control with the formatting options you want to copy, double-click the Format Painter button, select the controls where you want to apply the copied formatting. Click the Format Painter button when you're finished.

Adding Pictures and Lines

To Insert a Graphic: Click the Image button on the Toolbox, move the image pointer onto the form or report, then click and drag to draw a rectangle placeholder for the graphic. Select the graphic file you want to insert and click OK.

To Draw a Line: Click the Line button on the Toolbox, move the line pointer onto the form or report, then click and drag to draw the line. Hold down the Shift key as you drag to draw a straight line.

Aligning Controls with One Another

To Select Multiple Controls: Do any of the following:

  • Press and hold down the Shift key as you click each object that you want to select.

  • Use the arrow pointer to draw a box around the objects that you want to select.

  • If the controls are aligned along a horizontal or vertical line, click the horizontal or vertical ruler above or to the left of the controls.

To Align Objects with Each Other: Follow the above steps to select the objects you want to align, then select Format » Align and select an alignment option from the menu.

Changing a Control's Formatting Properties

To Format a Control Using the Properties Dialog Box: Display the form in Design View, select the control and click the Properties button on the toolbar, click the Format tab and make the desired formatting changes.

Quiz

  1. Fonts are measured in points. The larger the number of points, the smaller the size of the font. (True or False?)

  2. You select a control and then click the Align Left button on the Formatting toolbar. What happens?

    1. The control is aligned to the left side of the form or report.

    2. Nothing - the alignment buttons on the Formatting toolbar are used to determine the position of the form or report on the screen.

    3. The text inside the control is aligned to the left side of the control.

    4. Nothing - you must also select the control that you want to use to align the selected control with.

  3. AutoFormat automatically applies formatting options as you type. (True or False?)

  4. The Fill/Back Color button on the Formatting toolbar applies color to:

    1. The text in the selected control.

    2. The background of the selected control.

    3. The border of the selected control.

    4. All aspects of the control.

  5. What does the Special Effect button on the Formatting toolbar do?

    1. It applies a 3-D effect to a selected control.

    2. It lets you select a transitional effect for how a form opens and closes.

    3. It lets you add animation to your forms and reports to make them more entertaining and amusing.

    4. None of the above.

  6. Which of the following are reasons why you might want to format a control using the Properties dialog box instead of the Formatting toolbar? (Select all that apply.)

    1. You want to show off your Microsoft Access expertise to do things the hard way.

    2. The Properties dialog box offers every formatting option available for the controlsomething the Formatting toolbar doesn't have.

    3. The Properties dialog box gives you greater control over how a control is formatted.

    4. You can change the language used in a control using the Properties dialog box. For example, you could select Spanish or French instead of English.

  7. You want to insert a graphic of your company's logo on a report. How can you do this? (Select all that apply.)

    1. You can'tMicrosoft Access won't let you insert graphic files.

    2. Click the Image button on the Toolbox and drag on the report to draw a placeholder for the graphic.

    3. Select Insert » Picture from the menu.

    4. Select Tools » Insert Picture from the menu.

  8. How can you align several controls with each other?

    1. Select the controls by holding down the Shift key as you click each object, then select Format » Align and select an alignment option from the menu.

    2. Select the controls by holding down the Ctrl key as you click each object, then select Format » Align and select an alignment option from the menu.

    3. Select the controls by holding down the Ctrl key as you click each object, then click the appropriate alignment button on the Drawing toolbar.

    4. Select the controls by holding down the Shift key as you click each object, then click the appropriate alignment button on the Drawing toolbar.

Homework

  1. Start Microsoft Access, open the Homework database, and open the Test Answers form in Design View.

  2. Use AutoFormat to apply the International preset formatting style to the Test Answers form.

  3. Change the back color of the Grade text box field to light yellow.

  4. Change the font size of the Grade field to 10 pt.

  5. Use the Format Painter tool to copy the formatting from the Grade field and apply it to the two remaining fields on the Test Answers form.

  6. Resize the controls as necessary to make room for the new font size.

  7. Save the changes to the form.

  8. Close the Homework database, and exit Microsoft Access.

Quiz Answers

  1. False. It's true that fonts are measured in points; however, the larger the number of points, the larger the size of the font.

  2. C. The text inside the control is aligned to the left side of the control.

  3. False. AutoFormat lets you quickly format a form or report using a set of predefined formatting options.

  4. B. The Fill/Back Color button on the Formatting toolbar applies color to the background of a selected control.

  5. A. The Special Effect button applies a 3-D effect to a selected control.

  6. B and C. The Properties dialog box gives you more control and options over how a control is formatted.

  7. B and C. To insert a picture on a form or report, click the Image button on the Toolbox, and drag on the report to draw a placeholder for the graphic, or select Insert » Picture from the menu.

  8. A. To align several controls with each other, select the controls by holding down the Shift key as you click each object, then select Format » Align and select an alignment option from the menu.

by BrainBellupdated
Advertisement: