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 1
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   10 years ago

If you are new to Microsoft Access 2010, 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 2010 Beginner Level 1, including a course outline, sample videos, and more.

How do I export a large set of data from excel in Upload Images   Link 
Muhammad Osama 
5 years ago
How do I export a large set of data from excel in to access? Also, will access match the field headers with excel file?

Reply from Alex Hedley:

Expert 20 shows this.
Add a Reply
Mailing List Upload Images   Link 
5 years ago
What is the best approach if you are creating a mailing list and you have multiple people under the same address or you have the same person that has multiple addresses (vacation home). If I need a record for each person in the family to track birthdays but I want to be able to send a single mailing for the entire family for a holiday card, how should I set up the database? Do I create separate tables (1 that includes names and birthday's, etc.. and another that includes addresses) and create a relationship between the two tables or can I include all of the information in a single table and there is a way that I can indicate which address it should go to or when its a single mailing to multiple people. Read More...
Add a Reply
I run a business that has three types of customers Upload Images   Link 
Joe Sabo 
5 years ago
I run a business that has three types of customers. They are retail, commercial, and industrial, where ie, retail requires less fields than commercial or industial customers.  Additionally, we perform multiple services to some or all customers (not labor/time trackable) along with selling various types of inventory.  Could you steer me in the right direction to construct tables? Read More...
Add a Reply
Navigation Pane Upload Images   Link 
Pamela Smith 
5 years ago
Thanks got it... had to click objects and then the the drop down menu...
Add a Reply
Navigation Pane Upload Images   Link 
Pamela Smith 
5 years ago
I am running access 2010, when I saved my first query (using my own data) I do not get separate section on the left hand side.. IE: your tables, queries. It is just a listing with the correct names but not separated by types. Not sure what happened. Read More...
Add a Reply
Access 2013 Upload Images   Link 
Santa L 
5 years ago
i was pay for MS Access 2013 but i got only MS 2010 only. i have seen youtube MS Access 2013 which was very nice. can you let me access MS Access 2013?

Reply from Alex Hedley:
Add a Reply
with access when entering a street address vs PO Upload Images   Link 
Richard Werbelow 
5 years ago
with access, when entering a street address vs PO Box, how do you make a field for either. I suppose we could just enter "PO Box" in street # field??

Reply from Alex Hedley:

This depends how you are storing your Addresses in your Table, you could make a Field multi use and just switch a label on a Form, then search in that Field Read More...
Add a Reply
In planning my database I have clients where there Upload Images   Link 
Sherrie Branson 
6 years ago
In planning my database I have clients where there might be multiple providers caring for them, as well as other multiple parties that might be providing input that are not related to the providers.  Am I correct that I would create at least three tables in this scenario?  One for clients; one for providers; and one for non-provider entities.  I would also like to track provider expenses for each client. Is this yet another table?  Thank you! Read More...
Add a Reply
Courses Upload Images   Link 
chris f 
6 years ago
I just discovered your courses via youtube and they are excellent. I am hooked because the information is exactly what I need. I am trying to figure out the price structure so I can get the most bang for the buck, additionally I just saw your information on CD courses for Christmas. Excellent idea and I think I want to take advantage of that offer for my family. Read More...
Add a Reply
Zoom Tip Upload Images   Link 
MARTIN Waples 
6 years ago
Just for the record I used your tip for shift f2 button and it controls my screen brightness, I looked for away to turn that function off any suggestions. Although I will never use the notes box in datasheet view just wanted to learn the shortcuts while doing the exercise to become aware 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/24/2021Missing Months
7/24/2021Center Vertically
7/22/2021Buy Access
7/21/202164-Bit Access
7/18/2021Splash Screen
7/11/2021Access Developer 30
7/11/2021Access Developer 31
7/11/2021Access Developer 31 Lessons

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