Microsoft Office Access 2010
by gustavo de nicolo
1. Database
1.1. amounts of data
2. Data tables
2.1. the major part of access
3. Forms
3.1. form is designed for entering, viewing, and modifying data in tables
4. Reports
4.1. is designed for formatting, calculating, printing and summarizing selected data from a table
5. Access file
5.1. store table, query,
5.2. report and others
6. Create Table
6.1. Access templates or blank database to create tables
6.1.1. 1. Templates
6.1.2. 2. For blank database
6.1.2.1. a) Datasheet view: Create and enter data in normal view
6.1.2.2. b) Design view: To specified field option
6.1.3. an object that provides a personal view of the data
7. Consultations
7.1. query
8. Primary Key
8.1. a single field containing data that will not be repeated on the table
9. Relationship
9.1. Is an Access database tool to create a relation between tables to avoid duplication and to link related fields.
9.1.1. Include information of both tables that are equal
9.1.2. Include all records from the first table and only equal fields from the second table
9.1.3. Include all records from the second table and only equal fields from the first table