A Sample Project : Electrical Goods

A Sample Project : Electrical Goods

Contents

1) Introduction

2) About the Project

3) System Configuration

4) Tables

5) Forms

6) Reports

7) Conclusion

8) Bibliography

Introduction

Microsoft Access is a relationship data base management system through which you can have multiple tables, all linked to each other through a common field, each table containing a specific type of information. For instance you can have one table containing a list of all the items that you sell, another table containing information about which item can be procured from which supplier another table containing orders for different items received from different customers and yet another table containing basic information about customer themselves and all this table can be linked together though common key fields.

Access also gives you the option of working with one access table by itself or with different kinds of data base fields and records has been explained later in the “Creating data base” section.

A modern relational data base management system can perform a wide array of tasks. In general it acts as a transparent interface between the physical storage and the logical presentation of data. In practice, it provides a set of more or less flexible and sophisticated tools for handling information, you can use these tools to

     Define a database

     Query the database

     Add, edit and delete data

     Modify the structure of the database

     Secure data form public access

     Export and import data

Because it gives you so much control over your data, a relational DBMS can also serve as the foundation for product that generate, Applications and extract data.

Which of theses abilities you consider most imported depends on The job that you need to do you might be in change of creating and Maintaining a database’ you might be a casual user who primarily works with existing applications to accomplish specific tasks, or you might be system developer who creates such applications. If you are using professional oracle version 5.1 all three roles in your works, so lets take a closer look at each of them.

About The Project

This project is purely based on “Electrical Goods” I have given the skill and logical ability to represent in my project.

This project contains:

3 TABLES:

     ORDER TABLE

     SALES BILLING DETAIL

     STOCK INFORMATION

3 FORMS:

• ORDER TABLE
• SALES BILLING DETAIL
• STOCK INFORMATION

2 REPORTS:

• SALES REPORT
• STOCK REPORT

System Requirements

Hardware:

Pentium IV and compactable with IBM PC

512 MB RAM

HDD 80 GB

Operating System: Windows 98 / 2000 Professional

SOFTWARE:

MS-ACCESS 2000

TABLES:

A Database is a collection of information about groups of items. A table is a collection of data, arranged in rows and Columns. For example, an admission table is a print out from a database. Fields in an admission table includes Name Address, Father’s Name, and Mother’s Name etc. For one individual is called a record.

In a database, you might have a number of tables each devoted to a specific topic. For example, Employee Salary database might contains tables or authors, titles and so on. Using separate tables for each topic can eliminate duplicate data, make data storage more efficient, and reduce data-entry errors. Tables are the basic building blocks of database diagram. In a database diagram, each table is laid out in a matrix so that you can see all the properties defend for every column in

Your database table.

DESIGNING TABLE:

To design a database, you should follow these steps:

1. Determine the need or purpose of the database.

2. Decide what kinds of thinks the database should include.

3. Specify the fields that comprise in the table and determine which field in each table contains unique value. Review and finalize the design.

4. Construct and relate the tables and populate the database with sample data.

1. Create forms, report, queries and data access pages to use with the data.

Insert new tables:

Adding a new table to the database diagram mean that you are defining a new table dies nit already exit in the database. To Create a new table, you must define the individual columns that make up the table. The table created in the database when you Save the table.

ADDING A EXISTING TABLE:

Adding an exiting table means that the table you want to appear in you diagram already exit in your database. If you add a group of tables to a diagram any Relationships that exit between the tables are also Address to the diagram.

TO ADD AN EXISTING TO A DIADRAM:

i. Make sure you are connected to the database

ii. Whose objects you want to edit.

iii. In the above table lost select table in the table folder.

iv. Drag the table into your database diagram.

Tables

Order Table:

Sales Billing Details Table:

Stock Information Table:

FORMS:

Forms provide a way for users to enter data without having to know a table is designed. One from can include data from multiple tables, providing one-stop data entry. A form is a graphical interface in which the user will enter the data.

There are two types of form:

1. Master entry form

2. Transaction entry form

Forms

Billing Detail Form:

Order Form:

Stock Information Form:

QUERY:

A Query selects record from one more tables based on user-specified criteria, you can create five different types of access queries: Select Query, Parameter query, cross tab query, Action query, & SQL (structured query Language) query.

ORDERING QUERY RESULT:

To sort a query, choose ascending or descending in the sort row of the columns you want to sort by. Fields to sort on don’t have to be next to each other they do need to be in order left to right.

REPORT:

A report is the output of the data in a database. Access gives you the freedom to report you data in a variety of ways. Reports can show all or only some of the data related to a record, and can be Based a table or a query.

In the other words, to make it accessible is really what gives access its name. When a report is a saved, the only structure of the report is saved-not the data you see in the preview. The report comes out in the form of

THE REPORT HAS THREE VIEWS:

1. Design view

2. Print view

3. Layout view

Before you print a report you might want to Check the margins, page orientation and other page Setup option.

Reports

Conclusion

The Project has been a rewarding experience in more ways than one.

Firstly I have gained as insight into the working of the “Electrical Goods”. This represents a typical real world situation.

Secondly in order to generate the final reports. All the steps of Database designing had to be meticulously followed. This has strengthened my understanding of database design.

Initially, there were problems with the validations. But finally I can appreciate the power of DBMS like MS-Access in managing data.

Bibliography

1. Ms. Access 2000 Complete.

2. Ms. Access 2000 in Easy Steps.