Base De Datos
Páginas: 2 (290 palabras)
Publicado: 30 de mayo de 2012
Activity 4.5
a) What is the purpose to set relations among the tables of a database?
To make a database with filters where you select what you want to appear.b) What is the meaning of the number one, which is displayed in each field of the tables where there are set relations?
One-on-one relation direction.
c)What must you define in the first window that appears when you use the Report Wizard?
You will select the fields from each table.
d) Mention 5 styles that youcan apply you can apply to the report
Access 2003, Aspect, Brío, Flujo, Mirador.
e) In what kind of view can you apply to the report?
Design View
f) Whatare to do a new query through the Query Wizard?
* Simple Query Wizard
* Crosstab Query Wizard
* Find Duplicates Query Wizard
* Find Unmatched QueryWizard
g) What is the option that permits to design a query?
Asistente para consultas, Diseño de consultas, Macros.
h) According to the information containedin the database Medical Clinic, mention one example of a report and one query useful for the doctor.
Types of Blood and Family diseases
i) What is theadvantage to design a form?
To manipulate information in a database.
j) What is the view that permits you to design the form and establish its own characteristics?Design View
k) Do you consider that is easiest that you design a form, a query or a report, or is it better through the wizard
Through a wizard
l) Whathappen in case that you want to elaborate a report using fields of different tables which do not have primary key?
You to add a primary key to the table you want to add.
a) What is the purpose to set relations among the tables of a database?
To make a database with filters where you select what you want to appear.b) What is the meaning of the number one, which is displayed in each field of the tables where there are set relations?
One-on-one relation direction.
c)What must you define in the first window that appears when you use the Report Wizard?
You will select the fields from each table.
d) Mention 5 styles that youcan apply you can apply to the report
Access 2003, Aspect, Brío, Flujo, Mirador.
e) In what kind of view can you apply to the report?
Design View
f) Whatare to do a new query through the Query Wizard?
* Simple Query Wizard
* Crosstab Query Wizard
* Find Duplicates Query Wizard
* Find Unmatched QueryWizard
g) What is the option that permits to design a query?
Asistente para consultas, Diseño de consultas, Macros.
h) According to the information containedin the database Medical Clinic, mention one example of a report and one query useful for the doctor.
Types of Blood and Family diseases
i) What is theadvantage to design a form?
To manipulate information in a database.
j) What is the view that permits you to design the form and establish its own characteristics?Design View
k) Do you consider that is easiest that you design a form, a query or a report, or is it better through the wizard
Through a wizard
l) Whathappen in case that you want to elaborate a report using fields of different tables which do not have primary key?
You to add a primary key to the table you want to add.
Leer documento completo
Regístrate para leer el documento completo.