|
6/26/2012 1:15:43 AM
Access 4 is Finished
The videos are recorded and uploading to the server as I write this. It's pretty late right now though, and I've been working on this all day, so I'm pretty tired. I haven't had a chance to update the main web site with the full (pretty) course outline yet. I will tomorrow. A list of the topics covered is below.
You can ORDER it and watch/download it now if you'd like. You can also watch the INTRO and Review lessons in the Theater, to get a better idea of what's covered.
UPDATE: Now that I've gotten some sleep, here's the link to the OFFICIAL PAGE.
ACCESS 2010 BEGINNER LEVEL 4
1 Hour, 19 Minutes
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)
Permanent Link
|
