Whether you are developing a new MS Access application or upgrading/adding features to an existing one it is sometimes possible to implement something new. Most of the times clients welcome this extra effort – and commission tasks based on it. Traditional Access look is rather heavy. In this course you will learn new design guidelines - to make Access forms look lightweight and modern. But looks are not enough – I will show an extremely useful approach in designing user interface – which is greatly appreciated by people who use it in their day to day work. It is critical to present the data in comprehensive, easily managed formation. Sample file featuring all of the above is included. Using Vba opens before us a huge world of design possibilities.
In this lesson I will show you an example of a web like, modern looking MS Access form design, and a "Bigger picture" data approach. Replace an outdated look with forms designed like web pages.
In this lesson I will show you a concept example especially useful when working with a number of entities, each having a lot of data in their tables.
Preparation steps to make MS Access design process faster and more efficient
More steps in the design process for the new MS Access form
In this lesson I will speak of naming (mainly) your MsAccess forms and queries.
Hello, in this lesson I will continue speaking about MsAccess with SQL Server.
Then talk about filtering within the "Bigger picture" data.
in this lesson I will conclude the concept of getting the most from the "Bigger picture" approach.
In this bonus lesson I will mention a few of the unexpected problems in access 2010, and solutions.
Hello, my name is Lina Kompaneetz. I am an MS Access/Vba programmer for 30 years, developing Access (pure or frontend to Sql Server), for small to medium businesses. My clients have grown a lot over the years, getting the most from the clear data presentation, focused data management and comprehensive reports. The goal is to help to the max.
Through the systems developed I've had experience in resolving problems which were holding some businesses back. Here're a few of the industries: Music Company, Central concrete laboratory, Investment firm, Accounting office, Food packing and delivery plant, University students' housing and billing, Fine jewelry manufacture.
I believe my MS Access systems are thriving and continue to grow because they are vital and became invaluable to their companies.
I have also taught and helped my less experienced colleagues throughout the years.
My goal is to show how to build MS Access systems that will withstand the test of time – flexible, powerful and innovative.
Building Data warehouse solutions, importing\exporting data with SSIS, OLAP and SSAS - all of these are my tools of trade too.
Power BI, SSRS, Panorama - as OLAP viewers.