Microsoft Access Beginner Level 1 - Complete 4-Hour Course

Welcome to the most comprehensive beginner course for Microsoft Access available. My name is Richard Rost. I am a 2023 Microsoft MVP. My videos have been viewed over 30 MILLION times on KZbin. This is my Access Beginner Level 1 course, which is the perfect place to get started if you have little or no experience with Access.
This course is valid for 2007, 2013, 2016, 2019, 2021, and of course Access 365. It's over 4 hours long, and I hope you enjoy! When you're ready for Level 2, it is now available FREE:
LEVEL TWO:
• Microsoft Access Begin...
599cd.com/ACB2
00. Introduction (00:00)
01. What is Microsoft Access? (15:17)
02. Planning Your Database (29:27)
03. Getting Started (51:21)
04. Customer Table, Part 1 (1:08:01)
05. Customer Table, Part 2 (1:33:15)
06. Entering Data, Part 1 (1:54:44)
07. Entering Data, Part 2 (2:15:52)
08. Sorting & Filtering (2:31:01)
09. Customer Queries (2:49:31)
10. Customer Form 1 (3:14:27)
11. Customer Form 2 (3:33:16)
12. Customer Reports (3:43:22)
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.
In Lesson 2, we're going to discuss planning your database. What tables do you need? What fields should go in each table?
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.
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 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 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, I'll show you where and how to download my copy of the database so you don't have to do a lot of typing if you don't want to. We'll learn about record selectors, how to turn off the delete confirmation warning, how to save table layout changes, and how to move columns around. We'll also discuss how AutoNumbers are not reused and why you shouldn't worry about them.
In Lesson 8, we'll learn how to sort and filter our records. You'll see how to perform a single-field sort. You'll learn the difference between text, numeric, alphanumeric, and date sorts. hen, we'll see how to filter records. If the boss only wants to see customers from New York, you'll know how to apply that filter to display the correct records. You'll learn how to print a table or send it as an email attachment.
In Lesson 9, we'll learn how to create queries to display our data in different ways. We'll see how to add a table to a query, add fields from the table to the query, and run the query to display results. Then we'll learn how to add sorting to our query using multiple fields, and add criteria.
In Lesson 10, we're going to build a customer form to present our user with a nice friendly interface for adding and editing records. We'll see how the quick form builder works. We'll learn about navigation, layout view, deleting records, and the different types of forms in Microsoft Access.
In Lesson 11, we're going to learn the right way to build a form using form Design View. This is a preview of a lesson that I normally used to cover in Level 2. We'll learn about setting the Record Source, adding existing fields from the table to the form, resizing objects - your labels and your text boxes - and changing colors.
In Lesson 12, we will learn how to make a couple of different customer reports.
LINKS:
Full Beginner 1 Course: 599cd.com/ACB1
Get Beginner Level 2 for just $1: 599cd.com/1Dollar
TechHelp Video Series: 599cd.com/TechHelp
TechHelp Free Templates: 599cd.com/THFree
ADDITIONAL RESOURCES:
Get on my Mailing List: 599cd.com/YTML
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...

[@patricklimacher8065]

You have a very clear voice and accent, which makes it easy for a foreigner to follow your course. Furthermore, you structured the course didactically very well. I would like to thank you for this nota bene free service. I do not take it for granted. This is very good content.

[@599CD]

Thanks, Patrick. I don't have an accent (which is what everyone says) LOL. My fiance tells me I have an accent, but I don't hear it. :)

[@r.senthilramalingam4861]

I finished the 4 hour beginner training phase. It was a fantastic experience, and only now, after several training films, have I fully grasped MS Access. Thank you for your time and consideration, and please continue to educate us on this subject.

[@599CD]

You're very welcome

[@029fridazerlina2]

Very helpful! I enjoyed your 4-hour course and still continuing to the next course

[@benjaminstewart3694]

