| |
| |
|
|
|
Access Beginner Level
4
Beginner Microsoft
Access Tutorial - 1 Hour, 19 Minutes |
| |
|
|
| |
This Microsoft
Access video tutorial picks up where
Level 3
left off. This class continues teaching you about Table Field
Properties. You will also learn about Indexing, Compact & Repair,
and Find & Replace. Topics include:
 |
- More Field Properties
- Required & Allow Zero Length
- Text Align & Format
- HTML Encoded Rich Text
- Indexing Fields
-
Compact & Repair
- Backing Up Your
Database
- Find & Replace
- Questions From Students |
Order Now |
If you would like a preview of what's covered in this class,
click here to watch the first lesson of
this course (free of charge), or scroll down for more information.
|
|
Access Beginner Level 4 |
| Description: |
Access
Beginner Level 4 |
| Versions: |
This class was recorded with Microsoft
Access 2010. The material is valid for Access 2007 up to 2021. |
| Pre-Requisites: |
Access
Beginner Level 3 |
| Running Time: |
1 Hour,
19 Minutes |
|
Cost: |
$5.99 |
|
|
|
This class
picks up where
Level 3 left off. We will continue our focus on the Field
Properties for your table fields. You will learn about the Required
property, null values, zero-length strings, text align, text format,
append only, indexing, and more. We will also discuss compacting,
repairing, and backing up your database, and the find & replace
feature.
We will begin by learning the Required
and Allow Zero Length properties. You will learn about null
values vs. zero-length strings. You will learn why no data is
better than bad data.
Next you will learn about the Text Align,
Text Format, and Append Only properties. You will learn about
HTML-Encoded Rich Text and how you can use it to allow text
formatting options in your forms and reports. You will learn how the
"append only" property is misleading, and how to show the history of
changes in a memo field.
Next we will spend a few minutes talking
about some field properties you'll probably never use, like SmartTags,
Unicode Compression, IME Mode, and such. Then, we'll spend a great deal
of time talking about a very important concept called Indexing.
You'll learn why you should definitely use it, what it's used for, and
what the benefits of Indexing your fields are.
In Lesson 4 we'll discuss some important
database maintenance techniques including Compacting & Repairing your
database, why compacting is essential, and how to properly
backup your database.
Next you'll learn all about the Find &
Replace feature including all of its options. You'll learn how to
use Find & Replace in both tables and forms, and one thing you should
definitely do before using the Replace All feature.
This is the perfect class for anyone who is wants to
learn proper table design in Microsoft Access. Understanding
field properties is crucial. You should also definitely know about
compact & repair, and backing up your database. Of
course, if you have any questions about whether or not this class is
for you, please contact me.
Complete Outline - Access
Beginner Level 4
00. Introduction (6:07)
01. Field Properties 7 (10:42)
Required
No data is better than bad data
Data integrity rules
Existing data violates the new setting
Null Values vs. Empty String
Zero Length Text
Allow Zero Length
Access automatically trims spaces
02. Field Properties 8 (9:18)
Text Align
Left, Right, General, Distribute
Text Format
Plain Text
Rich Text
HTML Encoding
Change table, change form
Append Only Misleading
Show Column History
03. Field Properties 9 (14:44)
SmartTags - brief discussion
Unicode Compression - brief discussion
IME Mode - brief discussion
IME Sentence Mode - brief discussion
Show Date Picker
AutoNumber Increment or Random
Artificially inflating AutoNumbers
Indexing
Duplicates OK
No Duplicates
Which fields to index
When and when not to index |
04. Database Maintenance (7:57)
Compact & Repair
2 GB Database Size Limit
Backing Up Your Database
05. Find & Replace (15:18)
Find, Replace
Look In Current Field
Current Document
Match Whole Field
Any Part of Field
Start of Field
Search: All, Up, Down
Match Case
Search Fields as Formatted
Search Box at Bottom of Table/Form
Replace v. Replace All
Backup Your Table First
How to Copy/Paste Table
Rename Table
Goto Button
First, Previous, Next, Last, New
Navigation Buttons
Select & Select All
CTRL-A
06. Questions From Students (9:59)
Can I get an AutoNumber back?
Compact & Repair trick
Can I create a custom AutoNumber?
Attach Label to Text Box
Associate Label with a Control
Add a Field to Table
Must add field to form manually
Renamed table fields usually rename in form
Deleted fields in table cause error
07. Review (4:44) |
|
| |
| Keywords:
Table Field Properties, Database Maintenance, Find, Replace, microsoft access tutorial, microsoft access tutorial, microsoft access training, compact, repair, required, null, empty string, allow zero length, text align, text format, plain text, rich text, html encoded, append only, show column history, smarttags, unicode compression, ime mode, ime sentence mode, show date picker, increment, random, autonumber, indexing, indexed, duplicates OK, no duplicates, backup, look in current field, look in current document, match whole field, any part of field, match case, search fields as formatted, replace all, rename table, goto, navigation buttons |
| |
|
|
