Access Examples

Format datasheets

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:

1. After opening the data sheet you want to change go to the Format menu and choose Data Sheets.
2. 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.
3. The second option is Gridlines which allows us to choose whether you want the vertical or horizontal lines active or not.
4. Background Color: as the name suggests is to choose the color of the cells just choose one from the list.
5. Color of grid lines: the same function as in the preceding paragraph but for the grid lines.
6. 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.
7. 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 »

Example of management benefits

This example shows how a management system for the provision of payments.

The example shows that this does is create and automatically with a click of a button, the benefits of a contract of sale through the data entered. That is, we introduce the client's name to the contract start date and the total amount payable. Then simply click the "calculate payments" that it automatically generates the number of installments and divides the value indicated by each of them and calculates the date of each installment (one per month). This is also an example that demonstrates how to add multiple records at once, because when you click the button it adds a record for each benefit.

Download: Insert Multiple Records

Posted in Dates , Samples , Forms , Modules , Records | 17 Comments »