Been watching different videos of yours for a few weeks or so now. Love your knowledge, thorougness and teaching style! Keep up the great work!!

[@599CD]

Thanks

[@moizrashid6373]

Brilliant training Richard. You made the the concepts so easy to grasp. I am slowly moving away from Excel to Access for those of my projects having lots of data and not necessarily having to do any data analysis on them. Thanks a lot

[@599CD]

Thanks. You're very welcome.

[@nabilxgmail]

Absolutely brilliant ! Thank you for your dedication.

[@alphaxg1]

This is the absolute best Microsoft Office-based training anywhere! Mr. Rost is a master teacher. I've learned so much in such a short period of time. His teaching style enables fast learning and very strong retention. This is like taking an expensive university course. OUTSTANDING!!!!

[@599CD]

Thank you VERY much for your kind words. :)

[@marcarmando713]

Hi, I just run into your Access 1 tutorial and I can't regret it. I thank God for making our paths met. I wasn't aware what Access has as efficiency tools for effective management. I have a lot to learn and I am engaged to it. THANK YOU A Bunch!!!

[@MagicBanana11]

Thank you for the helpful start!

[@DilipTiwariVlogs]

I bought MS Access Course on Udemy and later on returned as this is far better than those paid courses. You are the best teacher . I would love to learn the Power App from you. Thanks!

[@amanda-sophiap6877]

Soooo good! Great instructor! Thanks Richard!

[@599CD]

My pleasure!

[@Pwecko]

I'm half way through this video and I have to say it is excellent. I paid for a course but found it really difficult. The tutor went straight into building a database in the datasheet view and without preparing any tables beforehand. Even as a beginner, I realised that that wasn't a good way of doing it. Mr Rost, you are a superb teacher. I wish I'd found you first. Thank you for your efforts in making this video and presenting it to the world. You deserve a medal.

[@599CD]

Thank you very much. You're too kind.

[@enchantinglysimple]

I love how clear you are about the learning process and not rushing it! I have adhd, and so this type of instruction works really well for me. Thank you for making these videos for those who want to learn, but have never done it before. - Joseph

[@599CD]

Thanks. You're very welcome.

[@josephsy]

Funnilly enough I was going to mention the same thing, maybe it's a Joseph thing!

[@tahjscott429]

These tutorials are so good, easy to follow and I'm definitely learning. I'm aiming to become certified in MS Access, and will be using your course to do the MS Access Expert Exam. Wish me luck.

[@quasideus1157]

Thank you for this vid of yours i really need refresher like this, gosh all I've learn in my college just flush out of my mind. Thank you, thank you, thank you so much💕

[@599CD]

You're welcome

[@drywaller12345]

Fab. I have Richard's earlier CD's and, as usual, great clarity. Must update my laptop & Office. Thank you. Bill

[@599CD]

You're very welcome, Bill.

[@MoodyAlshehaby]

Thank you, first time for me to open access, and it's going well so far, thanks to you. I admit I was kind of furstrated the first 40 minutes, but after starting getting into access I started to feel good. Will go through next levels and up to the advanced level, I am excited. Thank you.

[@599CD]

Welcome

[@kenlynch8414]

This is a great vid, Access is finally getting into my head after many previous attempts elsewhere. I like this guy, everything is explained perfectly and with a bit of personality and humour....and any fan of Rush, gets my vote every time.....thank you :o)

[@599CD]

Glad you enjoyed it! Rock on.

[@taslimjimah1978]

@@599CD Please sir share the link to Part 2

[@user-eu4qk3oj7b]

This course was perfect for my needs. The pace was perfect, it is easily searchable for reviewing a topic and I greatly look forward to viewing the other videos.

[@599CD]

Awesome. Thanks.

[@carlosalfredo4226]

The best course i have ever attended in my lifetime. Thank you

[@599CD]

You're very welcome. Thank YOU for the kind words.

[@alializadeh8195]

