Microsoft Access 2010 Tutorial Part 06 of 12 - Entering Data, Part 1

[@599CD]

Yes, you are absolutely correct. I designed my Beginner series for first-time NOVICE users, but I am preparing a "fast track" version that takes you through all 9-hours of my Beginner lessons in less than an hour. It's designed for people who have a little familiarity with Access, or know Excel real well and just want to know the nuts and bolts. Look for it some time in the next month on my web site for Access 2013.

[@allredhead]

I don't care if you approve this comment or not, but I just wanted to tell you something. Your videos are worthy enough for me to watch the ads and not get mad about it!

[@floriemaysedero8072]

Hi Sir Richard! My company is an old-school company and we are building databases. Unfortunately, my boss only uses Excel and it's veryyyyyyyyyy difficult to make a database out of excel directly. I tried looking for solutions online and accidentally knew about Office Access. I and my company have never tried this before. Looked for tutorials and I'm so glad yours went up first in google search. This is such an informative tutorial! Thank you so much. I'll share this with my teammates!

[@599CD]

I do teach. THIS is my day job. :) I used to teach in my own computer training center (classroom-based) full time until I decided to teach over the Web full-time around 2002. I still do offer live in-person seminars from time to time, but my primary focus is video tutorials. I can reach SO many more people online than I can in the classroom.

[@cjackbrewer7943]

I'm listening to the 6th of 12. This is an excellent series. Thank you so much! I'm a high school math teacher looking at developing an access application for a customer during the summer. This is giving me the confidence to try such a project.

[@599CD]

There is a limit of 255 fields per table. I've been building databases with Access for almost 2 decades now and I've NEVER run into that limit. However, if you have a need for more than that, you could set up a 1-to-1 relationship with another, secondary table. This effectively makes the number of fields per record unlimited (within reason).

[@mowburnt]

6 lessons on and loving it. Your style of teaching - get the basic building blocks in place first - is brilliant and perfectly paced. I already used access in a limited fashion, but want to add complexity to an existing database. I can tell this course will be perfect to get me up and running. Will definately be looking at the advanced course after. Much better value than a book for visual learners like me! Thanks

[@599CD]

My pleasure

[@599CD]

I don't generally recommend attaching text files directly to the database. Instead, I prefer saving the file on a server (or shared folder) and then saving the PATH/FILENAME of that file in the database. You can then view or edit it as you wish - but it's an external file, so it's not slowing your database down. There is a 2GB limit per database FILE, but again, you can extend a database to multiple files.

[@kelizabethmcdonald]

Thank you so much for these videos. I appreciate the tempo in which you tackle the program - I was dreading learning how to use Access after trying to learn from two peers and a book. Then I went from dreading Access to feeling defeated by it from another set of videos. Thank you for making this approachable for the technological laypeople like me. Many many thanks!

[@599CD]

You're very welcome. Glad you're enjoying the lessons.

[@599CD]

When does the database get slow? That depends on a lot of factors. Big databases are slower, yes. Do you have multiple users? Is your PC fast? Are you running over a network? Are your fields properly indexed? This is something you just have to try and see. Access is great for BUILDING and prototyping your database. If, after you're up and running, you decide it's too slow, you can always move the tables to SQL Server and keep your front-end.

[@mixybuksnac]

Sir thank u so much for this tutorial, i pass the important exam today thanks to u. i wish u all best in life

[@samn7724]

ive learnt 6 parts so far, excellent way of teaching, i gv u million stars

[@599CD]

Thanks

[@599CD]

I cover this in a couple of my classes. Basically, the CHEESY way to just insert 1000 blank records (how every many you want - copy and paste is fine) and then DELETE them. Your next record will start at 1001. There are more complex ways to do it with append/delete queries or recordsets, but this technique works fine - especially if you only have to do it once.

[@599CD]

I would assume you just click the close button, or try right-clicking on it. It's not part of Access. I have little to no experience with foreign-language versions of Office or Windows, so perhaps try a Google search.

[@599CD]

Of course I'm going to approve your comment. Thank you. I even approve comments that are critical of my work so long as they're respectful. If it's just a "you suck" then I delete it. If someone has an honest criticism or complaint, I'll approve it and address it.

[@599CD]

I cover normalization in my Access 201 class, my Access Relationship Seminar, and my upcoming Access Expert Level 1 class. I have a simple tutorial here on KZbin called "Microsoft Access Relational Tables" that covers the basics of setting up 2 related tables, but most of my advanced stuff is only available on my web site.

[@599CD]

