Microsoft Access 2013 Tutorial Level 1 Part 11 of 12 - Customer Reports

[@Amuma-Igwe]

In my opinion, this is the best online tutorial I have ever come across. I think this guy deserves an award.

[@599CD]

Awww... you're too kind. Thanks.

[@nancybillings7055]

I've been away from databases for a few years and your series has been a god-send. I just wish I had someone like you teaching me years ago instead of just being made to watch over a shoulder and expected to understand everything all at once. Your lessons are easy to follow and I cannot thank you enough. You answer all my questions and the nice part is that I can go back and re-play something if I am not sure that I understood it without holding other people back. I am going to be working with a very large amount of data and with your help, I am not at all scared of it. In fact, I'm looking forward to it!

[@599CD]

Thanks! Glad you like the videos.

[@TikkuDiaries]

Yes, I agree with you, Richard is best.

[@TikkuDiaries]

Awesome. Mr. Rost you are the best in Microsoft Access. You have got the best way of explaining and including every small part of MS Access.

[@ryen1083]

I received a Microsoft Access Assignment from my tutor and he gave us limited information. I was all stressed out and I found your videos online. I completed the whole assignment by watching all 12 videos. You are awesome and thank you for doing this. I will definitely keep watching your videos to better myself.

[@amosnliz]

I had exactly the same experience - was so stressed out because information on my online course was very incomplete, and confusing. These 12 videos were a lifesaver - I was able to breeze through all my assignments after first watching your videos! they were a lifesaver!!

[@599CD]

Glad to help!

[@brucethaeler7616]

Excellent videos! Just finished watching beginner level 1. Have ordered the rest if the beginner series. The instructor is superb!

[@599CD]

Bruce Thaeler Thanks!

[@cobbinakwakwa870]

I have always tried to enroll at a college in my area for non-credit classes for Microsoft Access, Excel, etc to make myself a better person and employable. Then one day, my search online got me to your kingdom. Thank you sooooooooooo much! I don't know how much to thank you for now. Surely one day at the appropriate time, I will come back again to thank you. May Jehovah God richly bless you and your efforts to help millions. Cobbina

[@ClarksonFisherIII]

COBBINA KWAKWA I was with you until Jehova.

[@599CD]

Thanks

[@manuelmusa4966]

I like your approach and delivery style. simple, comprehensive and easy to understand.

[@599CD]

Thanks

[@abdulmujeerchisty5672]

It has been so well demonstrated ..I being a Novice on Access...learnt all the steps until 11/12..shall continue the remaining tomorrow

[@599CD]

Thanks

[@scottlake8806]

I like the level of content and the presentation. Thank you for the free lessons. I have just purchased the next level. This stuff is great.

[@lanalane5267]

This is so exciting, I love finally understanding Access.

[@599CD]

My pleasure

[@leedick4147]

Great course, very clear, concise, and educational, can't wait to start level 2,

[@599CD]

Awesome. Don't know if you got to it yet, but it's here: 599cd.com/ACB2

[@chandans5417]

Dear, These videos are definitely help us to build data tables. Thanks a lot... I would like to go for next levels.

[@soobs2]

Thank you! Used it for my classes. Students love it!

[@599CD]

You're welcome.

[@nickssonreyes5523]

Fantastic Videos, well done, by far the best access training, Thank you!

[@tinabryant5001]

Thanks so much! Your videos are very helpful and easy to understand.

[@599CD]

Welcome

[@ProfIvy]

Thank you very much! These video tutorial were very helpful for my access school project!!!

[@599CD]

Welcome

[@tlovell3597]

i really like it, its very informative, i learned stuff i was not sure of or did not know at all.

[@599CD]

My pleasure

[@peterhaarhaus7149]

Thanks Bruce for your tutorial for free. Appreciated.

[@599CD]

You're welcome. Who's Bruce?

[@miledysdatena9865]

