How we create a database using the database Wizard

HI I am safeer.
Safeermughal779@gmail.com
This is my email. you can communicate with this email.
The database Wizard guides you through process of the creation a database; it includes choosing a database template, selecting fields, making customization, adding pictures, and the database.

  1. When Microsoft Access first stars up, a dialog box is appeared with option to create a new database or to open an existing one. when this dialog box appears, select Access Database Wizards, Pages, and projects and then click OK. Microsoft Access starts up, when you click the New Database on the toolbar.
  2. On the Database tab, double-click the icon for the kind of database you want to create.
  3. Specify a name and location for the database.
  4. Click Create to start defining the new database.   






DATABASE  OBJECTS


                                    (1)     Tables                             (2)      Queries
                                    (3)     FORMS                          (4)      Reports

Tables: 

            The Most important object of a database is a table. The data is stored in tables of database. A table is a collection of related data organized in rows and columns. A Table having records of students is given blow. Each record contains fields;

Student ID , First Name, Parents Name, Address, City, Major ID, and Class ID.

A relational database may consist multiple tables, which are identified by unique names. This is the fundamental property of a relational database.

 

Queries:

              Query is a statement that extracts specific information from database. It is created by specifying the fields to display from a able or another query. It is more flexible way of selecting , filtering and sorting records.

             The user can also change data in the database that fulfils certain criteria. In addition, queries allow to perform calculations of differen fields. The output of a query is also displayed in the form of a table and can also be used as source of records for forms and reports.

  The query allows you to view and analyse data in many different ways. Technically, a query is a stored question or request. You design a query in design view to extract certain information from the database.

 FORMS:

                The Form object of database is used to enter data into database, edit data and view data from database. You can add, update, and delete records in your table by using a form.Most of the DBMS provide the facility to create Forms. The application programmer creates the user interface by designing the Forms.In this way and Reports, the users can perform different operations on the database very easily.

 

 REPORTS:

                   The Report object of database is used to retrieve and present data in a formatted way. The Reports can be printed. Some reports are simply a list of the records in the database, one record after the other. Most of the popular DBMS provide this facility. The output of the query can also be given as input source to reports.

The difference between the forms and reports is: 

  • Forms are used to enter data into database, change data and view dataof database.

    Reports are used to retrieve the data from database and present it on screen in a predefined forma. Reports do not allow user to change data or to enter data into database.

 

 

Comments

Post a Comment

Popular posts from this blog

Data Base Design Process

OVERVIEW: Before we design a database for any organization, we have to consider many aspects to find out the practical scenario of owning a database. Few of them are discussed as follows: Feasibility Study: This is also called preliminary investigation of the required database. It involves the area identification and selection. i.e. which area or aspect is to be selected to start with. After the project is selected, it is allocated a specific fund and a proper planning is chalked out for its practical implementation. Side by side, a proper market analysis is also worked out. Requirements Analysis: During this activity, the requirements are gathered i.e. the possible inputs for the database and the required functionality out of it. The users precisely narrate their needs of the database and the possible domain and restrictions are also chalked out. Project Planning: A proper schedule is laid down to accomplish this activity. All the cost factors are taken into consideration i.e.
Read more »facebook

Data Integrity And Normalization

OVERVIEW: Data Integrity: Database integrity refers to the correctness and consistency of data. It is another form of database protection. While it is related to security and precision, it has some broader implications as well. Security involves protecting the data from unauthorized operations, while integrity is concerned with the quality of data itself. Integrity is usually expressed in terms of certain constraints which are the consistency rules that the database is not permitted to violate. Following two are the most important constraints in relational database: (i)       Entity Integrity: is a constraint on primary values that states that no attribute of a primary key            should contain nulls. (ii)      Referential integrity: is a constraints on foreign key values that states that if a foreign key                  exist in a relation, then either the foreign key value must match the primary key value of some            tuple in its home relation or the foreign k
Read more »facebook

Data Base

 A   Data Base is a collection logically related data sets or file . No r maly, these files /data sets are of different nature, used for specific purposes. these may be organized in various ways to meet processing and retrieval requirements of the organizations or users.                                      A  Data base system is just a computerized record keeping system. A data base itself can be regarded as a kind of electronic file cabinet, a warehouse or a repository for a collection of computerized data files. the user of he database normally has he following facilities to enjoy. Adding new , blank file to the database. Inserting new data into the existing files. Retrieving data from existing files. Updating data in existing files. Deleting data from existing files. Removing existing files, empty or otherwise from the database. A database system involves four major components, namely.             Data                   The Information             Har
Read more »facebook