Access Developer 24 Lessons

Welcome to Access Developer 24 Total running time is 1 hour and 54 minutes.

Lessons

Database Files

Resources

Full Course Description Page
Topic Outline
Handbook PDF - Coming Soon
Video ZIP File (346 MB)
Skills Test Quiz - Under Construction
Certificate of Completion
Post-Class Survey

Subscribe For Updates!

Students: if you want to be notified when new lessons for this class are posted, make sure you click on the SUBSCRIBE button below! You'll get an email every time a comment is posted, which I will do when I post more lessons.

Questions?

Please feel free to post your questions or comments below. If you have a questions about a specific lesson, please specify the lesson number and the time index in the lesson where the issue occurs. Thank you!

Copy Shipped Paid Upload Images Link
Juan C Rivera
16 days ago

copy works real good in the lesson database only is also copys the is shipped and is paid. So im thinking last item to do is when moved to the copy isshipped = false and ispaid = false

Richard Rost
16 days ago

Yep. Good catch!

Richard Rost
12 days ago

That is exactly what I would do. This is an easy fix. I didn't carry copying the details forward into the D25 database, so you're on your own. :)

Access 24 Lesson 1 glitch Upload Images Link
James Gray
25 days ago

At 42:35 the video stops. No real issue, you are done writing the code but there is still more verbiage from you about how to wrap it all up. Thanks

Richard Rost
25 days ago

You are correct sir. Thank you. I don't always watch every minute of every video I post, and sometimes they glitch. I'll recompile it and re-upload it. This is why I TRY to keep the videos to around 20 minutes each. Less chance of glitching. I never do though. LOL

Richard Rost
25 days ago

OK. All done. Not sure why, but the new video is now 130 MB as opposed to 170 MB for the old one. Weird. Same length. :)

Developer 24 Zip File Upload Images Link
Michelle Maughan
2 months ago

Hi Richard
When will the zip file be available?
I live on a rural property with no internet and have to download the file at my office so i can watch it at home.
Cheers
Michelle

Richard Rost
2 months ago

Sorry about that Michelle. I forgot to upload it. Thank you for reminding me. So few of my students actually download them, so it slips my mind, but please do light a fire under my butt if it's not there as soon as you see the "Intro" and "What's Next" lessons posted. That means the Level is finished. I just uploaded it. Should be ready in a few minutes.

I feel bad because I just upgraded to Gigabit Internet. My transfer speeds are outrageous right now. Faster than I've ever had. I just uploaded a 346 MB Zip file in under a minute. I live in the City of Fort Myers now. I used to live in a rural area in Northwest Cape Coral until about a year ago. Satellite internet. Really slow and cut out in the rain.

Michelle Maughan
2 months ago

I'm soooo jealous!
Thanks for the file.

Reservation Input Upload Images Link
Scott Axton
2 months ago

I'm still working through lower level Dev courses yet but the outline caught my eye.
Funny enough I'm working on a "room" reservation system. One of my requirements is that a person can only book one room on a given day. (You can't be in two places at once. Read More...

Richard Rost
2 months ago

That's a good one! I'll add it to the list for the next class. Didn't think of that. Everyone else: consider that your homework!

Juan C Rivera
2 months ago

I like this thought, can you include an override checkbox? in case the same person needs several rooms for different events on the same day and time...lest say need two rooms one will be Access Intro other for Access Expert. or adjoining rooms like hotel. Mom and dad 1 room, kids get the room next door? just a thought sounds like a good challenge.

V/r
Juan

Show 5 More Replies...

Richard Rost
2 months ago

Challenge accepted. Sounds like a good project, and a learning experience for all.

Scott Axton
2 months ago

Richard & Juan - I like the over ride.  I'm working with over 50 different locations with any where from 1 - 5 "rooms" per location.
That makes it real fun to work through.  Not too terrible though with proper table structure and relationships.
Even more challenging is that each one is available only certain days of the week.  Some are 7 days, some M-W-F, some Tues-Thur-Sat., etc.  I'm glad there is only 7 days in a week!
It's definitely been an interesting project.

Richard Rost
2 months ago

More great ideas. :)

Juan C Rivera
2 months ago

Can you do the product planner into this also I lke the birds eye view of a given start date with end date to see whats available at that given time??????
Am I asking to much?

V/r
Juan

Richard Rost
27 days ago

I'll do my best. I'll probably release a version 1.0 first and then you guys can tell me what more to add to it after.

D24 Finished Upload Images Link
Richard Rost
2 months ago

Developer 24 Lessons 2 and 3 are finished. We cover copying a record with it's child records. So for example, copying an order with the details.

Juan C Rivera
2 months ago

Just finished Lesson 3 by using the database developed on D23 you added a combo bot to list items on D24 if I try to do what was done on the database of D-23 I get errors. I try to compact and restart as you sugested but does not work. the product combo box is causing the problem. How can I get it to work with D-23?

Richard Rost
2 months ago

Back up and walk me thru it step by step. I'm not following.

Show 4 More Replies...

Juan C Rivera
2 months ago

Richard,
Hold on I will tuck this project away and restart over - I will learn from my mistakes.
I am thinking the as the stubborn person I am - I will not give up. I am going to start from scratch and master this beast.
I started with the 1 hour long tech vid and continued to use the database through D-24 not starting a new database but build on it. trying to get it to work as we move through the lessons. So if it's ok with you, give me a month or two and at that time I will say got it or help me....I have so much fun doing this good thing it's just for a hobby if my job depended on this I will be unemployed LOL.
V/r
Juan
Live Long and Prosper

Richard Rost
2 months ago

Ok. Do your thing. Let me know if you need help.

Juan C Rivera
25 days ago

Richard, I'm gonna quote you
BOOM
everything works as advertised. I found about 7 things I did wrong. 1st is the keyboard is too small I fat finger a lot.
the rest was spelled in spanglish. You code is solid!

V/r
Juan

Richard Rost
25 days ago

Party on, Wayne.

D24 Lesson 1 Reservations Upload Images Link
Richard Rost
2 months ago

Lesson 1 has been posted for D24. We build a reservation system into the rental database from D23. Conflict resolution is the hard part!

Timothy Smith
2 months ago

Thank you. This is right up my alley. I am looking forward to learning some more.

Lessons

Database Files

Links

Resources

Subscribe For Updates!

Questions?