Create modern MS Access forms and Advanced UI design Access
3.6 (8 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,221 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Create modern MS Access forms and Advanced UI design Access to your Wishlist.

Add to Wishlist

Create modern MS Access forms and Advanced UI design Access

Learn to design web like, modern MS Access forms, and a "Bigger picture" data approach in Access 2010
3.6 (8 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,221 students enrolled
Created by Lina Kompaneetz
Last updated 7/2017
English
Curiosity Sale
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
  • 33 mins on-demand video
  • 9 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Program modern MS Access user interface
  • Design a modern look in MS Access
  • Better data management approach
  • Flexible user interface in Access
  • Naming objects
  • MsAccess with SQL Server - performance considerations
  • Searching within the "Bigger picture" data approach
View Curriculum
Requirements
  • Understanding basic MS Access
Description
  • How to design a modern look in MS Access
  • How to make the Access form into a helpful dynamic portal.
  • How to match expectations
  • How to create flexible charts/reports.
  • Naming objects
  • MsAccess with SQL Server - performance considerations
  • Searching within the "Bigger picture" data approach

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.


Who is the target audience?
  • Anyone who wants to improve skills in MS Access form design
  • Anyone who wants to design modern MS Access user interface
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Introduction
9 Lectures 32:41

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.

Preview 03:44

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. 

Preview 03:47

Preparation steps to make MS Access design process faster and more efficient

Preview 03:21

More steps in the design process for the new MS Access form

Preview 03:13

In this lesson I will speak of naming (mainly) your MsAccess forms and queries.

Preview 03:50

in this lesson I will talk about MsAccess with SQL Server

Preview 04:50

Hello, in this lesson I will continue speaking about MsAccess with SQL Server.

Then talk about filtering within the "Bigger picture" data.

MsAccess with SQL Server 2
03:07

in this lesson I will conclude the concept of getting the most from the "Bigger picture" approach.

Getting the most from the "Bigger picture" approach
02:36

In this bonus lesson I will mention a few of the unexpected problems in access 2010, and solutions.

Bonus Access 2010 tips
04:13
About the Instructor
Lina Kompaneetz
3.6 Average rating
8 Reviews
1,221 Students
1 Course
MS Access/Vba programmer for 30 years,CLNT-SRVR, SSIS,SSAS

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.