home / study / engineering / computer science / questions and answers / 1- the q

ID: 3674219 • Letter: H

Question

home / study / engineering / computer science / questions and answers / 1- the query wizard is limited to only including ...

Question

Edit question

1- The query wizard is limited to only including fields from one single table, if you wish to add fields from other tables you must add those manually in the query designer.

True

False

2-The form wizard is limited to only including fields from one single table, if you wish to add fields from other tables you must add those manually in the form designer.

True

False

3-The report wizard is limited to only including fields from one single table, if you wish to add fields from other tables you must add those manually in the report designer.

True

False

Explanation / Answer

1- False

Explanation:

A query does not store data, it displays data that is stored in tables. A query can show data from one or more tables, from other queries, or from a combination of the two.You can create a select query by using the Query Wizard or by working in Design view. Some design elements are not available when you use the wizard, but you can add these elements later by using Design view. Although the two methods are somewhat different from each other, the basic steps are essentially the same:

i) Choose the tables or queries that you want to use as sources of data.

ii) Specify the fields that you want to include from the data sources.

iii) Optionally, specify criteria to limit the records that the query returns.

When you add the data sources, if the sources already have relationships defined between them, those relationships are automatically added to the query as joins. Joins specify how data from related sources should be combined. Access also automatically creates a join between two tables if they have fields have compatible data types and one field is a primary key.

2- True

Explanation:

Access makes it easy to create a form from any table in your database. Any form you create from a table will let you view the data that's already in that table and add new data. Once you have created a form, you can modify it by adding additional fields and design controls like combo boxes.If you created a form from a table whose records are linked to another table, your form probably includes a subform. A subform is a datasheet form that displays linked records in a table-like format.

When you use the Form command on an existing table, all of the fields from the table are included in the form. However, if you later add additional fields to the table, these fields will not automatically show up in existing forms. In situations like this, you can additional fields to a form.

Add a field to a form from other table:

i) Select the Design tab, then locate the Tools group on the right side of the Ribbon.

ii) Click the Add Existing Fields command.

iii) The Field List pane will appear. Double-click the desired field(s).

iv) The field will be added

3- True

Explanation:

Microsoft Access Report Wizard is more like traditional office wizard: It displays a series of dailog boxes that take you step by step through the entire report creation process.Access Report contains three types of controls- Bound, Unbound and Calculated.

Bound controls are used to display data from the reports underlying data sources, the term bound refers to the fact that the control is tied to a feild of the table.Because report data is not editable, most bound boxes are text boxes. The bound control inherits many of the formating and text properties defined for the feild to which it is bound(ex: decimal places and format). you can change this properties on the report by using the controls property sheet.

Adding the Feilds to the Report from other table:

i) Choose Design, Add Existing Feilds. Access displays the Feild List Pane

ii) You can view the related table by clicking Show All Tables Link at the bottom of the Feild List Pane

iii) Double click the feild you want to add to the Report