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

Microsoft Access-Forms And Reports

OVERVIEW Access Forms creates the user interface to your table. Although you can use Datasheet to perform many of the same functions as forms. Forms are used as an alternative way to enter data into a database table. It provides a different way of viewing table data. Access enables us to create forms that can be used to enter, maintain, view, and print data.               The Form is constructed from a collection of individual design elements called controls or control objects. Control are the components we see in the windows dialog boxes of the access and other windows applications like buttons, check boxes etc. We use text boxes to enter and edit data, labels to hold field names and object frame to display graphics.               A Form Wizard is provided to assist you in the construction of forms. Four types of forms can be created. These include single-column ( displaying one record at a time in a verti...
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 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 syste...
Read more »facebook