Learn to save objects using Save As to create a different object type or save the object in a non-native format, and how to Compact and Repair a database. Author Jen McBee will demonstrate how to encrypt a database with a password, skills that you may be
- [Narrator] It's really important…to manage your database correctly.…On the Access 2010 MOS exam, you may see questions…regarding how to save objects as a different object type…or as a non-native format such as PDF.…You may also see a question about compacting…and repairing a database.…We use this if our database becomes corrupted…or if the size grows so exponentially…that it's hard to save the data in the database.…
Finally, you need to know how to encrypt…your database by password-protecting it.…These are all great skills…that a database manager needs to have.…And because they will probably be covered…on your Access 2010 MOS exam,…we'll be sure to cover all three of these…during this video.…I have the 0202 exercise file open.…So if you're ready, let's tackle this topic.…At some point, you're going to need…to know how to save an object as a different object type.…
Now looking at the objects in this database,…in the navigation pane, we have several tables.…We have a query, and we have several forms.…I'm going to go ahead and open the Customers table.…
- 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.