CREATE A REPORTS IN MICROSOFT ACCESS

WHAT IS REPORTS?
A report is an effective way to present your data in a printed format.Because you have control over the size and appearance of everything on a report, tou can display the information the way you want to see it.

report is the summarized of data contains in the database.

CREATE REPORTS

* click reports and create reports by using wizard

* choose the table/queries and select field and click next to continue

* click next to continue

* click next to continue

* edit the layout and click next to continue

* click the style you want to use for your report and click next

* type a name for your reports and click finish to create your reports

* the reports finish

CREATE A FORM BY USING FORM WIZARD

INTRODUCTION

A form is a graphical display for adding, updating, viewing, and deleting data from one or more tables

•  before we start create form.firstly we have to make table an queries.
• after finish table and queries.we can start to create form.
• click at FORM and create form by using wizard.it very simple.

* click the table and insert the data and then click next to continue

* click next to continue

* edit and click next

* edit the layout and click next

* setting the style and click next

* edit the title and click finish and then the form will be display

* the form will be like this

* click at design view to edit

* click the button toolbox at the tool bar row to display the toolbox

MAKE THE ACTION BUTTON

* click the command button

* click and drag at the form

* choose the categories and action and then click next to continue

* click next to continue

* rename the name of the button and click finish

* the button will be display like this

 * form finish

CREATE A QUERIES IN MICROSOFT ACCESS 2003

Queries are used to view, change, and analyze data in different ways. You can also use them as the source of record for forms, reports, and data access pages.

• before i want to teach to create queries in microsoft access.we have to create table.

Customer :  

cust_no (data type - text6) PRIMARY KEY

cust_ic (data type - text12)

cust_name (data type - 50)

cust_adress (data type - text100)

cust_mobile (data type - number)

Product :

ID_product (data type - text50) PRIMARY KEY

product_name (data type - text 100)

cust_no (data type - text6)

Booking :

Booking_no (data type - text6) PRIMARY KEY

Book_date (data type - date/time)

Price perunit (data type - number)

Quantity (data type - number)

Grant_total (data type - number)

payment_status (data type - yes/no)

payment_date (data type - date/time)

ID_product (data type - text5)

Delivery :

ID_delivery (data type - text6) PRIMARY KEY

Delivery_date (date/time)

Delivery_status (data type - yes/no)

type of delivery (data type - text50)

Booking_no (data type - text6)

- and make relationship

finish table

CREATE QUERIES IN DESIGN VIEW

• click queries and create query in design view

insert the table you want and click add

the selected table will appear

drag the data at table you want to field name row

       

the queries can be like this

save the queries and click ok

CREATE QUERIES BY USING WIZARD

• click queries and create query by using wizard

>   use to insert one data only
>> use for insert all data
<   use for remove one data onlu
<< use for remove all data

choose the table and click at the field name and click at symbol > or  >>

after that click next

next

and finish

the queries complete