Create modern MS Access forms and Advanced UI design Access

Name: Create modern MS Access forms and Advanced UI design Access
Rating: 3.5 (53 reviews)

Learn to design web like, modern MS Access forms, and a "Bigger picture" data approach in Access 2010

Created byLina Kompaneetz

Last updated 5/2020

English

What you'll 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

Course content

1 section • 9 lectures • 36m total length

A "Bigger picture" data approach in MS Access3:44
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.
Working with a number of entities in MS Access3:47
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.
Preparations for fast and efficient design process Access3:21
Preparation steps to make MS Access design process faster and more efficient
Design process for the new form MS Access3:13
More steps in the design process for the new MS Access form
Naming (mainly) your forms and queries3:50
In this lesson I will speak of naming (mainly) your MsAccess forms and queries.
MsAccess with SQL Server4:50
in this lesson I will talk about MsAccess with SQL Server
MsAccess with SQL Server 23:07
Hello, in this lesson I will continue speaking about MsAccess with SQL Server.

Then talk about filtering within the "Bigger picture" data.
Getting the most from the "Bigger picture" approach2:36
in this lesson I will conclude the concept of getting the most from the "Bigger picture" approach.
Bonus Access 2010 tips + Bonus Downloads4:13
In this bonus lesson I will mention a few of the unexpected problems in access 2010, and solutions.
Create a plan for your entity portal - base tables, keys, relationships.
Decide on an Entity and create a Portal

Requirements

Understanding basic MS Access. Best at the very beginning of a new app.

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

*Please, take a moment to read this note before You decide to enroll: It is not an "In depth" MS Access course, but an extension to everything you already know about MS Access design environment.

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 this course is for:

Anyone who wants to improve skills in MS Access form design
Anyone who wants to design modern MS Access user interface