Thank you!!! Excellent instruction. I followed along with Access open, and it worked perfectly. You did a good deed for the day and didn't even realize it!
Long time ago I learned Access 2000. And THAT had a lot of stuff in it. Took me a few years to learn about 3/4 of the things it could do (self-taught), so I imagine 2016 has a ton more. I actually loved learning how to create a database. It also showed me all about forms and how to design them, and how to create drop-down menus, dialog boxes, links, shape and move objects around, hover tips, create parameters in form fields....amazing stuff.
Thanks for making this. I especially appreciate your concern for consistency and use of precise language, critical for technical instruction. Well done and thanks again.
To re-size all field names at once, first select the entire table by clicking the very top left cell. Then double click in between any of the field name cells and the table will re-size all fields to fit the names. No need to manually drag the cells.
Thank you so much! I am learning Access to help make sense out of my chaos and the books I have don't seem to get down to basics! I was so frustrated thinking, "HOW DO I ADD ACTUAL INFORMATION to the database???!!!" You gave me just what I needed. I've taken notes (because I know I'll forget) on my ipad as you're instructing and getting ready to head to your second video. Again, thank you!!!!!!!
WOW!!! You helped me learn all my things from Access and I never used access before and I got a A+ in digital tech thank you I am 9 years old year five New zealand
I enjoyed watching this video and recommend to others Host seem to be an expert in Access Database Teacher tone is also good Please keep post some more videos Thanks for educating the community and appreciate your volunteership. Than a bunch
Thanks so much for the way you did this i am a total dinosaur and have never done anything like this i have watched a few vids and it all just goes over my head , i loved the way how slowly you spoke and made every so clear . So thank you sooo much
Quick question. When linking a another table to another. And then you change the values example delete an associate, would a ticket which you made before delete the associate’s name that created the ticket?
this is the first time I have used and seen it explained this and its great I am splitting a 200.000 row database in to separated tables and this method suits best (thankyou)
I am trying to make a Database for partnumbers. And right now I have a form for each table. And I was wondering if I could use one form for all tables? The part numbers have a format of 88-XXXX to 106-XXXX and I want to have the first two-three digit number assign where the part number goes in the tables.
In access the formulas or the computations refers to the enter columns, not specific cells(fields). You can only use Col A plus Col B. In excel you can input formula in a single cell in which the components are located in a different row. ex: in cell A1=B1 + B2 or A1 = C2 + B3. If you copy cell A1 and paste it on cell range A1 to A10, this will paste the formula to each cell from A1 to A10 with each cell's related components in the formula. Is this possible in access?
pro explanation to set up table was good....it very clear and understanding...i was able to follow. con was not enough depth or details for example editing . it included 2 lesson set up table and linking....i was not prepared for linking....i wanted to gain more insight into table set up which was not provided in your video
I really appreciate your video. I wish you have verbalized what you were doing more precisely for those of us trying to follow along in the application. I had to pause and 'rewind' more than I would have liked to to see exactly WHAT you were doing...
At the time, I posted this video on a whim. Back then the channel was mostly Unity game design. Had no idea this would become the most popular video on the channel. For what its worth I did go back and do a new database tutorial from scratch. It might be better: th-cam.com/video/pjQdzlVqKOk/w-d-xo.html
When changing the Case_Status Field name from Short Text to Lookup using the Lookup Wizard. I do as the video does but when I go to save the Database I get a "Type Mismatch" Error in the default Value. Cant figure out a way around it and thus the Case_Staus field remains Short Text
hello, I am searching to be able to fullfile automatically a field thanks to the previous field. I explain. I got a table named "Customers" with 3 fields ( Id, Name, Sector) and in an other table I use the Customer Name by selecting it thanks to the LookUp Wizard tools. After that I select the customer name that I want and I would like the next field of this table (Customer_Sector) to be automatically fullfiled thanks to the Table "Customers". Any Idea or help ? Thanks in Advance
My Look Up Wizard is not working. I followed all the steps you've shared and this pops up on my end "The Lookup Wizard doesn't apply to this data type" Any recommendations on how to fix this?
Not sure as I never received that error while making this video. Can you check what data type you set the field to? Also, which field are you having an issue with?
this video is amazing .thanks for making it.it is very helpful and it helped me for my internal assessment and even the part 2 of this video has helped me a lot
Hi.... Thank you for your videos... I was wondering if you can explain to me how to do a user table that depending on the user security they could either add info / change info . or just simply look the info. Don't know if I am explaining my self correctly. But your help will be really appreciated.
I can post something in a day or two. But in short, the fields on a form (I presume you are not letting people directly edit a table) can be locked/unlocked using VB code. So you would simply check the current login value and set the locked attribute to yes or no. Also, I notice this is on #1. Have you watched any of the subsequent videos?
Doing unit 18 (Database Design) within my College in the course BTEC Level 3 90 Credit Diploma in IT. I heard that you need name tables using the name "tbl_ Is this true? Or a preference that the tutor is attempting to hand over?
Hi Nemesi, tbl is preferred for tables, frm is for forms. But its just a naming convention that is being used. Later on, once you go to advanced level where you need to refer to a table or form, then it will facilitate you to recognize which one is table and which one is form. For example, you create a table and a form for students record, then you can name them as tbl_student and frm_student. Suffix is same but you can distinguish with tbl and frm.
hi im hoping you can help me. ive created 2 tables on my database on ms access. one is 'customer details' etc and one is 'completed' sales/deals. what i want to do is keep all records of customers for cars in the main big 'customer details' table and any completed deals from that table automatically added to the 'completed' table. i want to have a button or option like completed on the end of the table maybe like a yes or no column. by which i could click and it would automatically add the relevant fields i want to the completed table. i would like to know how i can go about that.
I believe what you are looking for is an Append type query. Records from one table will be added to another based on the criteria that the transaction is completed. Been a while since I made it but this tutorial covers Append type queries; th-cam.com/video/QxmwEccRYNY/w-d-xo.html
Great series of tutorials. I'm very new to Access. I like the lookup wizard to control the input of fields, however, if you make a form to input data to your table can you make the lookup wizard dropdown appear there? Thanks!
Nice One just in just a single video what will happen if I enter the data in Capital like u enter first EMP101 then you correct it Emp101 how does it make a difference..
Doing the final part I got this: you can't modify the structure of the table 'ticket_tracker_table' because it is already in use by another person or process. And then I get a message that the Lookup Wizard may be disabled. Help anyone?
If you have a database object open such as a query that is linked to the table you will get that error. Although I don't think I had covered those yet in this video. Some object might just need to be closed. In the words of Roy "Have you tried turning it off and on again?"
Thank you so much for these videos. I am in the Air Force and though they supply us with the whole Office Professional with all of these shiny tools, we are never trained and stuck using excel for everything we do. I started watching your videos and in 4 days I've already created a pretty useful database and am trying to do more with it. I have a question if you would be so nice to answer. I have 3 tables, one of the tables loads from an outside source. I import an excel spreadsheet every time i need to update it basically. The other 2 tables are static and rarely change. I have three queries to give me 3 values. The 3 values are the count of basically 3 count-ifs statements. What I need to be able to do is to use these 3 values at the same time so that i can do math with them. ie % of tasks completed, etc... Do you know a way? Right now, I use these queries to get the data, then use excel to manipulate it, but I feel like I should be able to automate it. This is important because I am the only one in my shop that understands what is going on with the database right now and I need to dumb it down to press and button and it gives you the answer for the rest of my shop. Thanks again.
kindly need v important issue it is ok to pay for it my problem is i need to calculate the cost of one item by making a relation between the master item table & the Bell of material table (product tree) till now there is no problem but the problem arise when the tree contain one or two intermediate items ( other item have its separate component which should be calculated separately at first then add the result to the main item which include that item For example we calculate the rice cost which has sauce added on the recipe her we cannot make the calculation unless we make the calculations to have the sauce cost ) if you have a way to solve this programming issue i will be v grateful to you - need a way to run the sub item calculations to be added in the same time. Am i clarify what i need ???
Yes, it is considered a best practice to not use spaces. Spaces could potentially cause problems if you start using VB code and add other more complex functionality that has to refer to the field or table names.
Sorry, not sure what you mean by "random". All entries are intentional. If you mean how to populate a database with data for testing purposes, there really isn't a great way.
@@designanddeploy5991 am asking d random numbers.. Like just for practice d database entry.. Like age number fields, salary fields, sold item fields.. In excel I knw just we use randbetween ( 5,10) then it takes 5 to 10 numbers automatically.. Like that in access how to do.. Where to apply this? Tell me Plse..
Thanks for the videos, do you have one that would help with a vendor database? I want to make a vendor database that is searchable by my staff, but there are so many search options it would be impossible to make a query for every option. For example, I want people to be able to find florists in Los Angeles, CA or search for the whole state of California for florists or search the whole country for florists. We have dozens of vendor types (florists, rental companies, AV companies, etc..) all across the country that I would like to make searchable. I also want the same people that are searching the database to be able to enter new vendors as well. And since these people are not power users, this needs to be an easy process for people to use. Thanks for your time.
You would use a form that would set the criteria for the query. So, in the query, for the state field, for example, you would use a combo box on the form that lists the names of states. In the same query, for business type, for example, another combo box on the form would have a listing of vendor types. This would allow you to mix and match. So, to make this all work you need to have a master table of all vendors that the query is checking. th-cam.com/video/Vg5f4HbNMAU/w-d-xo.html
You buy a better headset/microphone, which I did and I mention in the description. Starting in part 3 the audio is much better. Also, I started a whole new series with better audio. Search for Lessons for Students on my channel, I start from scratch.
Basically, I am trying to revolve my IA around making a database on Access. The database has to contain 10 students let's say and the database has to contain slots where they can put in the classes they have taken, the credits they've earned, and the database has to somehow let them know if they are on track to graduate and if they have the right amount of credits in the right classes. Let me know how I could execute this plan.
Bunch of ways this can be done. One way would be to have a table that contains those requirements the students need and you would run a query that compares what they have taken (those values would be in a student table)versus the values in that requirement table. The query results could be displayed in a report. One column shows the requirements, the other table shows what the student has taken.
Thank you for your great tutorials - I am learning so much - and that's not that easy for an old coot like me - I'm 83 years old. I noticed a template for students/school offered by M/S. Can I copy this to my hard disk and use it? I took a peek at it and it tells about a Welcome misspelling and messing up macros. I'm a volunteer at a Veterans Support Group here in town and wonder if this can be modified to accommodate our vets. Do you offer any technical assistance and for a fee? I might need some help as I go along. Thank you for the great work you do for all of us. Chuck Sotis
Glad the vids are helping. Since I work full time I typically don't offer tech support as it tends to be an open ended commitment. However, if there is something in particular you would like to see I certainly can make a custom video. So if there is some function you would like to see I can make a video that demonstrates that.
![Microsoft Access - Tutorial for Beginners [ COMPLETE ]](/img/n.gif)
You taught me more in 15 min and 52 secs than my prof for Database Fundamentals did. In a whole year!
Thank you!!! Excellent instruction.
I followed along with Access open, and it worked perfectly.
You did a good deed for the day and didn't even realize it!
Excellent tutorial. You spoke at a good pace making it easy to follow step-by-step using Access. Thank you.
One of the best Tutorial on TH-cam. Simple to Complex. 👍👍
Long time ago I learned Access 2000. And THAT had a lot of stuff in it. Took me a few years to learn about 3/4 of the things it could do (self-taught), so I imagine 2016 has a ton more. I actually loved learning how to create a database. It also showed me all about forms and how to design them, and how to create drop-down menus, dialog boxes, links, shape and move objects around, hover tips, create parameters in form fields....amazing stuff.
Was watching this for class and had to keep it together while this man was typing in resident evil characters
Had to get this fully for my exams....It's a great help.
Thanks for making this. I especially appreciate your concern for consistency and use of precise language, critical for technical instruction. Well done and thanks again.
Great teacher for a platform that can be sometimes made so confusing to understand- refreshing my memory again since years of touching Access!
To re-size all field names at once, first select the entire table by clicking the very top left cell. Then double click in between any of the field name cells and the table will re-size all fields to fit the names. No need to manually drag the cells.
thank you this video is helping a group of people bring back a game we all loved
I knew it! This guy is a Resident Evil fan. Thanks for this great tutorial mate :)
Thank you so much! I am learning Access to help make sense out of my chaos and the books I have don't seem to get down to basics! I was so frustrated thinking, "HOW DO I ADD ACTUAL INFORMATION to the database???!!!" You gave me just what I needed. I've taken notes (because I know I'll forget) on my ipad as you're instructing and getting ready to head to your second video. Again, thank you!!!!!!!
Thanks for taking your time to show us how to get this done.
WOW!!! You helped me learn all my things from Access and I never used access before and I got a A+ in digital tech thank you I am 9 years old year five New zealand
W Lin // Wow, I wasn’t making data baces in year 5, I got to that in year 11 😂
I'm simple love to see Claire, Leon and hopefully Chris on this series soon.
Then Wesker, and Barry.
Thank you so much for this video. Access has never been easier.
A nice one. I had missed an introductory class on this but now am ahead of others already. Thanks to you.
Clarity in your explanation. Good work
watch on 1.25 speed
thank you :o
I wish there was a 1.25 button IRL sometimes.
watch on 0.25 speed
Lol brilliant. Nice call.
Rick Sanchez 2x
I enjoyed watching this video and recommend to others
Host seem to be an expert in Access Database
Teacher tone is also good
Please keep post some more videos
Thanks for educating the community and appreciate your volunteership.
Than a bunch
Watching this video before i do this exam. Hope this video help me .
Really informative. LOVED the nod to Resident Evil there :)
Thanks so much for the way you did this i am a total dinosaur and have never done anything like this i have watched a few vids and it all just goes over my head , i loved the way how slowly you spoke and made every so clear . So thank you sooo much
Exactly what I needed as a beginner.
Thank you for the great effort you have put. Because of you, I now know it.
Wow i have to say this is way better and easier than trying to work with relationship links. thank you for your tutorial.👍👍
I have no idea what Resident Evil is...but this video was extremely helpful!
Quick question.
When linking a another table to another.
And then you change the values example delete an associate, would a ticket which you made before delete the associate’s name that created the ticket?
Just got done with a session of RE2 Remake and decided to learn Access. I like how you think sir.
Thank you very useful I need to make a database and I have not made a database for many years great memory jogger.
Wow a Database for the Umbrella corporation and S.T.A.R.S agents, love it.
this is the first time I have used and seen it explained this and its great
I am splitting a 200.000 row database in to separated tables and this method suits best (thankyou)
Have a test tommorow,hopefully I do well from these videos.Thanks so much!
Very helpful video, thanks, I've always wondered what I can use Access for.
Thank You! I learned so much by watching your video.
Pls use screen zoom while working...
It helps us to watch clearly..
Thanks for your tutorial.
I am trying to make a Database for partnumbers. And right now I have a form for each table. And I was wondering if I could use one form for all tables? The part numbers have a format of 88-XXXX to 106-XXXX and I want to have the first two-three digit number assign where the part number goes in the tables.
Informative tutorial. Thanks for sharing.
In access the formulas or the computations refers to the enter columns, not specific cells(fields). You can only use Col A plus Col B. In excel you can input formula in a single cell in which the components are located in a different row. ex: in cell A1=B1 + B2 or A1 = C2 + B3. If you copy cell A1 and paste it on cell range A1 to A10, this will paste the formula to each cell from A1 to A10 with each cell's related components in the formula. Is this possible in access?
How do i change to invoice logo which is already available in access database.
Love the resident evil references!!!!!!!!!!!!!!! Great material, thanks.
pro explanation to set up table was good....it very clear and understanding...i was able to follow. con was not enough depth or details for example editing . it included 2 lesson set up table and linking....i was not prepared for linking....i wanted to gain more insight into table set up which was not provided in your video
Why there is a star sign showing on the column?
what does this mean ?
Nice Resie reference, bro
I knew I was watching the right tutorial when I saw you enter the first name.
I really appreciate your video. I wish you have verbalized what you were doing more precisely for those of us trying to follow along in the application. I had to pause and 'rewind' more than I would have liked to to see exactly WHAT you were doing...
At the time, I posted this video on a whim. Back then the channel was mostly Unity game design. Had no idea this would become the most popular video on the channel. For what its worth I did go back and do a new database tutorial from scratch. It might be better: th-cam.com/video/pjQdzlVqKOk/w-d-xo.html
U make my day man... RE fans
The Host is doing it well
Very clear instructions. Thanks.
A problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control how to fix
When changing the Case_Status Field name from Short Text to Lookup using the Lookup Wizard. I do as the video does but when I go to save the Database I get a "Type Mismatch" Error in the default Value. Cant figure out a way around it and thus the Case_Staus field remains Short Text
did you download it
Blank sheet is not available in my lapi...please help
hello,
I am searching to be able to fullfile automatically a field thanks to the previous field. I explain. I got a table named "Customers" with 3 fields ( Id, Name, Sector) and in an other table I use the Customer Name by selecting it thanks to the LookUp Wizard tools. After that I select the customer name that I want and I would like the next field of this table (Customer_Sector) to be automatically fullfiled thanks to the Table "Customers". Any Idea or help ?
Thanks in Advance
have a look at th-cam.com/video/8pMSkNGlF54/w-d-xo.html
thank god you explain so easily than my own teacher.lol
My Look Up Wizard is not working. I followed all the steps you've shared and this pops up on my end "The Lookup Wizard doesn't apply to this data type"
Any recommendations on how to fix this?
Not sure as I never received that error while making this video. Can you check what data type you set the field to? Also, which field are you having an issue with?
At 1.5 speed, he sounds like Dwight K Schrute :D
Watch on .5 speed he sounds stoned.
this video is amazing .thanks for making it.it is very helpful and it helped me for my internal assessment and even the part 2 of this video has helped me a lot
Hi.... Thank you for your videos... I was wondering if you can explain to me how to do a user table that depending on the user security they could either add info / change info . or just simply look the info. Don't know if I am explaining my self correctly. But your help will be really appreciated.
I can post something in a day or two. But in short, the fields on a form (I presume you are not letting people directly edit a table) can be locked/unlocked using VB code. So you would simply check the current login value and set the locked attribute to yes or no. Also, I notice this is on #1. Have you watched any of the subsequent videos?
Yes, I have watched a lot of your access videos. Like the way you explain things. One of the best out there.
Thank you very....much!
I was really looking for this!
👍🏻...
Thank for the tutorial. Very helpful
Doing unit 18 (Database Design) within my College in the course BTEC Level 3 90 Credit Diploma in IT. I heard that you need name tables using the name "tbl_ Is this true? Or a preference that the tutor is attempting to hand over?
Hi Nemesi, tbl is preferred for tables, frm is for forms. But its just a naming convention that is being used. Later on, once you go to advanced level where you need to refer to a table or form, then it will facilitate you to recognize which one is table and which one is form. For example, you create a table and a form for students record, then you can name them as tbl_student and frm_student. Suffix is same but you can distinguish with tbl and frm.
hi im hoping you can help me. ive created 2 tables on my database on ms access. one is 'customer details' etc and one is 'completed' sales/deals. what i want to do is keep all records of customers for cars in the main big 'customer details' table and any completed deals from that table automatically added to the 'completed' table. i want to have a button or option like completed on the end of the table maybe like a yes or no column. by which i could click and it would automatically add the relevant fields i want to the completed table. i would like to know how i can go about that.
I believe what you are looking for is an Append type query. Records from one table will be added to another based on the criteria that the transaction is completed. Been a while since I made it but this tutorial covers Append type queries; th-cam.com/video/QxmwEccRYNY/w-d-xo.html
can you teach me how to make t-shirt survey using access,when i enter employee id number,the choices will pop up small to xxxl
superb guidence . helped me a lot. feels like a person is teaching yo
Please guide to me how to download it
Great series of tutorials. I'm very new to Access. I like the lookup wizard to control the input of fields, however, if you make a form to input data to your table can you make the lookup wizard dropdown appear there? Thanks!
hahahahah, the caracters from Resident Evil
Just wanted to write that hahah ;D damn
Noticed it right away ahahaha awesome
Nice One just in just a single video what will happen if I enter the data in Capital like u enter first EMP101 then you correct it Emp101 how does it make a difference..
When do we get to the part where we have to document saving Ashley, the president's daughter?
Part 4, of course.
@@designanddeploy5991 lol
I love this, everything consistent! And this was very helpfull for my schoolproject, thanks a lot!
Thank you, now I won't fail my CA
Doing the final part I got this:
you can't modify the structure of the table 'ticket_tracker_table' because it is already in use by another person or process.
And then I get a message that the Lookup Wizard may be disabled.
Help anyone?
If you have a database object open such as a query that is linked to the table you will get that error. Although I don't think I had covered those yet in this video. Some object might just need to be closed. In the words of Roy "Have you tried turning it off and on again?"
Thank you so much for these videos. I am in the Air Force and though they supply us with the whole Office Professional with all of these shiny tools, we are never trained and stuck using excel for everything we do. I started watching your videos and in 4 days I've already created a pretty useful database and am trying to do more with it.
I have a question if you would be so nice to answer. I have 3 tables, one of the tables loads from an outside source. I import an excel spreadsheet every time i need to update it basically. The other 2 tables are static and rarely change. I have three queries to give me 3 values. The 3 values are the count of basically 3 count-ifs statements. What I need to be able to do is to use these 3 values at the same time so that i can do math with them. ie % of tasks completed, etc... Do you know a way? Right now, I use these queries to get the data, then use excel to manipulate it, but I feel like I should be able to automate it. This is important because I am the only one in my shop that understands what is going on with the database right now and I need to dumb it down to press and button and it gives you the answer for the rest of my shop. Thanks again.
I could do that: www.fiverr.com/carterwes92/create-a-custom-database-management-system-for-you
Amazing tutorial, thanks!!!
I am new to data base entry system. I need more videos to watch as I can help my personal learning skills. 🖕🖕
This was really helping me mike
how to download access??
Nice One and informative ..
kindly need v important issue it is ok to pay for it my problem is i need to calculate the cost of one item by making a relation between the master item table & the Bell of material table (product tree) till now there is no problem but the problem arise when the tree contain one or two intermediate items ( other item have its separate component which should be calculated separately at first then add the result to the main item which include that item For example we calculate the rice cost which has sauce added on the recipe her we cannot make the calculation unless we make the calculations to have the sauce cost ) if you have a way to solve this programming issue i will be v grateful to you - need a way to run the sub item calculations to be added in the same time. Am i clarify what i need ???
I noticed you placed this comment on the first video. Have you watched more of the series? I do cover pricing functions later in the series.
Super helpful! I'm curious - is there a reason why the underscore is used instead of spaces?
Yes, it is considered a best practice to not use spaces. Spaces could potentially cause problems if you start using VB code and add other more complex functionality that has to refer to the field or table names.
How to enter data randomly in Access? For practice purpose am asking
Sorry, not sure what you mean by "random". All entries are intentional. If you mean how to populate a database with data for testing purposes, there really isn't a great way.
@@designanddeploy5991 am asking d random numbers.. Like just for practice d database entry.. Like age number fields, salary fields, sold item fields..
In excel I knw just we use randbetween ( 5,10) then it takes 5 to 10 numbers automatically.. Like that in access how to do.. Where to apply this? Tell me Plse..
Thanks for the videos, do you have one that would help with a vendor database? I want to make a vendor database that is searchable by my staff, but there are so many search options it would be impossible to make a query for every option. For example, I want people to be able to find florists in Los Angeles, CA or search for the whole state of California for florists or search the whole country for florists. We have dozens of vendor types (florists, rental companies, AV companies, etc..) all across the country that I would like to make searchable. I also want the same people that are searching the database to be able to enter new vendors as well. And since these people are not power users, this needs to be an easy process for people to use. Thanks for your time.
You would use a form that would set the criteria for the query. So, in the query, for the state field, for example, you would use a combo box on the form that lists the names of states. In the same query, for business type, for example, another combo box on the form would have a listing of vendor types. This would allow you to mix and match. So, to make this all work you need to have a master table of all vendors that the query is checking. th-cam.com/video/Vg5f4HbNMAU/w-d-xo.html
I still have no idea whether you mean a speeding ticket or a ticket to some event
it helped me get all right in the tech Exam a+
1:25-1:28 how to create table.
But how do you create a noisegate to eliminate white noise?
You buy a better headset/microphone, which I did and I mention in the description. Starting in part 3 the audio is much better. Also, I started a whole new series with better audio. Search for Lessons for Students on my channel, I start from scratch.
Nicely illustrated..
I like your video very much. It's really great. I'll keep an eye on your channel. I am your fan and I will support you.
Basically, I am trying to revolve my IA around making a database on Access. The database has to contain 10 students let's say and the database has to contain slots where they can put in the classes they have taken, the credits they've earned, and the database has to somehow let them know if they are on track to graduate and if they have the right amount of credits in the right classes. Let me know how I could execute this plan.
Bunch of ways this can be done. One way would be to have a table that contains those requirements the students need and you would run a query that compares what they have taken (those values would be in a student table)versus the values in that requirement table. The query results could be displayed in a report. One column shows the requirements, the other table shows what the student has taken.
Game Design HQX thank you so much for your reply I'll take this into consideration!
Thank you for your great tutorials - I am learning so much - and that's not that easy for an old coot like me - I'm 83 years old. I noticed a template for students/school offered by M/S. Can I copy this to my hard disk and use it? I took a peek at it and it tells about a Welcome misspelling and messing up macros. I'm a volunteer at a Veterans Support Group here in town and wonder if this can be modified to accommodate our vets. Do you offer any technical assistance and for a fee? I might need some help as I go along. Thank you for the great work you do for all of us. Chuck Sotis
Glad the vids are helping. Since I work full time I typically don't offer tech support as it tends to be an open ended commitment. However, if there is something in particular you would like to see I certainly can make a custom video. So if there is some function you would like to see I can make a video that demonstrates that.
Can I Connect The data to a JavaScript client?
Not sure. I have only used Access as a stand alone application as opposed to a data source for something else.
okay, thanks for the response
oh my gos you guys are my heros thank you so much i love you guys without you i would be noyhing yeeessssssss
Hey man, thank you so much for this tutorial!!
It really helped me a lot!
Glad to hear it. Let me know if there is something specific you would like to see.
Thanks this helped for my exam
What exam was that
Bayfers edpm
thankyou for the explanation....to good...!!!
Awesome work, very good way of explaining the things and making them understand. wonderful job. Thanks
I want a video on how to use Dreamweaver to make a web page.
Why are you using underscores instead of spaces?
I get asked that so much I made a video explaining it: th-cam.com/video/MKyVfDaqjVo/w-d-xo.html
@@designanddeploy5991 oh, sorry about that... thanks for the response!