Database guia

DATABASE.

1.- Is an application software that permits to create and to manage database that are in any storage unit of the computer.  R= Microsoft Access 2010.

NOTE: The databases are formed by rows and columns in from tables. Numerical or alphanumerical data.

2.- Start a session.

STAR BUTTON

Click on the star button.

Select all programs.

Select Microsoft Office.

Click on Microsoft Access 2010

DESKTOP

Double click on the sort-cut that is on the desktop.

3.-You can visualized in pink color the menu File with the options of Save as, New, Open and Exit. You can choose a predetermined template in different categories, a blank database or open an exciting database from any storage unit.  R= Initial Screen.

[pic 1]

4. - Button to open an existing database; click on it to activate this button. R= Open.

5. - Button to create a new database; click on it to activate this button. R=New

6. - Here is shown the list of templates, click on it  to open. R= Initial Screen

7. - Button to change the location where tha database will be saved. R= Save as.

8. - button to create the new database. R= Create

9. - Name of the new database. R= File name. (nombre de archiveo)

10. - Here is shown a list of the recently used files. R= Recently (reciente).

   [pic 2]

11. - This section is in the bottom part of the main screen, it shows information of the object that is in the Document area. R= Status bar.

12. - It shows the Backstage view, with the options that will permit to handle the file, such as New, Ope, Save, Save as, Recent, Print, Help and Exit. R= File Menu.

13. - The object that is in the Document area with tabs can be shown in four different ways: Datasheet view, Pivot Table view, Picot Chart view and Design view. When you start a new database, Access activates only two news, when creating the table the others two will be activated. R= View buttons

14. - It is the area where we can personalize the most used command buttons in Access, you just click once in the Customize Quick Access Toolbar button. R= Quick Access toolbar.

15. - It is composed by different tabs, that contain groups and they contain command buttons that are used to create or deseing the database in Access. R= Ribbon.

     [pic 3]

16. - In this section it is visualized that different objects of the data base that are being manipulated: Tables, Queries, Forms, Reports, Macros or Modules. R=Navigation pane

17:- It is the area where you can visualized tha object of the database that you are going to work, in the upper part appears the name of the document that is active in that moment, you can have man opened objects at the same time. R= Documents area

18.- With these buttons you can navigate inside the database ond visualize each one of the records, you can advance or turn back one to one or you can move to the first record or last record immediately. R= Navegation buttons

[pic 4]

19. - Is it a structure composed by rows and columns that integrates a collection of data?

R= A table

20. – Is a file that integrates a collection of information of the same type in a style of tables, reports, queries and forms R= Database.

21.-  It is the name each one of the columns that integrates a table, depending on the content of the column is the name assigned. R= Field name

22. – Is all information related to an element of the database; it is each one of the rows that composes the table R= Record

23.- It is each one the particular data of a record. The amount of fields of a database depends on the size of the record. R= Field

...