Learn how to encrypt a database with a password and maintain databases using Compact and Repair.
- [Instructor] There are two very important tools…that I want to share with you.…That will really help you maintain your databases.…Those are:…Creating a backup of your database,…and compacting and repairing a database.…Have you've ever received an error message…that your database has been corrupted?…If that has ever happened to you,…you probably had a panic moment.…But, I'm going to show you just how easy it is…to repair your database.…Let's take a look at the 02_04 Maintain: Database.…
First, I want to take a look at the New Customers table.…Let's go into Design View,…and I want you to take a look at the field size…for each of the fields.…Customer ID is 255 characters.…We really don't need more than 10 character spaces held…for that particular field.…Look at Company.…It's also 255 character spaces.…Address. The same thing.…State. They're all 255 character spaces.…What that means is…each time you enter a record into Access,…it's actually holding 255 character spaces for you.…
You may only need a few of those.…If you don't go in and compact the database…
Author
Jennifer McBee
Released
1/27/2017The course begins with an overview of the certification program. Jennifer then walks you through all of the certification objectives. You can gain hands-on experience using the downloadable sample documents to practice as you follow along. The course concludes with a full-length practice test that emulates the Access 2016 MOS exam. Solutions are provided to each of the included challenges.
- Define a one-to-many relationship.
- Explain the purpose of using the Compact and Repair tool often.
- Summarize the steps to add a table description to a table.
- Recall the steps taken to rearrange the fields in a table.
- Identify the action taken to quickly add all fields in a table to a new query.
- Explain the purpose of a subform.
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome43s
-
-
1. Microsoft Office Specialist (MOS) Exam Overview
-
Prepare for the test1m 58s
-
2. Create and Manage a Database
-
Create and modify databases4m 42s
-
Navigate through a database1m 35s
-
Maintain databases3m 50s
-
Print and export data4m 57s
-
-
3. Build Tables
-
Manage tables4m 48s
-
Manage records in tables4m 21s
-
Modify fields3m 21s
-
Validation and masks7m 55s
-
✓ Solution: Build tables5m 13s
-
-
4. Create Queries
-
Create and run a query6m 9s
-
Create a crosstab query3m 37s
-
Create an action query3m 6s
-
Create a parameter query4m 1s
-
Modify a query4m 43s
-
✓ Solution: Create queries8m 47s
-
-
5. Create Forms
-
Create a form4m 58s
-
Configure form controls3m 33s
-
Add subforms4m 9s
-
Format a form5m 13s
-
✓ Solution: Create forms7m 25s
-
-
6. Create Reports
-
Create a report4m 6s
-
Configure report controls5m 27s
-
Format a report5m 42s
-
Add a calculated field3m 37s
-
✓ Solution: Create reports5m 50s
-
-
7. Final Practice Exam
-
Conclusion
-
Next steps28s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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.
Share this video
Embed this video
Video: Maintain databases