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 2013 Beginner 1

If you are new to Microsoft Access 2013, this video tutorial will teach you all of the basics of how to build a Microsoft Access database. You will learn:

  • Database Terminology & Benefits
  • Planning Your Database
  • The Access Interface & Ribbon
  • Building a Customer Table
  • Entering and Editing Data
  • Sorting & Filtering Records
  • Constructing Customer Queries
  • Designing a Customer Form Interface
  • Developing Reports & Mailing Labels

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

Unable to finish videos Upload Images   Link 
Michael Cooper 
2 months ago
Videos Access 2013 Beginner-1 #9, 10 & 11 terminated approx 4/5 way through with an Download error. This occurred over a 2 day period. I can't restart the video from the error point and when video restarted from beginning (getting tiresom) it fails in the same place. I am a new customer and this is not what I expected.
Richard Rost
2 months ago
Hi Michael. Welcome. Those same videos have been online since 2013. I just double-checked and they're all fine. No other users have complained. If I do have a bad video file, I usually get at least 3 of 4 people complaining pretty quickly.

Here's what's probably happening: your system is downloading the MP4 video file as it's playing. If that errors out and the video doesn't download completely, it will still stay in your browser cache. So if you try to reload the page, your browser thinks you already have the file and doesn't attempt to re-download it. You may need to clear your browser cache and reload the page. Or, you can try logging on with an incognito window and the file will also download that way.

If you don't want to watch the videos online, you can also download them. Look for the ZIP file on your My Courses page.
Add a Reply
Question on the Label Report Upload Images   Link 
Juan Rojas 
4 months ago
I got this on the Label report and I don't know why. All on 1 label. How can I fix this.
LastNameFirstNamePhoneState
JonesJoe5495465466NY
PetersBarbra8292827288NY
RostRichard7167917510NY
SmithPeter5645597777NY Read More...
Juan C Rivera
4 months ago
Not sure what you are asking but here is a long shot did you put &" "& between your fields?
Richard Rost
4 months ago
Juan, Juan is right (LOL). This is Beginner Level 1 so you're using the Mailing Label Wizard, right? You probably forgot to press SPACE and ENTER between the fields. Watch the video again from the beginning and don't skip a step. :)
Add a Reply
Font size Upload Images   Link 
John Marquis 
4 months ago
I know that you can change the font size when viewing a table or the results of a query, but is there any way to increase the font size in the navigation pane or where you add the required information for a query.
Adam Schwanz
4 months ago
Go to options -> object designers -> query design -> query design font
Add a Reply
Delete a Table Upload Images   Link 
Arisane Silva 
6 months ago
Hi. For some reason I created Table2 and table 1 is empty how to delete table1, please?
Thanks!
Richard Rost
6 months ago
Just click on the table in the Navigation Pane and press DELETE on your keyboard.
Add a Reply
Zoom Not Working Upload Images   Link 
Armand Ratelle 
6 months ago
When I press shift key and F2 fir zoom it doesnt work ??
Richard Rost
6 months ago
Yeah, Microsoft "broke" this in one of the releases of Access 365 (see this). Update to the latest version.
Add a Reply
Primary Key Existing Field Upload Images   Link 
Matthew Rafferty 
12 months ago
Hi Rick,

If my student database includes students that already have a unique ID assigned e.g. a personnel number, shoulder that number be the primary key? Thanks PS Really enjoying the Learning zone!
Richard Rost
12 months ago
I recommend against it. I like to use an Autonumber for the primary key because Access will assign it and maintain it. The user can't edit it. Technically the user never even has to see it or know what it is. If you want to add that Personnel Number as an additional field for searching, that's perfectly fine. Index it, no duplicates. But don't make it the primary key. Later on when you get to relationships in Expert Level 1, you'll see why Autonumbers are best for PKs.
Richard Rost
12 months ago
That's a good question. I get asked it a lot. Maybe I'll turn this into a TechHelp video. :)
Add a Reply
Add Data to Word Document Upload Images   Link 
Ron Fischer 
13 months ago
is there a way to do a form that takes Letterdocument from word or Textprogramm an add customer infos like adress and subject from the database?


Richard Rost
13 months ago
Yes, you can use a Mail Merge or VBA to automate putting Access data into a Word document. Personally, I prefer just creating everything right inside of Access. I show with my Letter report how you can do it all in Access.
Add a Reply
Multiple Phone or Email Upload Images   Link 
Timothy Henley 
13 months ago
What if a customer has multiple phone numbers or emails?  Should they be separate tables?
Richard Rost
13 months ago
Yes. In a perfect world, if you're dealing with customers who have lots of phone numbers or multiple email addresses, you should put them into a separate table. Anyone familiar with Google Contacts knows how this works. However, I don't get into multiple tables and relationships until Expert Level 1, so for right now, you can make multiple fields in the same CustomerT table: HomePhone, CellPhone, WorkPhone, etc. And that's generally fine if you've only got 2 or 3 numbers. However, a properly built database where customers may have 1 or 20 different numbers (or email addresses) should use a second, related table. Don't worry. We'll get there soon...
Add a Reply
Access 2013 Beginner 1 Upload Images   Link 
sheryl 
7 years ago
I know basic Access.  What tutorial should I purchase to help with VBA in a query?
Add a Reply
Checking Out Keys Upload Images   Link 
Myra R Miller 
8 years ago
Thank you so much!
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.
 
Subscribe
 

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

7/24/2021Missing Months
7/24/2021Center Vertically
7/23/2021DCount
7/22/2021Buy Access
7/21/202164-Bit Access
7/20/2021Relationships
7/18/2021Splash Screen
7/11/2021Access Developer 30
7/11/2021Access Developer 31
7/11/2021Access Developer 31 Lessons
 

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 2013 beginner 1 tables query queries forms reports sorting filtering  Page Tag: whatsnew  PermaLink