Archive by category 'Settings'
Saturday, May 17th, 2008 |
In Access the appearance of standard data sheets is white and gray lines, but you do not like the normal aspect, we can change the look as follows:
- After opening the data sheet you want to change go to the Format menu and choose Datasheets.
- You will see the table formatting datasheets. In the first option have the effect of the cells, which may be flat, raised and sunken. The last two options only allow us to obtain an aspect of high or low relief and we can not choose anything else, the option plan that is able to choose more effects.
- The second option is Gridlines which allows us to choose whether you want the vertical or horizontal lines active or not.
- Background Color: as the name suggests is to choose the color of the cells just choose one from the list.
- Color of grid lines: the same function as in the preceding paragraph but for the grid lines.
- Border styles and line: change the appearance of gridlines, underline the column header and the border style of the data sheet. In the left list choose the line you want to change and list on the right line style.
- Direction: here we can change how the fields are presented in terms of order, we have the normal direction is from left to right or we can choose from right to left which will change the order of the fields and pull the right part Data Sheet. What we can see in figure 2. Note: this change can only be done on tables and not on data sheets on the forms.
Picture1:
Picture 2:
Posted in Colors , Definitions , data sheets , tables | 10 Comments »
Sunday, December 16th, 2007 |
You can use reports to present data printed. With a report, you can present information in a more summarized than in a form. For example, you can include totals throughout an entire set of records.
A report resembles a form, but allows more control over the display of the data when printed.
The key difference between forms and reports is the way data are collected. You group data in a form by creating a main form that contains a subform. The main form is based on a table or query, and the subform is based on a related table or query. In contrast, you can group data in a report from a single table or query. The table or query in Datasheet view, report and display the same data set, but each one presenting the data differently.
Report Header, appears only once per report. It can be used to print the company logo or some preliminary explanation.
Page Header, appears at the top of every page. Used to display the names of the columns of the report.
Heading the group appears at the beginning of each group (break). Used to display, for example, the name of a new group.
Detail is the body of the report. Appears for each record processed.
Footer group appears at the end of a group of registers. One can use it to display the total group.
Page-footer appears at the bottom of each report page. Used to print the report name and page number.
Footer of the report, appears only once per report, at its end. Used to display general. It appears after the last page footer.
Posted in Definitions | 5 Comments »
Saturday, December 15th, 2007 |
When you create a form, create a form of communication between you and the data stored in Access. While you can create simple forms that look very much like the familiar paper forms, you can also improve the appearance of them with interesting visuals - such as color and shading to define different sections, pictures or graphics - and a wide variety of controls. The Access forms can contain buttons, selection lists, radio buttons and embedded subforms that provide greater functionality than typical paper.
An example of a form
Creating a form with the help of a Wizard
The Wizard asks questions about the form you want to create and then create a form based on your answers.
To create a form with the help of an assistant
1. In the Database window, click on the Forms and then choose the New button.
You will see the New Form dialog box in which you choose which way of creating the form you want. See illustration.
2. To use the wizard select Form Wizard.
3. In the box that appears at the bottom, click on the arrow to choose the table or source query form.
4. Click OK.
If the Wizard does not create the form the way you want, you can manually change the form in Design view, or you can use the wizard again and choose different options as they answer the questions.
Posted in Definitions , Forms | 11 Comments »
Friday, December 14th, 2007 |
The Query window
A query is a question you ask about the data in your database, such as "Which customers have placed orders last month?" Or "How many products we have in each category?" To make an appointment, you set an example records you want to see in the Query window.
The Query window.
The Query window is a graphical tool like query-by-example (QBE - in English, Query By Example).
Because of its graphical features, you can use the mouse to select, drag and manipulate objects in the Query window.
When you create relationships between your tables, you make your work because Access automatically associates the tables in a query. If not established a relationship between tables in your database, you will have to associate them in a query.
Note: In the Query window, Access displays the field or primary key fields from a table in bold. Access processes more quickly when an association of the fields is associated with a primary key field. For this reason, the association will be slower if no primary key fields.
Creating or opening a query
The first step in creating a query is to add the tables on which you want to apply a query or update. You can also add other queries to the query. The Add Table dialog box lists all the tables and queries in the database in alphabetical order
To create a new query do the following:
Select the View tab;
Click the New button.
This opens the New Query window where you should define which mode table is built.
To facilitate your work whenever you start a New Query select Design View, which will define the fields that will be included in the table
- Click the Design View;
- Click the OK button.
Box appears to define the query. Along with the consultation will be open to the Show Table dialog box.
Posted in Definitions | No Comments »
Thursday, December 13th, 2007 |
A database contains one or more relational tables. A Table is a collection of related information, usually organized in horizontal rows and vertical columns.
You can compare the tables with Excel sheets. You can create an Excel spreadsheet, for example, to track students and enter the name of each on a separate line. Each category of information for each student is entered in the various columns: name, class, call number and so on. Each set of information about each student appears on a separate line.
Concepts
Records and Fields
Tables are made up of records and the records are made up of fields.
The fields and their data types
A data type defines what type of information that can be stored in the field in question.
For example:
Text - can be written in letters and numbers.
Numeric - Only numbers can be written, is not accepted letters.
Date - You only accept numbers in the date format can not be written or decimal numbers and text.
Defining the Fields in a Table
You have the following items defining the top of the window.
When choosing data types for each field is a menu where you must define the data type of the field support.
Field Name-Sets the name to be given to the field, for example Class.
Data Type-Defines the type of information that may be stored in this field.
Description-Allows you to create a description of the nature of the field in question. Access uses the description to the text property of the status bar in new forms, so that the description appears in the status bar when you view data in the form.
Data Type
-Text and text numbers, such as names and character.
Memo-extensive text and numbers, as comments or explanations; up to 32,000 characters.
Number-numeric data in which you intend to perform mathematical calculations, except calculations involving money. Set the Field Size property to set the data type "Number" specific.
Date / Time, dates and times. A variety of display formats available or can also create a.
Currency-Currency values. Do not use the data type "Number" for monetary values, because the numbers to the right of the decimal will be rounded in the calculations. The data type "Money" has a fixed precision.
Auto-Numbering-A unique sequence number (incremented by 1). This field will start the number one and placed it will increase each record one by one. AutoNumber fields can not be updated. For more information, see the property
Counter-sequential numbers automatically entered by Access. The numbering starts at 1. It's a great field for primary key.
Yes / No -Sim/Não, True / False, On / Off or fields that contain only one of two values.
Object OLE-objects created in other programs using the OLE protocol that may be linked or embedded in an Access database through a control on a form or report.
Research Assistant-Creates a field that allows you to choose a value from another table or a list of values using a combo box. Choosing this option in the Data Type list starts the Lookup Wizard to define the type of data.
Posted in Definitions | 2 Comments »
