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  
 
Home > Courses > Access > Beginner > B1 >
 
Access Beginner 1


 S  M  L  XL  FS  |  Slo  Reg  Fast  2x  Buy Now

In Production

Access Beginner 1 updated for Access 365, 2016, and 2019 is currently in production. If you need to learn Access now, watch my Access Beginner 1 for Access 2013. The material is almost exactly the same, and Access hasn't changed that much since then.

Resources

Topics Covered

In Lesson 1, we're going to learn what Microsoft Access is, and what it's used for. You will learn some database terminology. We'll discuss the benefits of a database. We will learn about the parts of a Microsoft Access database including tables, queries, forms, and reports. 

In Lesson 2, we're going to discuss planning your database. What tables do you need? What fields should go in each table What should your forms and printed reports look like?

In Lesson 3, we're going to get started creating our first new blank database file. We'll go over the Access Interface, switch the setting from Tabbed Documents to Overlapping Windows, and we'll learn how to handle that security warning that comes up when you open an Untrusted Database.

In Lesson 4, we're going to create our first table. We'll learn about field names, naming conventions, data types, and we'll start building the Customer Table.

In Lesson 5, we're continuing with building the Customer Table. We're going to decide whether certain fields should be text or number. We'll learn about long integers and doubles. We'll see why you should always include an AutoNumber ID field. You'll see how to move fields around in the table. We'll save our table, and learn about naming conventions. We'll learn about the Primary Key field.

In Lesson 6, we're going to learn how to enter and edit data in our Microsoft Access Tables. We'll see AutoNumbers in action, learn how to resize a column, discuss 2-character state codes, only storing digits in phone number fields, various date/time formats that are allowed, what #### in a field means, see how the Date Picker works, what the 2-digit year cutoff date is, how to toggle a yes/no field with the keyboard, how to open the Zoom window, and learn what Dirty records are.

In Lesson 7, coming soon...

Enroll Today

Enroll now so that you can participate with us as the videos are posted.

Questions?

Please feel free to post your questions or comments below. Thanks.

 

Updating Access Beginner 1 Upload Images   Link 
Richard Rost 
50 days ago
It's that time again. I haven't re-recorded Access Beginner Level 1 since 2013. Not a lot has changed for the user who works with Access on a daily basis and has some experience. However, for the novice user there's just enough of a difference to be confusing (Memo to Long Text, for example). So it's time for an update. Plus the old class was recorded with much lower quality video and audio than I use now. Best of all: everyone gets a free upgrade! Lesson 1 was just posted. Recording these beginner classes takes a LOT of time because they have to be "perfect." It's not like a TechHelp video or even my high-end Developer lessons where I can just sit down and ramble off nonsense for half an hour. One minute of a Beginner lesson takes about 10 minutes of real time. LOL. Enjoy. Share with your friends and colleagues!
Add a Reply

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.
 
Subscribe
 

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

2/24/2021Access Developer Forum
2/24/2021Widows & Orphans
2/23/2021Access Runtime
2/22/2021Table-Level Validation
2/21/2021Images
2/20/2021Not Updateable
2/20/2021Troubleshooter
2/19/2021Filter Records
2/18/2021Access Developer 26
2/17/2021Access Developer 27
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access beginner 1 access beginner 01  Page Tag: whatsnew  PermaLink