Thanks so much ...

[@augustusmakori5984]

Awesome content. Everything well explained exhaustively. I'd like the next Level 2 series. Looking forward to continue with the learning

[@599CD]

Thanks

[@user-md4gz9cn9v]

very helpful thank you

[@davidbates8455]

FANTASTIC!!!! Please make the next video available. TY😊

[@599CD]

Thank you! Will do!

[@MrAimalsultani]

Welldone. Thanks for sharing the wonderful tutorial.

[@599CD]

You're welcome.

[@kalamehhh]

i was interested in Access long before when I was younger. Now I have a small business that needs a better application than Excel, here I am studying back at your lessons. thanks much!

[@599CD]

Welcome

[@Galstaf]

This is invaluable, an engaging and very thorough foundation. I am taking your advice and not building my company's transition from Excel->Access just yet, but I have already tables, fields and formats well tweaked thanks to this. In the spirit of sharing, around 2:08:00 you are discussing date format and how dd/mm/yyyy is more logical than mm/dd/yyyy - the reason why the US still uses mm/dd is the postal service - vast continent and so people until relatively late were still writing just the month/year on correspondance because the precise day wasn't really relevent when it was going to take a month or two to reach the intended recipient, whereas in Europe even in the 1840s mail would get there in a day or two so people started introducing the day/month to their correspondance much sooner and so when standardisation came along we were in different places. Why the metric system hasn't been adopted yet - there's a several pint discussion.

[@599CD]

I personally prefer the ISO date standard which is yyyy-mm-dd. See 599cd.com/ISO. I have since switched all of my databases to that.

[@dmp7252]

Astoundingly good! Thanks to you, I was finally able to create a powerful multilingual glossary. Managing the terms in several languages was becoming unwieldy. Some glossaries were in Word, others in Google Sheets, etc. But thanks to you, I can use MS Access to create one centralized glossary and from there filter / query as needed. You're amazing!

[@leonmihaescu5651]

Man, you are fantastic; God Bless you!

[@599CD]

Thanks

[@user-vg8io3zr5n]

What an amazing resource! Thank you so much!

[@599CD]

Glad it was helpful!

[@luminancetech]

Very clear voice!! Very good teaching method. Thank you so much!!!

[@599CD]

welcome

[@michaelmutombo453]

Thank you so Richards, much appreciated

[@599CD]

Welcome

[@tassawarhussainnoor8199]

amazing teacher, thanks a lot for such a beautiful video

[@dilrai9551]

Thanks for this lesson.

[@599CD]

My pleasure!

[@desrazor5635]

Dear Mr Rost. I've been doing a Souters course to learn Access, and I've found it a slow and boring process. Thank goodness I found your excellent course. You explain things in an easy, straightforward, manner. By watching your vids, I now understand WHY I am doing things, and that really helps me to learn. If I don't get my brain around WHY I am doing something, then nothing sinks in, I get bored, and my mind wanders. Your teaching method is superb, and I congratulate you. Thank you so much for sharing all this valuable knowledge. I can't wait to put into practice everything that you are teaching me.

[@599CD]

Thank you very much for your kind words

[@atmoms2]

THANK YOU THANK YOU THANK YOU So helpful!

[@599CD]

Any time!

[@patrickwinham]

This video was sooo good. I went from knowing nothing to feeling like I can actually use access well.

[@599CD]

Sweet

[@blackbird7n90]

This is probably the first time i finally get to understand how to use Access. i understand its use and benefits, but never have i used it first hand properly. I am eager to get to your advanced classes that talk about VBA, but i need to have patience to learn the basics first haha Thanks Mr. Richard for your time and effort, hope you are doing well.

[@599CD]

You are very welcome thank you for the kind words

[@mikesamyn7054]

