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

Cara-cara mewujudkan Pangkalan Data

• CARA MEMBUKA MICROSOFT ACCESS

1) start menu

2)all program

3) find microsoft offfice and click microsoft access

• MEMBUAT PANGKALAN DATA  

1)click create a new file

2)click blank database

3)create the folder, name of file, location to save file and than click button create.

             TABLE

1. store information about specific topic
2. table consist of field and record
3. we can have more than one table in one database 

• table in design view

-insert the field name and data type

TYPES OF DATA TYPE

• Text - accepts up to 255 characters long that include combination of text and numbers
• memo - accepts up to 65,535 characters long that include the combination of text and numbers
• number - accepts number that is used in calculation
• date/time - accepts dates and times
• currency - accepts monetary values
• autonumber - automatically numbers each record for you
• yes/no - accepts only one of two values (yes/no), (true/false) and (on/off)
• OLE Object - accepts OLE objects
• hyperlink - can link to another documents or web page
• lookup wizard - to create a list of items to choose from when entering data in the field 

FIELD PROPERTIES

• Field size = the maximum number of character you can enter in the field. the largest maximum you can set is 255. Press F1 for help on field size.
• Format = The dispaly layout for the field. Select a pre - defined format or enter a custom format. Press F1 for help on format.
• Input Mask = A pattern for all data to be entered in this field.
• Caption = The label for the field whem used on a form. If you don't enter a caption,the field name used as the label. Press F1 for help on caption.
• Default Value = a value that is automatically entered in this field for new records.
• Vadilation Rule = An expression that limits the value that can be entered in the field. Press F1 for help on vadilation rule.
• Vadilation Text = the error message that appears when you enter a value prohibited by the vadilation rule. Press F1 for help on vadilation text.
• Required = Require date entry in this field?
• Allow Zero Lenght = Allow zero lenght as this field?
• Indexed = An index speeds up searches and sorting on the field, but may slow updates. Selecting "yes - no Duplicate"prohibits duplicate value in the field. Press F1 for help Indexed.
• Unicode Compression = Allow unicode compression for this field?
• IME Mode = Which IME Mode do you want to set when the focus is moved to the field?
• IME Sentence Mode = Which IME SentenceMode do you want to set when the focus is moved to the field?
• Smart Tags = Smart tags to be applied to this field.

• set the primery key

-highligh row and than click primery key(bentuk kunci)

-save the table( write table name)

-create table 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

-after you finish insert data you want, click next

-click next again

-click next agian

-click finish

-finish using data wizard

• make a relationship in table

-click relationship in toolbar

-choose data (ctrl + click the data)

- drag the same data to another one
  mark the enforce referential integrity

- finish relationship

Example to create table

doctor

1)docno:text4

2)docname:text50

3)typeofsick:150

4)mc:number

5)treatID:text4

patient

1)patientno:text4

2)name:text50

3)address:text100

4)noTEL:number

5)mobile:number

6)redID:text4

registration

1)regID:text4

2)regIC:text12

3)regDATE:date.time

treatment

1)treatID:text4

2)treatDATE:DATE.TIME

3)patientNO:text4