About Me

Hi I'm Hilbert Pastrana..

I'll tell you more about myself here.

I'm 23 yrs. old.

I was born in City of Lucena on the 11th of June,

I'm currently studying in STI College Lucena,

Taking up, Diploma in Information Technology.

I'm a pure catholic, i can speak Tagalog and English.

My mother is Nelly Pastrana, she works as a beautician.

My father is Felipe Pastrana, he is not currently working because he cant work anymore.

My favorite subject is Science

My favorite pastime is surfing the internet, playing online games & reading books, magazine, articles and documents in the field of my interest.

My favorite pastime is watching Discovery Channel, & National Geographic Channel.

I love to eat pasta's, specially baked macaroni.

I love drinking tea's and juices.

My ambition is to graduate from college, have a decent and stable job enough to support my family.

My motto is "Peace begins with a smile." n_n

Microsoft access tutorial 6

Unit 11. Forms (I)

Forms generally serve to define screens with which to edit the records of a table or query. In this unit we will see how to create a form, and how to operate it for the editing of records and changing its design.

Introduction.

To create a form we need to position ourselves in the database window with the Form object selected, if we then click on the button a window opens with the various ways we have to create a form: Design view opens a blank form in design view, and we then need to incorporate the various object that we would like to appear in it. This method is not used much as it is easier and faster to create an autoform, or to use the wizard and afterward modify the design of the created form to adjust it to our needs. We will see ahead in this unit how to modify the form design. Form wizard uses an a wizard that guides us step by step in the creation of the form. Autoform consists of automatically creating a new form that contains all the data from the source table. According to the type of form that we select (columnar, tabular,...) the form will present the data in a distinct way, when we click on one of the options, a sample will appear on the left side with the way in which the data will be presented with this option. E.g Autoform: columnar presents one record on a screen, meanwhile Autoform: tabular presents all the records on one screen and every record in a row. In order to use this function we first need to fill out the Choose the table or query where the object's data comes from: with the name of the source. This will be the only data to introduce, and once introduced we select the kind of autoform and click on OK button, and Access does the rest. Chart Wizard uses a wizard that guides us step by step in the creation of a graphic. Pivot table wizard uses a wizard that guides us step by step in the creation of dynamic table. We will next explain how to create a form using the wizard.

The Form's wizard

To start the wizard we can do it as describe in the last point, or a faster way would be from the Database window with the Forms object selected, by double clicking on the Create form using wizard option.

The first window of the wizard appears: In this window we are asked to introduce the fields to include in the form. Firstly we select from the Table/Queries box the table or query that we are going to get the data from, this will be the form source. If we want to extract data from various tables it would be better to first create a query to obtain this data and then select this query as the form source. Next we will select the fields to include in the form by clicking on the field and then the button or simply double click on the field. If we selected the wrong field click on the button and the field will be removed from ther selected fields list. We can select all the fields at the same time by clicking on the button or deselect all the fields at once using the button . Next we click on the Next> button and the window seen in the following example will appear...

In this screen we select the data distribution within the form. By selecting a format it will appear on the left side the way it will be seen in the form.

Once we have selected the distribution of our choice click Next and the following window will appear: In this screen we select the forms style, we can select between the various defined styles that Access has. By selecting a style it will appear on the left side as it will in the form. Once we have selected a style of our choice we click on the Next button and the last screen of the forms wizard will appear.

In this window we are asked for the title of the form, this title will also be the name assigned to the form.

Before clicking on the Finish button we can choose between:

Open the form to view or enter information, in this case we will see th result of the form ready for the editing of data, e.g:

or,

Modify the form's design, if we select this option the Form design view will appear where we can modify the aspect of the form, e.g:

Unit 12. Reports (I)

Reports are generally used to present the data of a table or query in order to print them. The basic difference with reports is that the data can only be visualized or printed (it can not be edited) and the information can be grouped and totals extracted by group more easily. In this unit we will learn how to create a report using the wizard, and how to change its design once created.

Introduction

To create a form we need to position ourselves in the Database window with the Reports object selected, if we click on the button a dialog box will open with the different types of reports that we can create. Design view opens a blank report in design view and we then need to incorporate the different controls that we want to appear within it. This method is not usually used as it is both easier and more comfortable to create an autoreport or to create a report using the wizard, and afterwards to edit the design of the report to suit our particular needs. Ahead in this unit we will see how to edit the reports design. The Report wizard uses a wizard to guide us step by step through the creation of the report. Autoreport consists of automatically creating a new report that contains all the data of the source table or query. The data will be presented differently depending on the type of report chosen, and when we click on one of the options a model will appear on the left. E.g Autoreport: columnar presents each record on one page while Autoreport: tabular presents various records on the same page with a record in each row. We saw these layouts with forms in unit 11. In order to be able to use this option we first need to fill in the Choose the table or query where the object's data comes from: box with the name of the report's source. This will be the only data that we need to introduce, and once it has been introduced we select the type of autoreport and click on the OK button, Access will do the rest. The Chart wizard uses an assistant that guides us step by step through the creation of a graphic. The Label wizard uses an assistant that guides us step by step through the creation of labels. Next we will explain how to create a report using the wizard.

