Learn how to save a database as a template. Author Jen McBee demonstrates how to create a new table using Application Parts, both are skills you may be asked to demonstrate your knowledge of on the Access 2010 MOS exam.
- [Instructor] Have you ever heard of an application part?…I'm always surprised how many Access users…aren't aware of this great feature.…This allows us to use templates…to quickly create blank forms…or more complex parts that have tables, queries,…forms and reports.…In this video, we're going to talk about…what application parts are and how to apply them…to our database.…We'll learn how to quickly create blank forms,…how to use the Quick Start forms and tables…and how to save our database as a template.…
On the Access 2010 MOS exam,…you may be asked to create a list form…or a comment form using the Quick Start forms.…You may also be asked to save your database as a template.…We'll make sure and cover all three of these processes…to make sure that you're ready to tackle these tasks…on your exam.…I have the 0204 exercise file open so let's get started.…Now, this is a blank database.…I wanted to make sure that you knew…that you can create your application parts…in a blank database…or you can add them to an existing database.…
- 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.