I am very impressed with the work you've have done to teach Access. Back in 2001-2008 I developed an Access DB for our engineering group to house combustion engine design and test data. Learned it through books and hard knocks, but boy I could have used this set of KZbin classes! Hats off to you. I am again strating back into Access to magange a much simpler set of data for my HOA. With your help it will make my job much easier! Thanks you for the refresher.

[@599CD]

Yeah I wish I had my tutorials back when I started learning Access in 1994 LOL. If you're making an HOA database check this out 599cd.com/Assoc

[@mohamedkanu66]

As a Network Administrator, I was looking for a place to get some database grasp b4 proceeding to learning SQL. In all sincerity, I thank the day my mouse said click here as I am fascinated about dbs having gone through the 4 hours tuts. Thanks for the great mentorship boss. Heading to your site to purchase Beginner Level 2. Just looking to climb the ladder from here!

[@599CD]

Awesome. Thanks for sharing! Glad you like it.

[@edwardsapu2032]

I really enjoying this great lesson

[@599CD]

Awesome! I appreciate that.

[@TikkuDiaries]

You are the best MS Access Expert and Guide in the World.

[@christy967]

Gosh thanks so much I've definitely learnt a lot

[@599CD]

Glad to hear it!

[@nwachiikechukwu257]

Good teaching, very interesting and comprehensive. Thanks alot!

[@599CD]

Thanks

[@Vic-wb7gs]

The best four hour of instruction I’ve experienced. I’m on to lesson 2

[@599CD]

Thanks

[@missread7781]

Thank you so much for this course. I just wanted to let you know that I personally found it easier to design a form using US measurements in Design View. (I changed it from metric in windows settings as I live in UK.) Also you are never too old. I am 71 and a membership secretary for a local lace making group. Previous secretary used a spreadsheet. Ok stop screaming yes it was a nighmare. This is so easy to follow. You can teach an old dog..... Thank you again.

[@599CD]

Thank you. And yes, inches are easier in Access. :)

[@musisir1927]

This is great. Thanks a lot Mr. Rost.

[@599CD]

Welcome

[@asarand]

I have some experience with Access, but it was (I think) the original version from back in 1999-2002. It was included in Office Pro, which I purchased for my Windows 2000 computer. I was learning Office as part of my curriculum at DeVry, though they didn't cover Access, so I was teaching myself. After that Access was removed from Office at some point, so when I came back to it with Office 2016 I was unable to continue with it. When I purchased Office 2021 I had to purchase Access separately. I have forgotten most of what I knew before, but watching your 37 minute video helped me remember the basics. Now I'm trying to remember relationships, but I am watching this entire video (and will be building the sample database you walk us through) so I can make sure I glean everything I never knew. I just went to your site. Things have changed since you made this video and the page the link goes too isn't the same. I had to hunt to find the database file.

[@599CD]

Database file should be here: 599cd.com/ACB1L

[@activedogservices]

OK, got hooked knowing Captain Picard is a customer from the late 24th century, I guess he is on Access 2350. Unsure if the Ferengi want this close a scrutiny over there afairs with so much organisation. This is truly brillaint and yes will go onto the next lesson and beyond. I was scared stiff of using access however this has made it so simple to use. Yes keep going over and repeating it really has helped, this is the first data base in access I have built and so far its been a doddle. Thank you.

[@599CD]

Ha ha. The Federation found an old copy of QuickBooks and sent it to the Ferengi Alliance. They're still trying to figure out what to do with it. I'd say QuickBooks is a virus... but a virus actually DOES something. :)

[@michaelsvenson2456]

I started like you in the mid 90´s. Northwind Database, but I was so lost when i tryed to understand it so I thought it was to hard for me. Most of my learning was by trial and error, and it worked then, everything, forms, tabels, reports, pictures and buttons, but was not so professionally done as your databases. Your videos is great, easy to follow and with a little humor in it. Nice work. :-)

[@599CD]

Thanks

[@sniper59kta]

thanks , nice Tutorial

[@599CD]

Welcome

[@bradburkham7817]