Excellent instructor! The classes are awesome!

[@599CD]

My pleasure

[@07dmackay]

Great training video...I am almost ready to drop my training wheels. Thanks for your help.

[@599CD]

welcome

[@patfrost922]

I've learned how to use images in reports from you - thank you. I have a problem with images displaying horizontally rather than vertically - the image seems to be anchored to the way the photo was taken - portrait or landscape. Can I change this orientation in access 2013?

[@599CD]

Pat Frost Not that I'm aware of. You'll have to use a photo editor and rotate it manually.

[@bahelr]

Thank you very much for uploading videos. I feel so confident now! Thanks again

[@599CD]

You're welcome

[@mangaliewa]

I love your video series. I will purchase additions series. Thanks

[@599CD]

Welcome

[@ASEmastermechanic]

If I print only three labels, I use the database and use the merge feature with word. There I can move things around so I use labels to fit into a label sheet (let's say you only have 3 blank labels on a full sheet). I am sure you know hot to do it. Question, do you know how to add a directory with a map? I seen this one that you click on map and it actually open the internet and shows you a live map.

[@599CD]

599cd.com/MailingLabel

[@areejalfattani3237]

Very Usefull, i like your way of explanation.

[@599CD]

thanks

[@corneliuswiebe9199]

Thanks for the free tutorials. I´ve enjoyed them. With access, is there a way to look up a specific customer´s account, order, etc? I'm talking about some sort of a search bar where you can type in the first and or last name to bring up the purchases/orders made by a specific customer.

[@599CD]

If you still need it: 599cd.com/Ask

[@ryanj.hanson6920]

I am going through this and building the list along with you. I have access 2007, and for some reason when I go to make the report. In the layout view the notes column is holding up condensing the row, it wants to show every thing typed. What can I do to prevent this?

[@599CD]

Don't use Layout View. I hate it. Stick to Design View.

[@georgecanning1146]

These Lessons are AWESOME!!!

[@599CD]

Sweet

[@branimirmilovanovic3068]

I really enjoy your videos. Very easy to follow. Just wondering if you get into how to write formulas as well as macros in later lessons? Thanks.

[@599CD]

Absolutely

[@cavilkrish6128]

I have a question this not related about the topics you share here in youtube, im working with sample project in ms access about order entry, my problem is per category Item or per product item have three selection of unit price, what kind of function to populate the fields once I selected the product item and it's show automatically the selection of unit price. please help me. thank you!

[@599CD]

This is something I cover in my more advanced lessons. I solve the problem with an AfterUpdate event and a DLOOKUP statement.

[@JulieKenk]

I do have a question regarding your labels - Once you created your labels save it what happened if you have more clients- do you have to create every time a new label report or it's automatically updating from the query / table. I am a small home business - even though I don't need to create a report like the way you show, it's still very interesting for me to create label which is necessary. Thank you

[@599CD]

The report updates every time you open it.

[@debmorris7097]

This was very good help me on how to setup forms, reports, etc. and mailing labels which I needed to no.

[@599CD]

Awesome

[@bushraarshad5891]

I am impressed by your approach

[@599CD]

Thanks

[@yoboyce5465]

THANK YOU SO MUCH FOR YOUR SERVICE! YOU ROCK, DUDE!!!!! SERIOUSLY!! A CUT ABOVE THE REST! GRADE A! GOD BLESS YOU!!!

[@599CD]

YOU'RE WELCOME DUDEEEEE!!!!!! SERIOUSLY!!!!! AWWWWWWWW!!!!!!!!! ROCK ON BRO!!!!!!!!!!

[@rcx8777c]

Can you build Access reports into Notepad files ? The Notepad files will then be used by C programs.

[@599CD]

rcx8777c You can EXPORT text files from Access and read those with your C programs, sure.

[@rcx8777c]

PC Learning Zone - Computer Training THANK YOU... I ADMIRE YOUR WORK ON ACCESS.

[@khalifahluciano50]

I hope I'm not really late and never get a response.. My issue creating labels is, that my page size is 4x6. Was that a mistake from the beginning when I created the table or the report. I am unable to change and save the size. When I'm done making the labels it states that my info wont fit horizontally on my page and that I should change the columns. After this I get the option to change the size but my labels save automatically on the 4x6, and when I change the size it doesn't apply to my labels. Is there a way to change this or do I have to save the size I want before I begin? If so How do I do so?

[@599CD]

599cd.com/ask

[@neilk466]

Excellent for newcomer to database work, but I can't format my numbers to show decimals - they default to nearest whole number. What am I missing. Is it in Level 2. Neil

[@599CD]

Use a double, not a long int.

[@GELV294]

Awesome videos! Question. Do you need to pay $1 for each level?

[@599CD]

This whole series is considered Level 1. Level 2 is another hour-long set of videos and that is $1 if you use the special link above. Beyond that, you can also get the rest of the levels for 50% off. The beginner levels normally start at $9.99, so you can get an HOUR-long class for just $5.

[@dimples6596]

Awesome lesson. I learned so much. Thanks!

[@599CD]

Welcome

[@erictsang789]

I really need some help, i am trying to make a report that depends on the input the user enter, like in your case, user input the company name, then trigger the query. It formulate the report. However , when i try again on the input form and found that the query did not work, i have to manuallly refresh a few tme. I use me.requery in the afterupdate in the combox of the input form, in vain Any suggestion Thanks

[@599CD]

Sorry, I'm not quite sure what you mean. If you still need help with this let me know.

[@xiaohanfeng1148]

Thank you soooo much, your tutorial is so good.

[@599CD]

My pleasure

[@samuelcayetano3579]

thanks very simple and well said and easy to learned thanks for your talents en skills sharing for us yur greattt!!

[@599CD]

Thanks

[@crazedspidermonkey]

LOVE these videos.

[@599CD]

thanks

[@keiths427]

Can I use access to create and maintain a work schedule?

[@599CD]

Absolutely. I've got this coming soon: 599cd.com/Planner

[@TheYogina]

Thank you so much for sharing this info.

[@hamzaiqbal3811]

i do not know a single thing about access? do this course will help me from starting level?

[@599CD]

Yep. New one is here: 599cd.com/ACB1

[@manpower3000]

Excellent tutorial - many thanks :-)