You can't - in any way, shape, or form - manipulate AutoNumbers in Access. If, for example, you create a number field and type in "999" and then try to change that to an AutoNumber, Access will not let you. Sure you can use an append query to insert 999 records and then DELETE them and that will move your AutoNumber up to 1000 for the next record.

[@599CD]

Without seeing your database it's hard to tell what the problem is. Make sure you're using a single or double number type (not integer or long integer).

[@599CD]

This is something you can do in your WINDOWS Regional Settings (Control Panel). Then ALL of your Office applications (Excel, Word, Access, etc.) will inherit the change. Same with your date/time format.

[@CJBAUTISTA14]

Great videos. I had a question for adding customer ids, employee #, or even confirmation #, what if we wanted to start with a different number rather than 1, how do we go about that? Thank you.

[@Miriamhelps]

I learned some pretty cool new things in the last 10 minutes. Thanks! This is awesome.

[@13Cerulean]

Your videos are very informative and helpful, however, it would be awesome if you had an 'accelerated' version for those of us with less time and a higher level of familiarity with other Microsoft products so that we can still learn the basics without it taking so long ...or putting me to sleep...lol not enough coffee this morning ;) (yes I was the kid in class that was done first and skipping ahead...lol) Thanks for creating and posting. :)

[@599CD]

The EASIEST way to solve this problem is to just add 99 blank records in your table and then delete them. That will artificially inflate the ID to 100 for your next record. If you only have to do this ONCE, it's a fine solution.

[@kmwrites7456]

This man is a superb teacher!

[@599CD]

Thanks

[@dawnuk7687]

Thank you I love how you teach ,Crikey I am so pleased, at my grand old age I can understand and follow easily from you

[@djKingSoloNY]

Hey Richard really wanted to tell you that I like your videos. I'm having a final exams and I'm trying to prepare for it. Do u have any tutorials explaining well relationships such as (one to one, one to many, many to many). My problems is understanding the concecpts and building ER diagram in visio based on that. Thanks.

[@caps008]

Thanks for your help:) awesome videos. Will you ever have Normalization videos?

[@GabrielaFord]

I am excited, I'm actually starting my Customer's Data Base. Thank you very much Richard for the time and great job you are doing while putting these tutorial together.

[@599CD]

welcome

[@Amandaraebear]

This is great so far... My goal is to learn how to organize my staff members. But it's not as simple as you think... My team travels to various parts of the state and I need to track where they are. We visit multiple hospital sites teaching them the new computer systems the hospitals are implementing (electronic health records). I want to be able to sort by name, employee#, cell phone#, pager#(because not all hospitals have cell reception), what city they're teaching in and which classroom th

[@arthurkandakai4002]

I really enjoy this session thanks. I will always be here. Please send me Microsoft word 2010, 2007 , 2012 and 2013 tutorial

[@coyoteglee]

How many fields can a record have? I want to analyse about 200 factors on about 2000 records, plus attach text files. Will Access get slow or flaky if tables are that big? Somewhere I heard there was a 250 field limit. Thank you for the tutorials.

[@avanthiparanavithana1175]

This is so crispy clear and super.... thank you so much for taking the time to do this God bless you

[@599CD]

Welcome

[@cdeford76]

How do I change the date format to be dd/mm/yy instead of mm/dd/yy ? Particularly on this lesson. Thank you!!

[@soocooool]

Rich , I have a question regarding Emails and websites? How can you change the default application to open an email or a website ? Like for example when you click on a link it opens with Firefox instead of IE ? THANKS

[@ryanpark5483]

You might cover this in another lesson but... I need a unique identifier like "customer_number" that cannot be duplicated. I would use autonumber but I need the number to start at 100 instead of 1. Any advice?

[@eyolove2901]

You should be a teacher. You know how to do it. Thank you Very much!!!!

[@599CD]

I am a teacher... I teach on KZbin. Oh, you mean school teacher? Like... in a classroom and stuff? With KIDS!? Maybe when I retire from this... :)

[@599CD]

Thank you.

[@dylanforsyth6165]

Hi how do U link it to an html web server as I am having trouble with the getting the information in-putted into the html file into the access document

[@ammiejones6248]

Thanks so much sir. These videos are helpful to me.

[@599CD]

You're Welcome!

[@katty0572]

Is there a way to limit the number of records entered into a table. i could really need some help. Cheers

[@599CD]

AutoNumbers are assigned by Access and they can't be edited. They can't be bargained with. They can't be reasoned with. They don't feel pity, or remorse, or fear... and they absolutely will not stop... until they reach 2,147,483,647. :)

[@amyandfriendz]

Great video! The shift f2 trick does not work on my laptop - is there another way around this? Thank you.

[@599CD]