This is my second time through and am still learning stuff I missed last year. MY RECCOMENDATION to students is have 2 screens, one to run the video and second to build the database. Work your way through the database start, stop and rewind as needed following along, I don't type as fast as your instructions.

[@599CD]

599cd.com/QQ

[@capitalinstitute9183]

Ultimately i watched this video, it was really interesting and best for me because i am access beginner waiting restlessly for level 2,3 and so on. Please upload them soon bundle of love from Pakistan.

[@599CD]

Glad you enjoyed it. Levels 2 and up are ONLY available on my web site. They will not be uploaded to KZbin. Go to 599cd.com/ACB2

[@silverharmony8675]

your customer names are THE BEST

[@shafiqueahmad9024]

Your way of teaching is very very good. You are my hero

[@599CD]

Sweet. Thanks. :)

[@capitalinstitute9183]

Thanks for such great video sir

[@599CD]

Most welcome

[@jeetendrasinghbhadauriya3395]

THANK YOU SIR

[@599CD]

Most welcome

[@nour-eddineoumakhlouf5296]

Thanks for your efforts

[@599CD]

It's my pleasure

[@kerrbearofaustin]

You are awesome.

[@599CD]

Thanks

[@markkinkle7038]

You are amazing. This content is going to help me optimize business processes for a large government organization. The work you are doing is so important. You will be blessed.

[@599CD]

Thanks

[@dream2508ful]

BEST TEACHER, IT'S AMAZING LEARNING AND HAVING FUN

[@599CD]

Thanks

[@SvenJanssens]

My goodness , so great to have found this. Even considering joining the channel. I have been looking for someone to build a good database for our foodbank, that should hold a lot of information and date calculations, etc ... Since I can't find anyone ... LOL ... (figures) I have been looking to use MS Access as a platform to build the database on. Looking around the net ... I found your channel and seem to like it. :-) Thanks for all of this. It helps. I have high expectations and I think they will be fulfilled.

[@599CD]

Sounds good. :)

[@biro313]

thanks a lot :) , it is a useful course

[@599CD]

Glad to hear that!

[@edwardsapu2032]

Richard Rost you're great.....

[@599CD]

Awww... gee.... thanks. :)

[@reachin4thetop709]

this is great material

[@599CD]

Thanks

[@tinalouiseginger9711]

After having years of experience with Excel (transitioning to Access for efficiency) - I found this four-hour class a tiny bit excruciating (just because of the pace - can't go THAT fast - so understandable) BUT! Tips and tricks aren't quite "Easter Eggs" - but if you didn't know to look for it, it almost rises to that level of awesomeness. :)😃

[@599CD]

Thanks... I think? :)

[@saleem2148]

Good best teaching way

[@599CD]

Thanks

[@sonamdorji7176]

I love the way you teach sir.....

[@599CD]

thanks

[@Scientificandresearch]

Very useful

[@599CD]

Glad you think so!

[@gjonmarku6719]

This is a great tutorial.👍👍👍👍👍

[@599CD]

Glad you liked it

[@mrglass311]

Good information taught. Personally, I thought there is a lot of over-explaining. Could probably be cut down to 2 hours, but I understand it is for beginners and not all people grasp information the same. Thanks for the course.

[@599CD]

You are correct. It's for beginners, hence the title "Beginner" Level 1. :)

[@Khuram_Shahzad]

Excellent Teacher, You won a new subscription. ❤️ From Pakistan

[@599CD]

Sweet

[@user-ng1ys6pz4h]

Can I just say that I love the shoutout to the Star Trek Next Generation characters! Awesome.

[@599CD]

Sweeeeeet

[@abdulahadkhamsoh3229]

Hi sir You are a good teacher ever, I will download your videos. Thanks a lot for everything. And sorry for downloading your videos from KZbin. I am from Afghanistan and we have internet problems here.

[@abdulahadkhamsoh3229]

