Microsoft Access 2021 avancé : Aider les utilisateurs finaux

Name: Microsoft Access 2021 avancé : Aider les utilisateurs finaux
Author: John Varan

Learn how to design applications to guide end users through workflows and prevent mistakes

Preview the first lesson free — get full access to all 3 lessons.

Cours : à la demande

Hello, my name is John Varon, and in these lessons, you will learn about helping end users. In this lesson, I will show you about user -centered design. When I say user -centered design, I'm simply talking about designing the user interface with a focus on what benefits the end users. There is also a specific design process and methodology called user -centered design, or UCD for short. Just to be clear, that's not what we're talking about in this lesson. I'm using the phrase in a more general sense. Sometimes it can also be called UX, or user experience design. A user -friendly design is one that makes it easy for users to learn and use the application. Everything should be intuitive, so that users don't need to read an entire user manual before being able to use your application. The user interface should also flow in a logical manner, following the same process as the user's own workflow. Therefore, going from how they normally do their job to using the application should be a seamless process. In general, a user -centered design should focus on five key areas. Number one is how easy it is to learn. The first time a user has to use certain functionality, they shouldn't be completely lost. It should usually be fairly clear where they need to go and what they need to do. Number two is efficiency. Doing something should not be overly complicated. It can help to think in terms of clicks, meaning mouse clicks. How many mouse clicks does it take to accomplish a task? The goal should be to minimize the number of clicks without compromising the other key aspects. Number three is recall, or how easy it is for users to remember what they've learned. If users pick things up quickly but then forget all of it by the time they use the application the next time, it's a problem. Therefore, keeping processes simple and easy to remember is a big advantage. Number four is mistakes. How many errors or mistakes do users make when they use the application? The goal should obviously be to minimize the number of errors. One way to do that is to prevent users from making mistakes. Another way is to guide them in the proper direction instead of leaving things open -ended where the user could choose incorrectly what to do. Number five is enjoyment or satisfaction. This one is simply about how enjoyable the application is to use. This is where things like artistic style and color palette can make a difference. While it would be great if we could address all five of these key areas, the reality is that we aren't creating standalone applications that we have full control over. These database applications are running inside of Microsoft Access, so we are limited by what Access can and cannot do. Some of the key areas are difficult for us to address and mostly out of our control, but not all of them. Namely, numbers one, two, and three, ease of learning, efficiency, and how easy it is to remember are largely governed by Microsoft Access itself. Although our design can definitely make a difference in those areas, we're not going to focus on them too much because we only have so much control over Microsoft Access's user interface. Number four, reducing the number of mistakes is one we have a lot of control over and one that Microsoft Access gives us a lot of tools which we can use to accomplish our goal. This is the main key area we will focus on, especially since it's usually the most important one in most business or corporate environments, which are the most common environments where Microsoft Access database applications are used. Number five, how enjoyable the application is to use, is also one we do not have a lot of control over. Microsoft Access does allow a tremendous amount of customization options, but it's limited by Access's own interface. Even so, we can change color palettes, background images, icons, and even use different user control visual styles. However, we will not be focusing on this key area much either, as it is largely artistic in nature and also involves design choices specific to particular groups of users or demographics. Thanks for watching. Stay tuned for the next lesson where I will show you about guiding users through the desired paths.

Avancé Fournisseur : John Varan 3 leçons · 17m en Arabe, Allemand, Anglais, Espagnol, Français, Portugais, Chinese

Description du cours

User interface, or UI, design is an important and complex field, and much can be said about how much of an impact it can have on the experience of end users. Understanding the basics of UI and how to best implement it within the limitations of Microsoft Access 2021 can help you design with the end user in mind. You can increase user efficiency and productivity with minimal confusion by designing your application with the end user in mind. Organizations often want to maintain the integrity of the data in their database, which is why we will also explain how to use validation rules and calculated values to block invalid input from end users.

In this course, you will learn how to design a user interface with a focus on end users. We will discuss how to guide users efficiently and easily through the desired paths of your workflow. We will also explain how to prevent users from making the most common types of mistakes so that your data stays consistent and correct. By the end of this course, you will be able to create a functional database application that appeals to your end users.

Ce que vous allez apprendre

Discuter des composants d'une conception d'interface utilisateur appropriée dans Microsoft Access 2021
Explorer les meilleures pratiques pour guider les utilisateurs à travers l'application le long des chemins de flux de travail souhaités
Appliquer des règles de validation et des valeurs calculées pour empêcher les utilisateurs de créer des données erronées ou non valides
Concevoir une interface centrée sur l'utilisateur qui augmente l'efficacité et la productivité de l'utilisateur final
Empêcher les utilisateurs de suivre des chemins non souhaités et de commettre des erreurs courantes
Créer une application de base de données fonctionnelle qui séduit les utilisateurs finaux

Points clés à retenir

La conception de l'interface utilisateur (UI) a un impact significatif sur l'expérience des utilisateurs finaux et peut augmenter leur efficacité et leur productivité avec un minimum de confusion.
Concevoir une application en gardant l'utilisateur final à l'esprit permet de guider efficacement les utilisateurs à travers les chemins souhaités d'un flux de travail.
Les règles de validation et les valeurs calculées peuvent bloquer les saisies invalides des utilisateurs finaux et aider à maintenir l'intégrité des données dans une base de données.
Empêcher les utilisateurs de commettre des erreurs courantes permet de conserver des données cohérentes et correctes.
En travaillant dans les limites de Microsoft Access 2021, vous pouvez concevoir une application de base de données fonctionnelle axée sur les utilisateurs finaux.

Foire aux questions

À qui s'adresse ce cours ?

Il s'adresse à ceux qui souhaitent concevoir une interface utilisateur Microsoft Access 2021 axée sur les utilisateurs finaux, en les guidant efficacement dans les flux de travail et en évitant les erreurs courantes.

Que serai-je capable de faire à la fin de ce cours ?

À la fin du cours, vous serez capable de créer une application de base de données fonctionnelle qui séduit vos utilisateurs finaux.

Quels sujets ce cours couvre-t-il ?

Il couvre les composants d'une conception d'interface utilisateur (UI) appropriée, les meilleures pratiques pour guider les utilisateurs dans l'application, empêcher les utilisateurs de créer de mauvaises données et les meilleures pratiques pour créer une interface utilisateur conviviale. Les leçons incluent Conception centrée sur l'utilisateur, Guider les utilisateurs à travers les chemins souhaités, et Empêcher les utilisateurs d'utiliser des chemins non souhaités.

Comment ce cours aide-t-il à maintenir l'exactitude des données ?

Il explique comment utiliser des règles de validation et des valeurs calculées pour bloquer les entrées non valides de la part des utilisateurs finaux, contribuant ainsi à maintenir l'intégrité des données dans votre base de données.

Quelles compétences ce cours aide-t-il à développer ?

Il aide à développer des compétences en accès aux données, en formation et assistance aux utilisateurs finaux, en conception d'interface, dans Microsoft Access, dans les composants d'accès aux données Microsoft (MDAC) et dans l'assistance utilisateur.