RelationalDB
SiteMap
Data Manipulation
Access Features
Building Database
Tables Queries
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Designing Reports
«Prev
Next»
Data Manipulation
Finding Sorting Filtering Data
Finding Data Table
Sorting Access Records
Sorting Access Records
Filter Records to Display Subset
Display Record Subset
Filter Records Multiple Criteria
Filter Records Complex Criteria
Advanced Filter Uses
Single Table Access Conclusion
Creating Access Queries
What are Queries
Query Access Database Window
Simple Query Wizard
Query Design View
Creating Query Design View
Save Query Design
Editing Query Design
Adding Criteria to Queries
Values in Criteria Expressions
Multiple Queries in Access
Specifying Sort Order
Creating Calculated Fields
Creating Access Forms
Access Form
Access Auto Form
Displaying Records Access Form
Edit Access Database
Create Access Forms
Form Design View
Save Access Form
Access Resize Controls
Access Form controls
Add Access Bound Controls
Toolbox Buttons Add Controls
Format form Controls Design form
Create Calculated Controls
Design Create Report
MS Access Reports
Navigating Report View
Access Mailing Labels
Report Design View
Header Footer Sections
Creating Mailing Labels from Client List - Exercise
Objective:
Create mailing labels from the Clients list.
This exercise is worth 5 points. The exercise is auto-scored, which means that all you have to do to receive credit for it is click the
Submit
button below.
Overview
You have just created a new brochure, and you want to send it to all your clients.
Use the Label Wizard to create mailing labels using the fields in the Clients table. You can choose the Avery 5163 labels, or a label that you actually use in your office.
Instructions
Start the Label wizard by using the New button in the Reports view of the database window. Choose Clients as the table to base the labels on.
Select the manufacturer, Unit of Measure and Label Type for your label. If you’re using Avery 5163, select English for the unit of measure, Sheet feed for the label type, and Avery for the manufacturer.
Change the text appearance as you like. Remember that if your label is small, you should stick with a smaller font size.
Put the fields onto the prototype label with the necessary spaces and punctuation. Just double-click the field names and then use the keyboard to enter spaces and punctuation before adding the next field. End a line by pressing Enter.
Sort the labels by Last Name.
Use the name, Labels Clients, which Access suggests, and create the report.