Practical Report based on MS Access by Darshana891107

VIEWS: 8 PAGES: 8

More Info
									                                                   Content




Introduction about Database...........................................................................2



Tables, Primary keys & Secondary keys........................................................3



Relationship Draft...........................................................................................5



Actual Form Views.......................................................................................6



Conclusion...........................................................................................................8




                                                                                                         1|Page
                                      Introduction


Database

A database is a table consisting of columns (fields) and rows (records) where each column
contains a specific attribute and each row features a certain value for the corresponding
attribute. The number of columns within a single table depends on how many different
types/categories of information we need to store within a database, while the number of rows
is defined by the quantity of the objects that have to be introduced categorized records for.
This kind of simple organization of the data in database tables allows for a computer program
to quickly select and handle the necessary pieces of information.



     Relational Databases
In a relational database, the data is stored in tables. New information can be added without
the need for table re-organization. In a relational database, there can be an infinite number of
tables, each table containing different, though related, information.


     Flat type databases
In flat type databases, each line can hold only one record. They are most commonly used in
plain text format. Due to their simplicity, they are very quickly accessed or queried, which
makes them very useful for simple tasks.



    Hierarchical Databases
The hierarchical database model represents a tree structure, and a very good association is
Windows's File Explorer. The most popular hierarchical database is the IMS (Information
Management System), created by IBM.



My database is about the Order Management of an organization. Database system is a good
way to record and analyze the data. It gives more efficiency for an organization.




                                                                                     2|Page
                        Tables, Primary Keys & Secondary Keys


    Table
   A table in Access is quite different then a table in real life. Instead of having wooden legs
and being used for meals, Access Tables are a grid made up of rows and columns. Here's an
example of a table in Access:




   There are for key components we want you to learn right now:

   1. Order Details: The name this table is "Order Details".
   2. Columns: A column is one vertical section of the table (i.e. up-and-down sections).
      The vertical columns have their label at the top and these labels should describe the
      type of information that will be stored. The columns in this table are: Order ID,
      Product ID, Quantity, Price per Unit and Discount.
   3. Rows: A row is one horizontal segment of the table (i.e. left-to-right sections). One
      record takes up exactly one row. For example, in this table one order detail was Order
      ID 1119. This record was entered left-to-right as follows: Product ID-AGH-9877,
      Quantity-60, and Price per Unit-$7.20, Discount-0.00%.
   4. Cells: A cell is simply the intersection of a row and a column. When you enter
      information into Access it will often be one cell at a time.




                                                                                     3|Page
    Primary and Secondary Keys


The primary key of a relational table uniquely identifies each record in the table. It can either
be a normal attribute that is guaranteed to be unique (such as Social Security Number in a
table with no more than one record per person) or it can be generated by the DBMS (such as
a globally unique identifier, or GUID, in Microsoft SQL Server). Primary keys may consist
of a single attribute or multiple attributes in combination.
When we have defined all the fields in our database we should choose one field to be the
primary key. The primary key is an important feature of Access. Imagine we have an Order
Details table that contains a record for each order at this organization. The Order ID number
would be a good choice for a primary key in the Order Details table. The order quantity or
price per unit would not be a good choice, as there is always the chance that more than one
record might have the same quantity or price per unit.
We can create a relationship consisting of more than one field. Add an auto number as the
primary key in the Order Detail table. Open the index dialog and create an index with the two
fields.




                                                                                      4|Page
                   Relationship Draft


                               Orders
                       Customer ID

                       Order ID

                       Order Date

                       Ship No

                       Ship Date
Customer Details       Freight Charge
Customer ID            Taxes
First Name             Payment Received
Last Name                                  Order Details
Company Name                              Order ID
Company Address                           Product ID
City                                      Quantity
Phone Number                              Price per Unit
E-mail Address                            Discount
Ship No

Ship Country




                      Product Details
                      Product ID

                      Product Name

                      Price per Unit

                      In stock




                                                 5|Page
Actual Form Views




                    6|Page
7|Page
                                       Conclusion



In this assignment I create four Access tables. In that firstly I select primary keys and
secondary keys for these four tables. Then I enter ten records per each table. Next I build
three relationships for these four tables. In this I build a relationship between Customer
Details table and Orders table by using Customer ID as a common relationship. And I build
another relationship between Orders table and Order details by using Order ID as a common
relationship. Also I build another relationship between Order Details and Product Details by
using Product ID as a relationship.



Then I create four Forms for four tables. In that first I change into Form view to Design view.
Then I well align the rows of the Forms, insert new picture for heading to get more attractive
to my database system. I also insert the action button like Print Form or Previous Form or etc.
Also I use more colors to the Form rows.



So doing this process I got this Access database of Order Management System as an output of
my ICT Assignment.




                                                                                    8|Page

								
To top