Microsoft Access 2013/2016 pt 1 (Tables)

[@Arawnasumikat123]

Amir, I been browsing many access video but i find your video quite educational and instructive. I have learn a lot. i even replay your video so that I can easily understand it and memorize your instructions. Thank very much. God bless.

[@AmirParmar]

+Bert Gaspar Great! Try to understand, rather than memorize, see if you can see the big picture. And understand the things that are possible, this way, you will need to remember less. All the best.

[@ManuelVargas619]

Amir, your are the best instructor I seen. Thank you for sharing.

[@AmirParmar]

Thanks Glen. Creating these tutorials has been a lot of fun and comments like yours make my day. All the best.

[@GlenPridgen]

Well done Amir, you are a master at these training videos.

[@adamlesniak4571]

Hey Amir. Great job, mate. Thanks for putting in your time into these videos for our benefit. I appreciate it.

[@surelygracekamtaura1209]

I must say that you are good...I have been struggling to understand the basics of Access program....thank you so much :)

[@somintiefresh]

Just wanted to say that this video was helpful. Thanks for the time and effort!

[@teodorkrantov8378]

me too

[@supergenkilife]

Wonderfully informative and succinct video, sir. Thanks so much. I am preparing for the MOS Certification Exam for Access, which I've not had much experience with, so this was a perfect intro in such a short time. Much better than the hours of video I watched last week or some texts that have too much extraneous information and not enough lucid organization. Cheers!

[@LG9223]

wow you Mr are the best :) i am going to watch the other parts too, really helpful.

[@AmirParmar]

Hi, Access 2010/2013 are pretty much the same. The one major difference with Access 2007 is that in 2010 & 2013 you can create Calculated fields in Tables itself. In 2007 you have to create Calculated fields via Query or in a form or report. Hope this helps.

[@AkhtarAli-xd2sy]

Its really very understandable. Thanks Mr.Amir

[@AmirParmar]

Thanks for the feedback Adam. Very glad that you found these videos helpful.

[@JenBuilt]

Smart and articulate tutorial. Thanks!

[@ezz09]

Thank you. These videos are very helping

[@smorisch]

Amir, Thank you for making this video. As a seasoned database developer, it was odd to me that we could not make a Lookup field that allowed us to add a new option. I'm now using 2016 and we still can't do it. In the database you're attempting here, when you started to type you didn't finish that. You can type, yes, but Access still returns an error and does not retain the data if it does allow you to complete the typing. In a form, as you teach later, we can just add the new option from the form. Thanks again~

[@AmirParmar]

+Sherry Morisch Hi Sherry, sorry for the delay, was busy taking care of my father. In the table when you use the Lookup Wizard and choose "I will type the values manually" in the last step, if you don't choose "limit to list," Access should allow you to type another Word that is not in the list. I tested it and was able to type another word. In your database, check to see the whether the Limit to List is set to Yes, in the Properties (LookUP) of that field.

[@smorisch]

Right and it will, but it doesn't store the word like it used to. I was able to type in the field when I deleted it row and re added it with the limit to list unchecked. However, in 2016 it isn't storing the word anywhere. It's almost like you have to add an Add button in the form, which is fine, that's an ok work around.

[@yassinibrahim6063]

Thank you. Extremely helpful video.

[@rahmani134]

Thanks very much ,your explication are so good.

[@ehsanmashkoor6625]

Amir, Thank you for making this video :)

[@sunilcolins6250]

Hi Amir, good videos...just a quick one...here you have mentioned about selecting cities from look up wizard....If I select a country and I want to see only cities related to specific country...how would you do that...

[@AmirParmar]

Hi Sunil, I talk about it in my video on Cascading Combo box which uses tables and form to display cities specific to country/state. Microsoft Access pt 9 (Cascade Combo Box)

[@sunilcolins6250]

Thanks a lot Amir...

[@Javbo03]

Hi Amir, The videos are great. Are there any huge differences between 2007/2010 and 2013? Could you briefly explain what they are if they are any?

[@Akbar.Ali300]

Thank you So Much sir, You are the best. Plz upload video about SQL database. Your Teaching Method sooooo gud so plzzzzzz upload SQL Database video ...

[@AmirParmar]

Hi Akbar, very happy to know that you found the tutorial useful. I have never had to use SQL, so have never bothered. I would highly recommend sql course on coursecademy, in fact many of their courses are good. I am currently finishing up HTML/CSS course www.codecademy.com/learn/learn-sql all the best.

[@warishaism]

hey! i want to add No. of professional certificates of each employee with its Title in Employees Database sheet. Will you please guide me in this?

[@AmirParmar]

+warishaism No sure if i understand your question correctly. But if you want to add a field for how many professional certificates an employee has, than just insert a Row somewhere and add a Field for Professional certificates.

[@rebazrsb]

Hello Amir I have a question if it's allowed, I created a database I want work only on one computer , I mean if I gave a copy to my friend he couldn't share it only myself do it whats the procedure and whats VBA code for doing it , and I have a database applied those things but it saved as ACCDE and shift is disabled I cant open it , I will send you if you like, thanks to your response.

[@AmirParmar]

There are ways to hide the table, queries and only let people see the form. Even the VBA can be hidden. But if someone has the whole database and it does not have a password, they can share it with others.

[@rebazrsb]

Ok, Thank you very much

[@nonsookafor722]

how can i change the cost price in my product table without it affecting past data

[@AmirParmar]

+nonso okafor how is your relationship set up? Do you have separate table for Products, Customers, Orders etc.

[@nonsookafor722]

yes i have a separate table for customer product and order.... in product table, i have the cost prices while in my order i have the selling price and quantity, i noticed that whenever i change the cost price of a product, it automatically affects all my previous transactions and calculations.... how can I change it and maintain my historical data?

[@AmirParmar]

+nonso okafor The price in the Product table will change from time to time, the way you see the historical price will be in table Orders, as that table keeps track of orders with their dates and price. I hope this makes sense. Or send me a private message or from my website and I will email you a sample.

[@AmirParmar]

+nonso okafor and if you want the historical data of Cost Price, I suppose you could create a separate table and enter the product and their price and the date when they changed.

[@aishwaryabharadwaj559]

can you please tell us how to create a login page using visual basic studio-2017

[@AmirParmar]

never did that, but see if this link helps www.visual-basic-tutorials.com/form/Login-tutorial-database.htm

[@pelayomenendezdeluarca5875]

I like your english

[@timothyanderson9750]

Hi Amir, I am working on importing data into a table in Access 2016 and every time I try to import the xls worksheet it tells me that the subscript is out of rang. I have run into this error several times. I don't know how to correct it. Could you please explain how I can correct this error?

[@AmirParmar]

how many columns does the excel file have?

[@natashalewis7284]

Thank you so much :)

[@yeakleang]

Thanks for this video. It is very helpful.

[@teodorkrantov8378]

cool

[@kencassyh]

Thank you I need to add tables

[@ASgfjyhgyi]

Aaaa!!!!!! Databases!!!!! They everywhere!!!!!!! Next serial will be "Walking Databases"!!!!! :)

[@moveon001]

Sir, I want to create a invoice for where i work. can you help me. Please help me & give me your email id.

[@AmirParmar]

+ANOOP KUMAR one of my videos gets into creating Invoices via query/reports. Send me an email on my contact page of my website. If I can manage time and know the answer, will try to assist you.