Please allow me to download your videos to storage, 😢

[@umairpioneer]

I've completed your 4 hours+ beginner course yesterday. It was incredible. I kept patience as you'd repeatedly said, don't jump! Lol. Nevertheless, I enjoyed your class it was a really good start.

[@599CD]

Glad you enjoy it!

[@partner779]

thank you Mr Richard for your perfect videos... my database project is almost done, and it has been useing since Jan 23 and works will. but the problem is, it removes all objects such as forms, quires, modules and reports after some days or months! just all the tables remains with all records inside ! I don't know why it happens ?? the only way for me is to import all it's tables to another database to restore it like previeus, even if I want to import object form other database to the main database, it doesn't show them!! thanks for your greate idea..

[@elreenmatawaran3057]

It's so coincidental that I am going through this tutorial same month and day the video was filmed but in different year... I was stunned when you clicked the calendar icon in CustomerSince field and it showed Feb 24.. 😅

[@599CD]

Freaky!!!!!

[@finleydavis118]

I’ve scanned through the comments and I can’t find the answer...where exactly are the links listed below? I’m not finding any and every one of these FANTASTIC lessons describes links below to find bits of information that I would like to learn! This has to be one of the best Access classes I have ever played.

[@599CD]

Easier to find them on my web site: 599cd.com/ACB1L

[@friendfortheartists]

Your presentation is excellent. This stuff can lean to boring, but you kept it thorough yet interesting. In fact, your video is the best presentation on KZbin. Looking for a place to send subscribers for a complete Access Training Course. I used to program with Clarion as well. Learned a couple new tricks watching this video. Going to be building a little Access database for camera and art materials. I did not want to start from the beginning in database training. Hope you do not mind the referral. It does not make sense to reproduce a video when there is already one done very well. The video will cover and act as documentation of the Art Materials database. Intend to make the database available to subscribers of my Channel.

[@599CD]

Why would I mind referrals? LOL. You are of course more than welcome to point people to my videos if they need to learn Access. Thank you, and thanks also for the compliments.

[@golfrep2584]

Thank you for this video series. Can you send me the link to the next video? 👍

[@599CD]

599cd.com/ACB2

[@mdnureazam2858]

I finished Total course it's Ammezing, Great Jod Sir. Sir I from India, so it's so difficult to catch your language plz Say slowly then we can understand easily. God bless you Sir

[@599CD]

I speak how I speak.

[@suzierj2002]

Your training is wonderful! Do you have a suggestion or a video on a membership data base that we have a spouse and children associated with the account but would need to pull up the spouse at any given time. So like we have John Doe but spouse name is Jane Smith . . . would you include her with John Doe or create a separate membership?

[@louismancuso6263]

I would like level 2, please

[@599CD]

Level 2 is online. 599cd.com/ACB2

[@user-ce9xz4hz3p]

Like your training style very much. Quick Question, Is Access a suitable Application for Notification Tracking where, 1) one wishes to Reduce Data Entry workload by having only to enter relevant Data in one Table and allowing identical fields in other related Tables of the Database be automatically populated /updated without the necessity for duplicting / repeating data entry into those different but related tables, and 2) where it is envisaged to include a field with a short abstract / notification txt summary up to 1000 words / 10,000 characters). Thanks

[@599CD]

Absolutely

[@MarTin-dn9oe]

Richard, I love your lessons you’re doing a great job. I have a fund that holds money for several clients. They send me their bills and I pay them for the client. Is there anyway I can scan their bills into access for future reference.

[@599CD]

Sure. Scan them as images and then use this technique to track them: 599cd.com/Images

[@MarTin-dn9oe]

@@599CD thank you somuch

[@Polymathicus]

What's the best practice for a "clients" table creation when my clients aren't necessarily a specific person or company. In other words, I might have a client that doesn't have a company, or they are employed at company, but might go to another company, and I may be still working for their replacement at that original company now, and also them at the new company. And now I need to somehow keep track of completed and future jobs and tie them to the above mess. How should I build my "clients" table to prepare for the above scenario? Thanks!

