Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  

< Previous: Access Beginner 3

Next: Access Beginner 5 >

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)
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
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

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


The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 6/24/2024 4:01:08 PM. PLT: 0s