|
|
|
Amazon.com
|
 |
|
|
|
|
|
|
|
Microsoft Access 2007 Tutorials for beginners |
|
|
Welcome to MS Tips and Tricks |
Welcome to MS Tips and Tricks -
You are at the right place if you need tutorials for beginners - Online Microsoft Access tutorials for beginners, covering the following categories
- Databases, Customization, Table, Forms, Queries, Reports, etc.,
|
Microsoft Access Tips and Tricks for beginners |
|
|
| |
| 6) Filter and order your data: Office Access 2007 facilitates the data filtering. For the text, number and date data types, several
filtrate options are available. |
| |
|
| Illustration 3: Office Access 2007 filtering options. Click here to view larger image. |
| |
 |
| |
| 7) Work with multi valued fields: Office Access 2007 admits complex data types, so you can create columns that accept more than one
value in each cell. For example, if it assigns a task more than a person, it will be able to include both names in the cell. The Windows SharePoint
Service's technology is compatible with these complex data types that help to guarantee the symmetry of data between the local data stores and the based
ones on Web. |
| |
| 8) Enclose documents and archives to the data base: Their applications can lodge information that can be more interesting and useful
than before. It can enclose several archives - like, for example, photography, documents or spreadsheets, - to individual records within the data store to
facilitate the queries. If the file is not in a compressed format, Office Access 2007 will compress it automatically; this way, it will save space in the
hard disk. |
| |
| 9) Design of interactive forms: Office Access 2007 includes an interface of design of forms WYSIWYG (what it sees is what is
obtained). It can design and modify the form design in real time in the screen - and obtain a previous forms view at design time. With the interface of
design WYSIWYG, you can create forms very quickly; in this way, you can spend more time working and dedicate less time to questions of design and format.
|
| |
| 10) Rich text: Office Access 2007 provides enriched text compatibility for the data stored in tables. |
| |
|
| Illustration 4: Edit forms in Design View. Click here to view larger image. |
| |
|
| |
| Report Creation |
| |
| Use Office Access 2007 to have the complex data organized by consolidating the data in significant information, which facilitates a decision making
better based. |
| |
| 11) Interactive report design: With the new functionality of Office Access 2007, you can see how the data will appear in a report at
design time. By means of new interface WYSIWYG, you can manipulate the report design directly while you examine the data in the report designer, so that it
does not have to execute the report to see the aspect that it will have in the page. This facilitates the creation of information of professional aspect and
saves time. |
| |
| 12) Interactive access to information in forms and reports: The new way of data exploration causes that the information are more
accessible. Use keys CTRL+B to look for registries, to copy data in other applications and to obtain detailed records to publish the data. |
| |
| 13) Information grouping in reports: The improved grouping panel provides a clear image of data groupings to obtain a previous view of the
modifications as they are applied to the information. You can easily add total, subtotal, counts and other elements that help to analyze the data. Also you
can group the information in one or several layers and add subtotals. |
| |
|
| Illustration 5: Edit reports in Design View. Click here to view larger image. |
| |
|
| |
|
|
| |
|
|
|
|
|
|
|
|
|
