Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
Access 2010 Beginner 4
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   9 years ago

This Microsoft Access video tutorial picks up where Level 3 left off. This class continues teaching table field properties plus a lot more. You will learn:

- 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

Click here for more information on Access 2010 Beginner Level 4, including a course outline, sample videos, and more.

I cannot find the MEMO field Upload Images   Link 
Brian Carter 
37 days ago
I cannot find the "MEMO" field in my DATA TYPES field.  I am running Access 365.
Kevin Robertson
37 days ago
The Memo field is now called Long Text.
Richard Rost
36 days ago
Brian, if you have the time, re-watch the new Access Beginner 1 that I just posted. It includes all of the little changes like this since 2010/2013.
Add a Reply
Append Only Upload Images   Link 
Mark Parsons 
2 months ago
Hiya, i have tried to change this in my split database_be but when i go back into the front end. It says the search key was not found in any record???
Adam Schwanz
2 months ago
What have you tried to change? I think im missing a lot of information here.

Check your linked tables make sure theyre going to the right file location
Mark Parsons
2 months ago
Hi Adam, I was watching one of Richards videos on tracking changes in a note section of my form. And changed the field property to append. Thats when I got that error message.
Add a Reply
Reset AutoNumber by Compact Upload Images   Link 
Emad Al-Baghli 
3 months ago
Hi, Sometimes I use Compact & Repair to reset the AutoNumber in all tables, even if those tables are related to each other,
But I have only one table doesn't reset the AutoNumber by Compact & Repair, Read More...
Richard Rost
3 months ago
Could be several things, but that doesn't matter. The AutoNumber isn't for YOU. It's for Access internally. Shouldn't matter if it's 1 or 100000.
Add a Reply
Smart Tags Upload Images   Link 
John Marquis 
3 months ago
Are smart tags still used? I am using Microsoft 365 but don't see it shown in the properties
Richard Rost
3 months ago
Smart Tags were removed in Access 2013.
Add a Reply
Indexing If you have a database with 32k records Upload Images   Link 
Gary Wiles 
5 years ago
Indexing: If you have a database with 32k records and a last name field is not indexed.  Can I change the property to indexed (Duplicates ok) and the database will index?  How long would the indexing take? Read More...
Add a Reply
Video Stuck Upload Images   Link 
Janice Daniels 
5 years ago
Further to my previous post, none of my lessons are working at the moment, I will shut down and try again.
Add a Reply
Video Stuck Upload Images   Link 
Janice Daniels 
5 years ago
Hi, this is my first post here, I am really enjoying the lessons.

I have clicked on Access 2010 Beginner 4 No.5 Find & Replace and the video seems to be stuck at the beginning?

Reply from Alex Hedley:
Add a Reply
Missing Fields Upload Images   Link 
5 years ago
Thanks Alex for responding to my question.  I tried changing the data source again, and it appeared the issue is fixed now.

Reply from Alex Hedley:

Add a Reply
Missing Fields Upload Images   Link 
Florence A 
5 years ago
Hi Richard, I am really enjoying the tutorials. Thanks a lot for your approach; you made it very easy to understand.  I have question regarding adding/deleting a field from table that you shared in the Questions from Students video. After deleting it from the table and subsequently from the form, I still got the pop up window asking me to "enter parameter value CustomerT.FaxNumber." I clicked ok to get past it. When I viewed the "existing fields" list, it showed the FaxNumber field, but not within the CustomerT available fields. Would you please enlighten me on how to correct that? Read More...
Add a Reply
Access 2016 on Windows 8 Upload Images   Link 
Darren Siow 
5 years ago
Hi Richard,

I am using Access 2016 on Windows 8.1 while taking your lessons.

I refer to the part where you said that there are two ways to change the contents in the textbox from Plain Text to Rich Text. The first method is to delete and re-add the textbox, and the second method is to double-click the textbox to bring up the Property Sheet, and select Rich Text in the Text Format field. When I used the second method however, I could not find the Text Format field in the list. I am not sure whether this is due to me using a later version of Access. In the end, I used the first method instead and it could work. Read More...
Add a Reply

Show Older Comments...
View in Table Format

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

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

7/27/2021Quick Queries #5
7/27/2021Loop Thru Fields in Table
7/26/2021First Monday
7/25/2021Missing Months
7/24/2021Center Vertically
7/22/2021Buy Access
7/21/202164-Bit Access

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
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
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access 2010 beginner 4 field properties required zero length compact repair backup find replace  Page Tag: whatsnew  PermaLink