Learn to create new databases from a blank template, using templates, in older formats, using wizards. Jen McBee focuses on the method most likely to appear in the Access 2010 MOS Exam.
- View Offline
- Exercise Files
- [Instructor] Most of the time we're asked…to work on databases that have been created by other people.…As we'll learn in this video, that can be a good thing…if the database was created correctly…or it can be a bad thing if shortcuts were taken…during the creation and upkeep of a database.…In this video,…we're going to learn how to create a new database…starting with a blank database template.…We'll also explore other options for creating databases…such as using the built-in templates,…or copying an existing database…so we can use the same structure.…
We'll also look at how to bring in data…from an older Access format…and how to use wizards to create our databases.…Now notice the MOS icon next to Older formats.…Throughout these videos,…anytime you see the MOS icon,…that's a heads-up that this item will probably show up…on your Access 2010 MOS Exam.…Pay attention to everything in the videos,…but especially the ones with the MOS icons.…I have Access 2010 open,…so let's go ahead and get started.…
I'm currently in the Backstage area.…
- 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.