El Ponys

Topic 6.
Create and navigate among records.
In the Datasheet view you can navigate among records using the up and down arrow keys, left and right ones, to go to the desired field. You can also use the tab to move from one field to another in one record and from the last field of a record to the first one in the next record.
Keyboard Commands to navigate among records
TAB or RIGHT ARROW Moveto the next field.
END Move to the last field in the current record, in Navigation mode.
SHIFT+TAB, or LEFT ARROW Move to the previous field.
HOME Move to the first field in the current record, in Navigation mode.
DOWN ARROW Move to the current field in the next record.
CTRL+DOWN ARROW Move to the current field in the last record, in Navigation mode.
CTRL+END Move to the last field in thelast record, in Navigation mode.
UP ARROW Move to the current field in the previous record.
CTRL+UP ARROW Move to the current field in the first record, in Navigation mode.
CTRL+HOME Move to the first field in the first record, in Navigation mode.

Add, modify and delete records
To insert a new record, select any record in the table and press the button New Record, on the records group on thehome tab. Also you can right click on a selected record and select New Record from the current menu.  A new record is added at the end of the table. you can delete a complete record or several records at once in a database. Select the row or rows and press Delete or press delete button of the records group on the home tab. Also you can right click and select delete record from the current menu.After a record has been deleted, this action cannot be undone.
Replace and search data
In the find and replace dialog box, type the text or numbers you wish to search and press next to locate the record containing those data. If you wish to replace the data, type the new data in the box Replace with and press on Replace or Replace all.
The find and replace dialog box searches one table at atime; it does not search in the entire Database. The menu Find on allows you to choose by field or in the entire table.
In a predetermined way Access search in the selected field when it opened the find and replace dialog box. If you wish to make a search using other field, select the field with the dialog box open, you don’t need to close it up first. 
In the menu match you can specify in whatpart of the field you wish Access to make the search. Select any part of the field for a more advanced search.
In occasions Access selects the verification tab Search fields with format. When you do it, do not unselect the verification tab, because it can cause your search not to find any results.
Attach and delete documents
Before starting to attach documents, you must create a field in atable and format it as field with attachments. You can add the field in the Datasheet view or in the Design view. Access shows an icon as office assistant on the header of the column and every record of the field next to a number in parenthesis which indicates the number of files attached in the field. Double click on the field with attachments to show the dialog box Attachments where you can add,open and save several attachments such as images, documents or excel sheets to one record.
Text
For alphanumeric numbers including text, letter numbers and special characters.
Maximum characters allowed are 255.
Memo
It is used to store texts longer than 255 characters using enriched format. For example, notes, long explanations and paragraphs with text format.
Up to 1 gigabyte of charactersor 2 gigabytes of storage (2 bytes per character) in which it is possible to show 65.536  characters in any type of control.

Numbers
To store numerical values being used in calculations, except currency values.
1, 2, 4, 8 or 12 bytes (16 bytes when they are used in an ID replica).
Date/Time
To store dates and times. Observe that every value stored includes a component of time and one for...