[@599CD]

The BEST practice is to have a separate CompanyT table and a PersonT table. Use a many-to-many relationship to join them. However, this is a lot more difficult to explain to a beginner than just putting a CompanyName field in a customer record. See 599cd.com/ManyToMany

[@LHPottery]

A friend of mine once told me that planning should take 75% of the time it takes to build a database. She was right.

[@599CD]

Not sure if it's that high... but damn close. The more time you spend up front planning, the lesson "oh shit!" moments you'll have later. :)

[@LHPottery]

@@599CD Then again, she worked with mainframe computers, not Access...

[@user-up6st2mk2q]

This course is fantastic, but I could use your script for each slide. Or, do you have a hard copy I can get of this course?

[@terribowman7542]

Our employee's have their own ID numbers, can I use those instead of your customer (or employee) ID? Our ID's are how we identify employee's in our other systems, which is what I would want to use for relationship purposes. Or do I need to use that particular field for tracking? Could I use their employee ID as the Primary Key?

[@599CD]

You could add it as a secondary key, but I strongly recommend using Autonumbers for relationships inside your database. Hang on to those existing employee IDs if you want. 599cd.com/Autonumbers

[@mustafamohamedali6555]

Hi , could you please explain the maximum ms access db size in GB , users , Performance? Is it supposed in big applications? What are rules here? Thanks in advance for professional contents

[@599CD]

Benefits of Access: 599cd.com/Benefits

[@so_gr8_4]

Hello Richard, great video!! I have some questions for you, how to query DOB's? If I want to see all the birthdays for each month. Would it be easier to have it like for an example 01/01/01 or Jan 1st, 2001? Also is it possible to do a query with partial data, like month & day without the year?

[@599CD]

599cd.com/DateSerial

[@599CD]

A valid date field requires all three parts: M/D/Y

[@AngkelJojo]

i used access 2007 is this fine? I like the way you teach us

[@599CD]

Yeah there's not a lot of difference between 2007 and today that was the last major overhaul

[@totoghertpaclibar8176]

Thank you. It helps me a lot

[@599CD]

welcome

[@shontaduncan6072]

Can an access database be used to automate tasks, like send confirmation and reminder emails, and notify staff of updates to appointments?

[@599CD]

Yes, absolutely. 599cd.com/Timer

[@georgerlopez]

I agree with all here. Your method and the speed is dead on. I have a program that is no longer being made and updated. They recommended that I go to another provider, but its based on Access and I have the tables. I will be looking to impport and to create my own interphase. Can you provide a link to an import class?

[@599CD]

599cd.com/import

[@minpeaceandlove4210]

What about case sensitive? If I have a vendor USAirConditioning... If I search without caps, will it find my search?

[@599CD]

Check that Match Case box.

[@dlojan5786]

How can i add new record but not in the end of records i want to add new record in between two existing records ????? please advise if you can

[@wattjock2405]

Thank you for this course! I am having an issue with the date/time cell... I type in 55 and it tells me that "the value entered does not match the date/time..." The field is set as date/time... any recommendations for this issue?

[@599CD]

Well if this is a date time field then 55 is not a valid date time so you'll have to enter something in that's either a date like 1/1/24, or a time like 5:50, or both.

[@Lacronh]

We only have Access 2000. What's the best place to get a really cheap version of Access 2019?

[@ThreeGsHomeschool]

We homeschool our 2 children. I am wanting a digital program to keep of with their classes, grades, and attendance. I would like to be able to run custom reports (report cards, attendance reports, or transcripts). Would you suggest access or Excel? Also, would you be interested in creating this program? Thank you for all your videos, I purchased a bunch of the Excel ones a few years ago.

[@599CD]

599cd.com/qq