Laptops sometimes map the F keys to different functions like changing volume. You may need to press Shift-Fn-F2 or remap them.

[@idlesue]

and also when i open the file i saved yesterday, the first customerid changed to 10 automatically! idk why! and i can't change it back to 1...

[@seemadevi9171]

Hi Richard, Im stuck with Lesson 6 Part 1. Im unable to type in the data as another keyboard is appearing on my screen and its in Chinese. How do i deactivate it. Pls advise. Thank You.

[@MrNguyendan17]

thanks for the great videos!

[@Kwintessential2]

I am going through the entire series

[@idlesue]

Hi Richard~ i typed 50% in DiscountRate, it showed "0". I thought maybe it was because of the decimal, so i pressed increase decimal button, but then it turned out blank. i tried to re-type 50%, it showed me 0.0000. i don't know how to deal with it now....plz help me, thx~

[@tooa115]

Thank you very much for the Tutorial

[@599CD]

Welcome

[@ศิธกาญจน์สรณะพิบูลย์]

Would you mind if I ask you about how to chage currency from dollar to another currency in Credit limit.Thank you for advance

[@599CD]

Access will use whatever your default currency is set to in Windows.

[@stluke324]

very good tutorial sir..thank you

[@amerk4608]

Hi the Zoom feature keyboard shortuct didn't work for me in Access 2010 in the Notes field...any other suggestions?

[@599CD]

599cd.com/ask

[@samsabbagh4494]

Great Videos , Great tips thumbs up!

[@599CD]

Thank you

[@educatorestrada29]

Today is May 21, 2017, and i would like to hear from you. My question is can i create querys with the headings but no data. Because i have data that must be imported from excel, and inside access, excel will have the power to manipulate different queries. So my intentions later on is to have those queries filled in by the data in excel. Does this make sense. Margarita

[@599CD]

Hi Margarita. Sorry it has taken 4 years to get back to you. I wasn't very good at answering comments back then. You can easily import data from Excel into Access and then use queries to manipulate it. I cover that in 599cd.com/ACX20

[@mihindurajaratne4190]

How do enter several Telephone numbers or is it on different columns???

[@599CD]

I would allow up to 3 phone numbers in a single person's record: home, work, cell. More than that, you should use a second table.

[@Missgemz85]

Can I add more than one email address for one customer?

[@599CD]

Sure

[@599CD]

Autonumbers don't change. Ever. You can't change them either. Something fishy is going on with your database.

[@andrewnapier5565]

Hi there - I've done a full days work on MS Access 2010 and have lost all the data after thinking Id saved it. Any suggestions please on how to get it back . Thank you

[@599CD]

Did you backup your file? If not... nope.

[@599CD]

It's possible, but you have to set up your own security. Microsoft removed user-level security starting with Access 2007. I show you how to do it in my Security Seminar: 599CD(dot)com/XGPT7J

[@priyanshirawal]

you are incredible teacher.........I

[@599CD]

Thanks

[@tcca2002]

Thanks very much!

[@599CD]

welcome

[@listless32]

Thanks for sharing

[@599CD]

Welcome

[@alexandralondono9247]

A very well done!!!

[@599CD]

Thanks

[@Be-wafa-]

gud one bro thumbs up for u

[@Rampage514]

Richard is a swell guy. True. :D

[@vishalmalviya3624]

Thank you

[@599CD]

Welcome

[@599CD]

Yep. I cover relationships in my Expert classes, plus I have a whole video seminar on the subject. Go to 599CD(dot)com/XSCW1Y

[@rcx8666c]

THE SEARCH OPTION AT THE BOTTOM OF THE PAGE IS VERY HANDY.

[@599CD]

My pleasure

[@hebatallahrefaei1098]

awesome!!!

[@599CD]

Thanks

[@jwalkerj28]

I cannot find beginer level 2

[@599CD]

jay walker Beginner Level 2 is only available on my web site here: 599cd.com/XAC13B2YT

[@neurobiogirl]

Thanks again you should teach.

[@harissid]

well man .... now its getting kinda interesting..

[@599CD]

Yah

[@599CD]

Thanks... I think. :)

[@BooRed100]

So you make this video on 15-Sep-201 :)

[@theshkar1]

You are fucking great teacher THANKS ALOT

[@599CD]

Fucking you're welcome. :)

[@tsobw]

There are two types of tutorials. -the one that asumes you know stuff, that if you did, you wouldnt need a tutorial in the first place, -the one, that tells you, that to install a program, you must first buy a pc....hmmm

[@bonitobeats]

About a week ago!!!

[@599CD]

Uhm... OK

[@felixpalmer7665]

hello classmates

[@onfire4000]

Lol it actually does