[@599CD]

Welcome

[@bobbyebadi3111]

Thank you, I learned something new.

[@599CD]

Welcome

[@VicTor-yg8do]

how to order the next lessons if not residing in the US??for me im in asia..tnx..

[@599CD]

599cd.com/Order

[@balajshoukat2472]

its really helped me alot thanks bro

[@599CD]

Welcome

[@shekuikallon7002]

What lebals is for? Sir I did not understand better

[@599CD]

Labels are little bits of text that go next to your Text Boxes so the user knows what kind of data to put in that field.

[@quranandhadithbeauty7907]

Sir Here you did not include External Data Tab Functions Tutorials/??

[@599CD]

This is a BEGINNER LEVEL ONE course. I cover that in later levels.

[@HelloHaven98765]

How do I make a button that goes to a specific record?

[@599CD]

599cd.com/JC804

[@ClarksonFisherIII]

huge thanks!

[@599CD]

You're welcome

[@shahidpervaiz6647]

excellent

[@599CD]

Thanks

[@iamrexon]

thank you

[@599CD]

You're welcome.

[@hollymovies5282]

thank u sir

[@habibul143]

How to make software ms access

[@599CD]

Watch the lessons

[@sarahqanawaty]

Perfect

[@599CD]

Glad you liked

[@RalphNgOfficial]

TQ

[@sosasosa2181]

Thank you

[@599CD]

You're welcome

[@ottawavalleymaids7915]

thank you

[@599CD]

My pleasure