What are you doing WRONG!

Uncle Gizmo

Nifty Access Guy
Staff member
Local time
Today, 12:52
Joined
Jul 9, 2003
Messages
17,511
Excellent video on Excel this, and I found out I'm doing lots of things wrong!


 
pretty low level although centre across selection was a new one for me - but could do with one of those for Access - if you are up to the challenge ;). Must be plenty of subjects on 'doing things wrong in Access'
 
I hadn't realised the advantages of turning data into tables....
 
think it is a lot easier to transition from access to excel rather than the other way round
 
SSAFA used to supply and End of Year Workbook, with half the columns hidden, on the left of the sheet?, instead of putting them over on the far right out of sight and calculation? :mad:
And these people were being paid? :(
 
pretty low level although centre across selection was a new one for me - but could do with one of those for Access - if you are up to the challenge ;). Must be plenty of subjects on 'doing things wrong in Access'
Would the topics be using Access interactively, or would it be best practice, like table level validation, table lookups, multi-valued fields, etc?
 
SSAFA used to supply and End of Year Workbook, with half the columns hidden, on the left of the sheet?, instead of putting them over on the far right out of sight and calculation? :mad:
And these people were being paid?
They might be volunteers.
 
Would the topics be using Access interactively, or would it be best practice, like table level validation, table lookups, multi-valued fields, etc

Definitely a blog to be had there! Maybe "nolongerset" will pick it up ....
 
- if you are up to the challenge

As you are aware, common practice is to display data in a subform, with labels on the main form.

I suspect you have something else in mind?
 
I hadn't realised the advantages of turning data into tables....

This is always an interesting point of discussion for me. Not saying anything is "right" or "wrong", of course, just that there are advantages and disadvantages.

I've dealt with tables a fair amount from working with people who tend to use them often.

My ultimate conclusion (personally for myself) is that they annoy and cause problems a LOT more than they help.
Therefore, I never use tables. Except once my colleague has already incorporated a table into a workbook, which also contains VBA automation, in which case I'm kind of "tied" to it - converting the table back to a range causes a myriad of other problems.

But, to each his own. For me they're way overhyped.
 
Would the topics be using Access interactively, or would it be best practice, like table level validation, table lookups, multi-valued fields, etc?
certainly would think they need to be covered. But need to differentiate between those (I suspect the vast majority) who just knock something up using the tools as provided and are content with the results, and those who want or need to build something that is more robust, complex and/or efficient.

From a table design/performance perspective I would add the need for indexing, avoiding domain functions and the like and using Access sql when communicating with ODBC data sources, For form design the proper use of controls and awareness of order of events. For VBA use of option explicit, the difference between dot(.) and bang(!) and the benefits/drawbacks of both, proper declaration of variables etc.

All covered by many existing threads on this and other forums. Perhaps we need a title 'Access for people who don't want to be dummies' :geek:

I've previously suggested that learning access is a bit like learning to ski - first thing you learn is how to snowplough, the next thing you learn is how not to snowplough
 
Last edited:
Thank you very much for this thread, I found a lot of important and necessary for myself.
 

Users who are viewing this thread

Back
Top Bottom