To design a Microsoft Access Database application for a Simple NNN Linkage,
you first need to define the purpose of the application by determining
how it will be used and what are the results that it must produce.
You can gather this information by talking to the people who will use the application. You will want to list the tasks that the
users must perform with the database and gather together examples
of the current paper forms and reports that they use and produce.
Using standardized nursing terminologies is viewed as critical in the healthcare industry for quality of care because this allows for enhancing the quality of documentation and the efficiency of nursing data management. Identifying the key nursing diagnoses, interventions and outcomes with standardized terminologies from the data for this population is important as the incidence increases and identifying the key nursing diagnoses, interventions, and outcomes will help build the evidence for caring for patient.
A variety of options are available for you to consider when you design
a Microsoft Access application interface. After analyzing the database
users need and workflow, you can then decide how users should be able
to navigate through your application and complete their tasks, and
whether you should work from within one Microsoft Access form, or
move from one form to another. You can use standard Windows components
that users will be familiar with, such as buttons, menus, text boxes,
list and combo boxes and scroll bars. Some of the customised navigation
tools that you can incorporate into your application design include
command buttons, custom menu commands and custom toolbar buttons.
You can also design an interface that controls how the database application
will start-up and what parts of the database application are available
to individuals or groups of the database users. Other elements of
the graphical user interface that you should consider are the layout
that you should use, how you will group particular objects and the
logic that you will apply to allow the user to move from one object
to another.
Nursing terminologies play an important role in describing and defining nursing care ; they provide the concepts and clear definitions of the phenomena of nursing and enhance nursing care by allowing nurses and other care providers to use the same terminology to describe patient problems, nursing interventions and patient outcomes in many settings, both nationally and internationally. Moreover, these standardized nursing terminologies can contribute to the development of middle range theories because nursing diagnoses, interventions, and outcomes classifications include lexical elements for the development of these theories built on elements unique to nursing. A substantive structure for nursing is provided from the pattern of nursing diagnoses, interventions, and outcomes.
As you will be designing database queries, forms, reports and other
objects based upon your database table design, it is extremely important
that you take time up front to plan
a sound database structure and it's relationships. Problems that
occur in the initial database table designs can negatively filter
throughout an application. As you analyze the data that the users
will be working with, separate it into different subjects, each of
which will become an entity.
You can eliminate data redundancy and inconsistent data dependency
by normalizing your data to ensure that all tables are in at least
third normal form.
After you have designed the tables and added some sample data, you're
ready to create queries to display the data in your forms. By examining
the forms that you will need to produce, you can determine how the
queries should be designed. Then, by creating queries, you can test
your table structures to see if they can produce the results that
you need. When you are ready to design your forms, it's a good idea
to clarify with your application users whether or not you must adhere
to the paper-form layout. Your forms in Microsoft Access can include
custom features such as macros, event procedures, object grouping,
or other queries that support form objects.
