Learn all about the commands on the Report Arrange tab. Author Jen McBee will demonstrate how to use the Control Margins and Control Padding, two arrange commands that you will likely encounter on the Access 2010 MOS exam.
- [Narrator] Are you starting to feel more comfortable…with creating and formatting reports?…I hope so.…So what's next?…Well, now we want to talk about our text boxes…and our labels and how we can control…the margins for each of the objects…and the padding for each of the objects.…During the Access 2010 MOS exam,…you may be asked to change the padding for a field.…And what this means is it gives more whitespace…between the label and the field.…
We also can change the margins for each field…and that does the same thing.…It moves the text away from the border…to give you a little more whitespace.…These are things that I don't find a lot of users…actually use on their reports and forms.…However, on the Access 2010 MOS exam,…you're probably going to be asked to do this.…So we'll take a couple of minutes and look…at both of these options.…I have the 0603 exercise file opened,…so let's get started.…
Let's create a quick report based on our Customers table.…I have it selected.…I'll go to Create and click Report.…Everything that we're going to talk about in this video…
- Creating a new Access database
- Applying application parts
- Backing up a database
- Creating new tables and fields
- Sorting and filtering records
- Setting primary keys
- Importing data
- Creating basic forms
- Creating Access queries, including crosstab and multitable queries
- Creating Access reports
Skill Level Intermediate
1. Microsoft Office Specialist Exam Overview
Prepare for the exam2m 18s
2. Managing the Access Environment
3. Building Tables
4. Create Forms
5. Create and Manage Queries
6. Create Reports
7. Final Practice Exam
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.