Learn how to modify the tab order in forms, both manually and using auto-order forms. Author Jen McBee explores formatting print layouts, sorting records, focusing on the skills you may be asked to demonstrate on the Access 2010 MOS Exam.
- [Instructor] Okay, let's talk about how…to finalize the formatting of your form controls.…When we add additional objects to our forms,…sometimes we have to modify the tab order.…On the Access 2010 MOS exam, you may be asked…to modify the tab order of the fields on a form.…You may also be asked to go in and…change the format options for your print layout,…such as your margins or your page orientation.…You may also be asked to sort the records…within a form.…
In this video we're going to cover…all three of these options, and I'll make sure…to focus on the commands that you may encounter…on the Access 2010 MOS exam.…Now, I had the 0407 exercise file open,…so let's get started.…Let's go ahead and work with our…Customer Contact Information form.…I'll open the form and the first thing that I want to…look at is, what is the tab order…that my users are going to experience, on this form?…Well, we start at the company name.…I'm going to tab down, it goes to contact,…first name, last name.…
Then it jumps all the way down to the phone number.…
- 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.