Hi Yinzi, no problem at all. Access MOS is a tough one, and you'll need 700 points to pass. Don't take too long on any one question, you can always go back and retry the tough ones at the end. Good luck on your test this Friday, let me know how it goes.
Hi, I took the exam this morning, I got 746/1000, so I passed!!! Thank you so much for all those Access videos!!! There is not many MOS exam targeted videos online, so really appreciated!
Yinzi that is great news! That's the toughest test out of Word, Excel, Access, and PowerPoint in my opinion. Glad the videos helped out. Make sure you get the PDF copies of your certificates, as employers may ask for them in the future. Great job!
Hi Adam, is there a way to add multiple rows on the text form fields? If none, what other similar functionality can i use? and also do you have a tutorial on that in MS Word 2016?
Hi Jette, No, you would need to add the fields in the form/table individually as far as I know. If you find a workaround for this, please let me know. I have an entire playlist dedicated to Word, here is the link: th-cam.com/video/UOaPNaM4odw/w-d-xo.html
This is helpful! I have a database with multiple tables and need to add another field from a different table than originally used. Can you show us an example of adding a field to an existing form from a separate table?
Hi Ballparkmom00, I am glad that you found this helpful. You can create a query that contains fields from multiple tables. It's the easiest way to combine data without having to recreate the data. Please watch this video, it should help; th-cam.com/video/YWjQcra9dOc/w-d-xo.html
I am working on lists to which tables refer. I am trying to develop the relationship between a field called "type" in table #1 to another table #2 which also has a field called "type". when I view the table #1 in relationship view, the field table "type has a -sign to the left of the "type" and and indented "type" below it. How do I get rid of the indented "type" so I am working with "type" to connect the relationship line between types in both table #1 and table #2?
I use the contacts database and they have field that is called OPEN. I wanted to make my own database and was wondering if u could tell me how to insert that field? I tried to add that field but was not able to find it.
Hey so I solved an issue I had that your video led me to - I was looking for a field that wasn't showing up in the field list . I just found the "show all tables" button at the top of the field list - this shows you all of the fields of all (related?) tables in case you can't find something!
Hi Tim, Yes, absolutely. That option will show all of the table fields and tables within the database. Sometimes, users may hide tables or fields for whatever reason and you need to show all fields to see them. Thank you for sharing.
Hi James, Yes, you can make whatever changes you want to the template. Then go to Save As, and where you choose the file type, choose Access template. From that point forward, you'll see it listed under your personal custom Access templates. I hope this is helpful for you.
Hello Adam. Thanks for all of the videos. You are an excellent teacher. I have a question in regards to Access 2016. I created a split form. After the form was created, I realized I needed to add a few more fields to the table. Once this was complete, I edited the split form (top) section and added these new fields. That was the easy part. My question is, how to I add those new fields to the datasheet (bottom) section? Please help.
Hi Vince, Thank you so much, I am glad you're finding the videos helpful. As for your question, it's kind of hard for me to answer it without seeing the form in front of me. Have you tried creating a new form with the new fields already added in? If it's not too much trouble, try doing that. Also, I have a video on subforms which might be helpful for what you're doing. Sorry I can't help out more on this one.
This tutorials are just amazing, I am all interest in DATA management. I have an access DATA base and an entry form but i would like to know how i can add a button that will bring an additional field that will be used to add information as an update information to a client records if needed, after that how will i do to hide all other view mode and only allow the DATA entrant to access the entry form only using a password. thanks
Hi Kinumbe, Thank you, I am glad you've enjoyed my tutorials. You may want to run an update query to show the additional field information that you're looking for. I'll add a link to that as well as password encryption since I do not currently have any tutorials on these subjects. Thank you for watching and have a nice day. Here are the links: Update Query: support.office.com/en-us/article/create-and-run-an-update-query-9dddc97c-f17d-43f4-a729-35e5ee1e0514 Password Encryption: www.quackit.com/microsoft_access/microsoft_access_2016/howto/how_to_password_protect_a_database_in_microsoft_access_2016.cfm
Hello, If an action queries appear in the list box control, how can I remove it so it is no longer displayed in the list box and as well as not in the database? Thank you!!
Hi I’m trying to add a field into the tables before I can add into the form but I don’t have the “click to add” tab... is that because I have too many fields already?
Hi xoanniebear, No, it shouldn't be because you have too many fields. Try opening the Table in which the Form is from. Then right-click on where you want the field to be added and click insert to add in a new field. I think this should fix it for you. Then you could add the field to the form the same way as shown in this video. Thanks for watching!
Hi Adam, I am having issues with a form that was previously created in my database because when other employees use the form and select an option from the drop down box and hit enter, the form disappears and the next form is the next entry from the table in which the form is created from. The dispatch reps using the form cannot re-access that same form that they previously altered to change or modify their drop down selection. How can I change the form or table settings to allow the employees to go back and see the form that they previously altered? Thank you,
Hi Jesse, If the original form is gone, then you'll need to recreate it based off of the original table in which it came from. For this, you'll need to create a combo box. I don't have anything like this on my channel, but I found a link that discusses what they're used for and how to add them to Access. I hope it helps you:support.office.com/en-us/article/add-a-list-box-or-combo-box-70abf4a9-0439-4885-9099-b9fa83517603
Greetings from indonesia, Prof. Morgan. I am making a restaurant order form on ms access 64bit. I would like to have a wav-file playing everytime a quantity is added onto the order; an on-click-event that, in addition to manipulate the value of the field, also plays a wav sound. I am using 64bits access; i have sample-instructions for 32bits-access but i do not know how to fix them to work on 64bit access. Will you please teach us? Please help. Thankyou immensely.
Hi Pelajar, Thank you for watching from Indonesia! I am sorry but I actually do not have experience using sound files within Access. I wish I could help you out with this. Let me know if you find a solution!
I want to be able to select a statement to a form from a dropdown list or from a table, but the number of statements I need to chhose could vary so I want to be able to choose if I want to select an additional statement until I am done.
For this, you'll need to create a combo box. I don't have anything like this on my channel, but I found a link that discusses what they're used for and how to add them to Access. I hope it helps you: support.office.com/en-us/article/add-a-list-box-or-combo-box-70abf4a9-0439-4885-9099-b9fa83517603
can you do a form when you select a certain data it automatically fill the 2nd one, example if i choose BSCHEM course itll automatically select the chairman of that course
Hi Randel, I'm not too sure on that. It would probably be an IF function but I haven't tried that before. I'll look around the web and see if I can find anything to help out.
Randel, I found a link that might be able to help you out. Give this a shot and see if it works out: support.office.com/en-us/article/dlookup-function-8896cb03-e31f-45d1-86db-bed10dca5937
Hello, Im new to access and I have an issue when adding a new data in a column. It says " The text you entered isnt an item in the list " and I press yes but still it doesnt add it. How to deal with the situation? Thank you so much.
I tried adding a field in one from from another table, but when I do this and I try to view the form in form view. I get a white page. What is the work around this?? Thanks
Hi Patricio, Try deleting the form then recreating a new form based on the original table. That should reset the formatting to include all available fields. I hope this helps you out.
Thank you very much!! You demonstrated this topic very clearly, I'm taking the test this Friday, this helps me a lot! Thank you!
Hi Yinzi, no problem at all. Access MOS is a tough one, and you'll need 700 points to pass. Don't take too long on any one question, you can always go back and retry the tough ones at the end. Good luck on your test this Friday, let me know how it goes.
Hi, I took the exam this morning, I got 746/1000, so I passed!!! Thank you so much for all those Access videos!!! There is not many MOS exam targeted videos online, so really appreciated!
Yinzi that is great news! That's the toughest test out of Word, Excel, Access, and PowerPoint in my opinion. Glad the videos helped out. Make sure you get the PDF copies of your certificates, as employers may ask for them in the future. Great job!
Thank you!!!
This video was quite clear regarding my issue and with example, made may understanding clear. I will try and will work.
Great! Thank you for watching, Shailesh!
Thank you Professor Adam!!!! you save my day with this tip.
Nice video.. What are the major skills to learn in MS access for beginners must knw.. Plse guide sir..
Hi Adam, is there a way to add multiple rows on the text form fields? If none, what other similar functionality can i use? and also do you have a tutorial on that in MS Word 2016?
Hi Jette,
No, you would need to add the fields in the form/table individually as far as I know. If you find a workaround for this, please let me know. I have an entire playlist dedicated to Word, here is the link:
th-cam.com/video/UOaPNaM4odw/w-d-xo.html
Thanks, In my case I want to open another form in existing form conditionally, if possible please elaborate on that.
This is helpful! I have a database with multiple tables and need to add another field from a different table than originally used. Can you show us an example of adding a field to an existing form from a separate table?
Hi Ballparkmom00,
I am glad that you found this helpful. You can create a query that contains fields from multiple tables. It's the easiest way to combine data without having to recreate the data. Please watch this video, it should help;
th-cam.com/video/YWjQcra9dOc/w-d-xo.html
Thank You bro! I appreciate it.
I am working on lists to which tables refer. I am trying to develop the relationship between a field called "type" in table #1 to another table #2 which also has a field called "type". when I view the table #1 in relationship view, the field table "type has a -sign to the left of the "type" and and indented "type" below it. How do I get rid of the indented "type" so I am working with "type" to connect the relationship line between types in both table #1 and table #2?
I use the contacts database and they have field that is called OPEN. I wanted to make my own database and was wondering if u could tell me how to insert that field? I tried to add that field but was not able to find it.
Thank you for the video, but what if the field is not in a the “add field list.” How do you add a completely new field?
Hey so I solved an issue I had that your video led me to - I was looking for a field that wasn't showing up in the field list . I just found the "show all tables" button at the top of the field list - this shows you all of the fields of all (related?) tables in case you can't find something!
Hi Tim,
Yes, absolutely. That option will show all of the table fields and tables within the database. Sometimes, users may hide tables or fields for whatever reason and you need to show all fields to see them. Thank you for sharing.
Excellent tutorial. Is it possible to modify an Access 2016 template form, if so, how so, please?
Hi James,
Yes, you can make whatever changes you want to the template. Then go to Save As, and where you choose the file type, choose Access template. From that point forward, you'll see it listed under your personal custom Access templates. I hope this is helpful for you.
Hello Adam. Thanks for all of the videos. You are an excellent teacher. I have a question in regards to Access 2016. I created a split form. After the form was created, I realized I needed to add a few more fields to the table. Once this was complete, I edited the split form (top) section and added these new fields. That was the easy part. My question is, how to I add those new fields to the datasheet (bottom) section? Please help.
Hi Vince,
Thank you so much, I am glad you're finding the videos helpful. As for your question, it's kind of hard for me to answer it without seeing the form in front of me. Have you tried creating a new form with the new fields already added in? If it's not too much trouble, try doing that. Also, I have a video on subforms which might be helpful for what you're doing. Sorry I can't help out more on this one.
Thank you so much! This is helpful. :)
Im wondering if I can add a ( In/ Out ) barcode system with scanner and barcode printer into Access? for spare inventory management
Hi Rafal,
I'm sorry, but I don't know the answer on that one. I know you can add an in/out field, but not sure about the bar code printer.
This tutorials are just amazing, I am all interest in DATA management.
I have an access DATA base and an entry form but i would like to know how i can add a button that will bring an additional field that will be used to add information as an update information to a client records if needed, after that how will i do to hide all other view mode and only allow the DATA entrant to access the entry form only using a password. thanks
Hi Kinumbe,
Thank you, I am glad you've enjoyed my tutorials. You may want to run an update query to show the additional field information that you're looking for. I'll add a link to that as well as password encryption since I do not currently have any tutorials on these subjects. Thank you for watching and have a nice day. Here are the links:
Update Query: support.office.com/en-us/article/create-and-run-an-update-query-9dddc97c-f17d-43f4-a729-35e5ee1e0514
Password Encryption: www.quackit.com/microsoft_access/microsoft_access_2016/howto/how_to_password_protect_a_database_in_microsoft_access_2016.cfm
Hi Adam could you please make a video of how to make labels, text boxes, and a combo boxes.
Hello,
If an action queries appear in the list box control, how can I remove it so it is no longer displayed in the list box and as well as not in the database? Thank you!!
Hi I’m trying to add a field into the tables before I can add into the form but I don’t have the “click to add” tab... is that because I have too many fields already?
Hi xoanniebear,
No, it shouldn't be because you have too many fields. Try opening the Table in which the Form is from. Then right-click on where you want the field to be added and click insert to add in a new field. I think this should fix it for you. Then you could add the field to the form the same way as shown in this video. Thanks for watching!
Thank you so much. It worked!!!
Good. Very helpful!
Glad to hear that, Leo. Thank you for watching!
Hi Adam,
I am having issues with a form that was previously created in my database because when other employees use the form and select an option from the drop down box and hit enter, the form disappears and the next form is the next entry from the table in which the form is created from. The dispatch reps using the form cannot re-access that same form that they previously altered to change or modify their drop down selection. How can I change the form or table settings to allow the employees to go back and see the form that they previously altered?
Thank you,
Hi Jesse,
If the original form is gone, then you'll need to recreate it based off of the original table in which it came from. For this, you'll need to create a combo box. I don't have anything like this on my channel, but I found a link that discusses what they're used for and how to add them to Access. I hope it helps you:support.office.com/en-us/article/add-a-list-box-or-combo-box-70abf4a9-0439-4885-9099-b9fa83517603
Greetings from indonesia, Prof. Morgan. I am making a restaurant order
form on ms access 64bit. I would like to have a wav-file playing
everytime a quantity is added onto the order; an on-click-event that, in
addition to manipulate the value of the field, also plays a wav sound. I
am using 64bits access; i have sample-instructions for 32bits-access but i do
not know how to fix them to work on 64bit access. Will you please teach
us? Please help. Thankyou immensely.
Hi Pelajar,
Thank you for watching from Indonesia! I am sorry but I actually do not have experience using sound files within Access. I wish I could help you out with this. Let me know if you find a solution!
@@ProfessorAdamMorgan Thankyou for your reply, professor.
No problem!
Is the image at the beginning of the video taken at Southbank in Brisbane during a Riverfire event?
Hi Gary,
I forget where I found that image. It's a nice picture though so I included it.
What will I do if the added field goes on the top list? It didn't stacked to where I want it to be. Is there a way to correct that?
thank you so much
lloyd
Can fields be added dynamically to a form in MS Access 2016?
Hi Iftikhar,
What do you mean by dynamically? If you explain a little more, I will try to help you out with this. Thanks for watching.
I want to be able to select a statement to a form from a dropdown list or from a table, but the number of statements I need to chhose could vary so I want to be able to choose if I want to select an additional statement until I am done.
For this, you'll need to create a combo box. I don't have anything like this on my channel, but I found a link that discusses what they're used for and how to add them to Access. I hope it helps you:
support.office.com/en-us/article/add-a-list-box-or-combo-box-70abf4a9-0439-4885-9099-b9fa83517603
you really saved my ass
I'm happy to help Robin, let me know if you have any Access questions and I'll try to help.
can you do a form when you select a certain data it automatically fill the 2nd one, example if i choose BSCHEM course itll automatically select the chairman of that course
Hi Randel,
I'm not too sure on that. It would probably be an IF function but I haven't tried that before. I'll look around the web and see if I can find anything to help out.
@@ProfessorAdamMorgan thank you prof if yoi cant find anything its ok thank you thank you
Randel, I found a link that might be able to help you out. Give this a shot and see if it works out:
support.office.com/en-us/article/dlookup-function-8896cb03-e31f-45d1-86db-bed10dca5937
When you add a field can you add it in to a text box with other information?
Hello, Im new to access and I have an issue when adding a new data in a column. It says " The text you entered isnt an item in the list " and I press yes but still it doesnt add it. How to deal with the situation? Thank you so much.
Hi Rafal,
I recommend changing the field type to 'Text' so that it doesn't require a specific selection from a list. Let me know if this works.
Thank you Professor Adam Morgan!! , Yes it did work.
No problem Rafal, glad it worked!
I tried adding a field in one from from another table, but when I do this and I try to view the form in form view. I get a white page. What is the work around this?? Thanks
Hi Patricio,
Try deleting the form then recreating a new form based on the original table. That should reset the formatting to include all available fields. I hope this helps you out.
Thank u so much
Thanks
How do I create labels
How can I add New data to a current database ??
Hi Raphael,
Data can be added in Tables. Here is a tutorial I made on creating tables:
th-cam.com/video/obq-CSkn9_c/w-d-xo.html
@@ProfessorAdamMorgan Thanks
No problem!