It’s like asking me to have a toolbox with no hammer – Expanded

There are few sections of this course that I just wish the whole world would watch. I think people don’t consider Microsoft Access enough.  People with Database in their job titles like to use higher level technologies, and Excel users are scared to venture out.

My thoughts are this…sometime the business case doesn’t warrant using a SQL Server Solution and building a complicated front end in .Net or whatever the coding flavor might be… Excel users don’t have someone like me on staff, saying “have you considered using Access?” unfortunately it’s often the opposite.

It’s the two sections: https://www.linkedin.com/learning/building-solutions-using-excel-and-access-2016-together

  • Building Reports for Your Solution
  • Using Parameters, Queries, and Macros to Generate Datasets

 

Building parameter queries using forms from Building Solutions Using Excel and Access 2016 Together by Robin Hunt

Setting drop downs for parameters from Building Solutions Using Excel and Access 2016 Together by Robin Hunt

Right now, if you build this month’s reports off last months, and your pulling data from a database…. then you need this course at least for “database awareness” so you can extend your skills, and be more productive. I can’t tell you when or why you might need these techniques or methods, but I would encourage you to watch the entire course and see if it applies to what you do.

Basically, instead of giving yourself a hard-coded query for each thing you need, or constantly building the criteria on dates, build a form. Let the form interact with the query. If you only use Excel, then stop the filter, delete, copy and paste routine you’ve grown to dread.

I have heard the technology departments in hundreds of organizations encourage people not to build databases in Access. I am sure they have their reasons, but for me it’s like asking me to have a toolbox with no hammer.

Sign up and enjoy it all for ten days – https://www.lynda.com/trial/Robin-Hunt/

Visit www.ThinkDatasol.com/blog post to view samples of the content.

 

×

Comments are closed.