Database Management System: Design, Queries, and Reporting

This report provides a comprehensive overview of Database Management Systems (DBMS). It starts with an introduction to DBMS, explaining its components, including tables, fields, and relationships, along with the role of queries, forms, and reports. The report then details the process of creating a new database, including setting primary keys and defining data types. It explains how to query a database to retrieve specific information and how to generate reports using wizards, including calculating totals. The report further discusses designing a contact management database, outlining the creation of tables and fields, and establishing relationships between tables. It also covers storing contact information and managing phone numbers and email addresses. The conclusion highlights the use of forms and reports for data management and the potential of VBA code for advanced database automation. The report is supported by several references to provide a strong base of research.

MG Database
Submitted by:
Date:

Introduction
The Database Management System (DBMS) is really a set of procedures and
equipment to store and acquire information. The database alone is the
stored information. The particular types of information stored in the specific
database are defined simply by corresponding data structures. The specific
database structure overall contains the tables, their component fields, and
the relations together. All given information within the database is stored in
these kinds of tables. A DBMS contains more than just the data. The DBMS
also includes queries, forms and reports. The specific forms are the displays
concerning screen and print that will allow entering new information into the
database tables in addition displaying the existing information. The specific
queries are searches from the database that extract specific information. The
reports are often formatted displays of the taken out for print, for screen and
information. (Baxevanis)
Create a New Data source
There are two ways to connect to a database: design plus use. The database
consumer can be, and most often can be, oblivious to the underlying style
principles. However, someone has to design the database, to create the
tables and their very own relations, to build the types, and implement
reports in addition queries. The designer interacts with the database in
various style modes that the most customers never experience. These
connections are iterative typically, given that initial designs are customized
as a reflection of consumer experience continually.
Primary key
After naming the desk, a window appears using the fields for the table
posted by rows. The first field could be the table’s primary key industry,

which can be reset by clicking on the Primary Key icon towards the top left in
the toolbar. The specific default Field Name in the primary key field is
certainly ID.
Data Type
Every field in a database shops information in a specific method, defined by
its Details Type. Most data areas tend to be Short Text areas for generic text,
yet there are several other possibilities shown in the accompanying table.
Replace the data type by clicking on the Data Type entry for that row and
then select an option from the resulting drop down choices. (Helen M.
Berman)
Query the Database
An initial purpose of a database would be to locate specific information about
a few of the data in the table(s). The particular query is a search for common
or specific data within the fields or field inside your database. Examples
include the first in addition last birth and brands dates of all employees,
employees with a last name of Jones just, just the people by means of
Oregon, salaries > $100, 000, etc. . . .
Data source Report
To create a template to have Access report, go to the Create tab and select
the Declaration Wizard. The first choice is to select a table upon which the
specific report is primarily based. The following select the Customer table.
Pick the fields that appear on the specific report then. Fields through
additional related tables could be selected also. The survey is formatted
similar to the framework produced by the Forms Wizard, and can be similarly
altered.

Calculate Totals
We want our own report to do some basic math, providing simple summaries
associated with interesting features of our information. With your report
open inside Design View, click the field/text box that you want to summarize,
which often here is the Zip text pot right under Zip Header. In Design View,
move forward the Design tab, where the Matters button is located in the
Collection and Totals section. Click on the Totals button to show the
particular drop down menu to select the necessary function, here Count Info.
(Hiroaki Kawasaki and Kazunari Taira)
Designing Contact Management Database
The first step to creating your own database is to plan out all the Tables
you’ll want as well as the Fields each one should consist of. To be as flexible
as possible, you might want to do this on paper. Each table should hold
home elevators a single topic. For example, the very first table we want
should maintain given information on the cable connections in our database.
We’ll contact this table ‘Contacts’.
The particular fields we choose for this desk depend on what we want to
know regarding our contacts. For example, allow us to say we want to store
their unique name, address, and a firm they are associated with, if any type
of. The details of the ongoing company are separate from the information on

the contact, so we are going to make a second table called ‘Companies’.
Later we’ll build a Relationship between our company field in the contact
report and our company desk that will allow Access to see information from
the company table whilst looking at the contacts desk.
There are in fact many components of information about a contact that
individuals could store in other dining tables and link back to our own contact
via relationships. This really is either because they are part of a larger set of
other information (as together with company) or because we wish to limit the
possible options the user can make to a strenuous list which the other desk
can store. (Hiroaki Kawasaki)
The relationship through Contacts to Contact. Here we have made a decision
to store all the various phone numbers and email addresses that might be
linked to a contact in a person table so as not to block up the original table
as well as account for there being simply no set amount of numbers one
contact can have. If we wanted to see the numbers for a get in touch with
then, we would search our personal Contact table for the get in touch with in
question just, via their own ‘Contacted’. This stands for ‘Contact Reference’,
a unique identifier of each contact.
Conclusion
Forms allow you to create user-friendly windows pertaining to changing or
adding information in the database, rather than going into the tables and do
therefore manually. Reports allow information to be displayed in a
customizable way that can utilize the results of any queries you might have
set up. Both of these Access features can be set up through wizards in the

Create menu inside the Ribbon, but are not necessary for you to use your
new database, so might be beyond the scope from the article. The true
hidden power associated with Access comes from the ability to create and
automate processes making use of VBA (Visual Basic pertaining to
Applications) code. This is a more complex topic that you should consider
exploring when you are comfortable with your current databases and there
are more features you wish that Access can’t supply on its own.
Reference
Andreas D. Baxevanis, The Molecular Biology Database Collection: 2003
Update, 2003 31(1), 1-12 Cited 52 times
SF Altschul, et al, Gapped BLAST and PSI-BLAST: a new generation of protein
database search programs, 1997 25 (17), 3389-3402 Cited 16221 times
Helen M. Berman, et al, The Protein Data Bank, 2000 28 (1), 235-242
Cited3937 times
Alex Bateman, et al, The Pfam Protein Families Database, 2002 30 (1), 276-
280 Cited 1017 times
Hiroaki Kawasaki and Kazunari Taira, Short hairpin type of dsRNAs that are
controlled by tRNAVal promoter significantly induce RNAi-mediated
genesilencing in the cytoplasm of human cells, 2003 31 (2), 700-707A Cited
90 times

Muhammad Sohail, et al, A simple and cost-effective method for producing
small interfering RNAs with high efficacy, 2003 31 (7), e38 Cited 17 times
Hiroaki Kawasaki, Eigo Suyama, Mayu Iyo, and Kazunari Taira, siRNAs
generated by recombinant human Dicer induce specific and significant but
target site-independent gene silencing in human cells, 2003 31 (3), 981-987
Cited 56 times