Thank you, Richard! After the 3rd lesson on Many to Many Relationships in Expert 7, I GOT IT! Somehow that one matched my situation and it worked for me. Thanks to you, my database is getting closer to showing the boss. THANK YOU, THANK YOU, THANK YOU.
This course helped me to understand the tremendous value of setting up my fields first before blazing out there with data entry. Going back a little further, this course helped me see value in drawing out on paper ahead of time what I want my forms to look like and exactly what I want them to do for me and my end users. I am encouraged to know that I can change field properties after the fact though, since my needs will likely change and as I acquire more knowledge and experience using Access. Great lesson!Read More...
I'm chomping at the bit to learn how to relate fields to each other to create the forms that I want to use. I'm being a good girl though--waiting and going through each course twice and in order. I personally want you to call up Microsoft and demand that they put a view zoom in Access :). I'm going to have to buy something to help me see my data better. I even have a large screen. Have mercy!
Julie, thank you for your kind words. As I stress in class, one of the major benefits of Access over Excel is that by setting up your fields first, you are forced to enter specific data types. You can't put a text string where a currency value is supposed to go. Relationships are coming very soon (Expert 1). I want people to get comfortable with the basics before diving into a very important concept like that. I take plenty of time in Expert 1 and 2 explaining the ins and outs. And yes, I wish Access had a zoom feature too. Word, PowerPoint, and Excel all let you zoom in and out, but Access - once again - is the red-headed stepchild of the Office family. You can build your forms bigger (larger boxes, bigger fonts, etc.) but you can't zoom in design view or datasheet view. Lame! Believe me, if Microsoft would listen, I have a WHOLE LIST of things for them. Even being a 2-time MVP doesn't do squat. LOL
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
May I say - Your courses are a breathe of fresh air - finally someone who understands how to relay information. You are a great teacher and there are a lot of not so good ones out there. I have been an MS access user off and on for a quite a few years and would class myself at intermediate stage. Information on access I have found in the past is generally too technical for a novice or too sketchy to follow. I have watched all of the beginner classes. I am finding the courses very well structured, easy to follow and most importantly easy to understand and digest. Thank you so much for providing these courses.