The Report wizard

To start the wizard we can use the method explained in the previous point or a faster and easier method would be from the Database window with the Reports object selected to double click on the Create report by using wizard option.

The wizard's first window will appear: In this window we are asked to introduce the fields to be included in the report. Firstly we select the table or query from the Tables/Queries box where it should extract the data from, this will be the report source. If we want to extract data from various fields it would be best to create a query to obtain the data and then to use this query as the source of the report. Next we select the fields by clicking on the field and then on the button, or simply double clicking on the field. If we make a mistake we click on the button and the field will be removed from the list of selected fields. We can select all the fields at the same time by clicking on the button, or deselect all at the same time by clicking on the button. Click on the Next> button and the next window will appear...

In this screen we select the grouping levels within the report. We can group the reports by way of various concepts, and with each concept add a group header and a footer, and in the group footer we will normally see the group total.

To add a grouping level click on the field by which we want to goup and click on the button (or double clic directly on the field).

A diagram will appear to the right indicating the structure that our report will take on, and in the central zone the fields that are seen for every record will appear. In our example a group by city will appear at the top and a group by postal code will appear at the bottom.

To remove a grouping level click on the header corresponding the group and click on the button.

If we want to change the order of the defined groups we use the button, the upward arrow will move us up a group, and the downward arrow will move us down a group.

With the button we can refine the grouping. click on this button and the following screen will appear.

The different groups that we have defined will appear in this box, and for every group that we have the field that defines the group in Group-level fields:, and in the drop down list of the Grouping intervals: we can indicate whether it should use the complete value contained in the field to group, or use the first letter, the first two letters, etc... After clicking on the OK button we return to the previous screen.

Microsoft access tutorial 5

Unit 9. Crosstab queries (I)

Introduction

A crosstab query is used when we want to represent a summary query with two grouping columns like a double input table, in which each one of the group columns is an entry, one down the left side of the datasheet and the other across the top.

E.g we want to obtain the monthly sales of our employees from their sold orders. We need to design a summary query that calculates the sum of the amount of orders grouped by employee and month of sale.

The query will be much more elegant and clear, presenting the data in a more compact form as we see next:

Well this last result is obtained by way of a crosstab query. Observe how one of the grouping columns (Agent) defines the rows that appear (there is a row for each agent), whilst the other grouping column (month) now serves to define the columns, each month value defines a column in the result, and the convergence cell of an agent value and a month value is the summary column, the one that contains the summary function (the sum of the sales). Crosstab queries can be created from the design view but it is faster more comfortable to use the wisard. Unit 10 . Action queries (I) Action queries are queries that permit us in just one operation to perform changes on one o various rows in a table. With these queries we can create a new table including in it the records of another, change the data stored, insert new records or erase old records. Either way, before making the modification effective a dialogue box appears to confirm the operation, giving us the opportunity to cancel. These messages can be unshowned, if you want to know how click here . Depending on what the query performs, there are fout types of queries: Make-Table queries Update queries Append queries Delete queries Next we will explain each type of action query to you. Make-Table queries. A Make-Table query creates a new table with the records stored in one or more tables. They are usually used to create working tables (we create it for a determine task, for example to store the results of a complex query that is taking long to execute and that we will use in various reports, and when we are finished with the task we erase it). They can also be usefull to create export tables (extract data from a table to send it to someone or to make copies of our tables). And finally they are used to create history tables. To create a Make-Table query: Open a new query in design view. We add one or more tables from where we are going to extract the data to save in our new table. We design the query in the same way as a normal selection query, so that only the records we want to save in the new table will appear. Then, we drop down the Query menu and select the Make-Table Query... option. or, we can drop down the list from the button on the toolbar and select the Make-Table Query... option. The Make table dialogue appears: We type the name of the new table in Table Name: box. We normally create the table in the same database (Current database option) but we can create it in another database, and in this case we will need to check the Another database: option and type the name of the database where the table should be made in the File Name: box. It needs to be the complete name including the complete path, and therefore it is easier looking for the database using the Browse... button; click on it and search for the database where we want to save the new table. Finally, click on the OK button and we return to the Query design: The design window is the same as that of a selection query, and in it we define the selection query in order to obtain the data to be saved in the new table. The only difference is that on the title bar, after query name, we can see the words Make Table Query and if we open the query properties by clicking on the button on the toolbar we will see the name of the table to create in the Destination table property and the database where it will be made in the Destination DB as we can see below: To see the data that will be stored in the new table, before create it, click on the Datasheet view type on the toolbar or drop down the View menu and select the Datasheet view option. This option allows us to visualize the data without creating the new table to make sure they are the correct data. The Run query option makes it so that the new table is made with the data obtained from the query. To run the query click on the button or drop down the Query menu and select the Run option. When we run a make-table query we are advised of this, and we are also advised when a table already exists with the same name as the new one. The fields in the new table are named as the headers of the query fields, and inherit the same data type as the source fields but they do not inherit the properties such as the primary key, indexes, etc...