Access 2007-2016
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 
 
 

< 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 2010 Beginner Level 4
Description: Access 2010 Beginner Level 4
Versions: Recorded with Microsoft Access 2010
Works fine with Access 2013 and 2007
Pre-Requisites: Access 2010 Beginner Level 3
Running Time: 1 Hour, 19 Minutes
Cost: $12.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 2010 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 2010 tutorial, microsoft access 2010 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
 

You may want to read these articles from the 599CD News:

 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP