Clear out data

[MajP]

How many other Access apps with similar design do you think exist?.. Millions! I've come across several, all built with macros, tons of tables, queries, forms, reports.

From what I have seen, there is 1 and only one! You are looking at it.
I have seen thousands of examples on this forum and other forums of inefficient designs. I have never thing anything even 1/100th of the purported scale of inefficiency.

Everything else I have ever seen, you could help the OP take a dozen forms, queries, or tables and consolidate. Or normalize the data and knock it down from 10 tables to 3. There is only one person in the world who has hundreds/thousands of objects to do something that could be done in 1/100th of that.

 

[AccessBlaster]

One of the main issues I see is a rush to the end product, reports filled with flashy animations and eye candy while completely disregarding the foundational skills needed to create these advanced features, such as VBA.

 

[Isaac]

A Decision Support System performs better with denormalized aggregate tables, and some normalized apps that have too many joined tables that requires hairy stacked queries, so you partially denormalize some data to improve performance and simplify queries.

When he gets to the point where he has an entire data warehouse built that warrants ETL jobs loading denormalized data for reporting purposes, he is welcome to let us know. That's about where it's appropriate.

 

[NauticalGent]

Richard Rost has embarked on a very impressive project that is similar to what DakotaRidge is attempting to do.

He calls it the Fitness Database but it is so much more. A shame he took his toys and went home.

 

[Isaac]

I say have one form for every letter in the alphabet, then try to programmatically line up the forms onscreen to make words when needed! yah, that's what i say, dodgammit

 

[NauticalGent]

It really is a cradle to grave, step-by-step tutorial on apllication development. Over 30 videos and counting

 

[NauticalGent]

I think this is the introduction: