What are you doing WRONG!

[Uncle Gizmo]

Excellent video on Excel this, and I found out I'm doing lots of things wrong!

 

[CJ_London]

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'

 

[Uncle Gizmo]

I hadn't realised the advantages of turning data into tables....

 

[CJ_London]

think it is a lot easier to transition from access to excel rather than the other way round

 

[oleronesoftwares]

As usual @Uncle Gizmo thanks for sharing.

 

[Gasman]

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?
And these people were being paid?

 

[NauticalGent]

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?

 

[oleronesoftwares]

think it is a lot easier to transition from access to excel rather than the other way round

Yes, but I think most access users will stick to it and would add excel skills in their spare time.

 

[oleronesoftwares]

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?
And these people were being paid?

They might be volunteers.

 

[Uncle Gizmo]

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 ....

 

[Gasman]

They might be volunteers.

No they were paid employees, we were the volunteers having to put up with thier crap.

 

[Uncle Gizmo]

- 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?

 

[oleronesoftwares]

No they were paid employees, we were the volunteers having to put up with thier crap.

So the volunteers knew more than those been paid.

 

[Gasman]

So the volunteers knew more than those been paid.

Perhaps, in some instances.

 

[Isaac]

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.

 

[CJ_London]

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'

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

 

[JackWhite]

Thank you very much for this thread, I found a lot of important and necessary for myself.