AIS Chapter 9: Database Forms and Reports

the 2 steps in creating reports with calculated fields

1. create the query with a calculated field 2. create report based on query

A subform is:

A subordinate form within a form

the 2 steps to creating simple forms

1. refine your design 2. reset the tab order

if the form onscreen appears with grid lines and you can view the Toolbox, this form is mostly likely in: a. design mode b. run mode c. sleep mode d. wizard mode

a

what happen when you click on this symbol >| on a form's navigation bar? a. you will transition from run mode to design mode b. you will transition form design mode to run mode c. you will go to the first record in the table d. you will go to the last record in the table

d

Form controls

prevent confusing variations of a form

Reports enable users to:

see a paper output of database information

property sheet window

allows you to change properties of forms

in access, you can use a form to perform all the following tasks of?

creating a new record in a specific table change the info an existing record of a table view the info form many diff records sequentially

Form

custom-designed screed for entering records or displaying existing records

in access, you can use a form to perform all the following tasks except: a. create a new record in a specific table b. change the info in an existing record of a table c. view the info from many different records sequentially d. all of these are tasks that can be performed with an access form

d

sizing handles

dots on form used for resizing

the term control break mostly closely associates with which of the following terms in access?

groups of data

Forms are not capable of which of the following?

preventing all entry errors

calculated fields

the calculated total of numerical fields

control break

the technical term for the point at which a group changes from one type to the next

the 7 major components in a report

1. heading 2. page heading 3. group heading 4. detail/body 5. group footer 6. page footer 7. report footer

the 2 modes of forms

1. run 2. design 3. redefine your design 4. Reset tab order

Control source property

links the control to an underlying field

which of these is NOT a typical part of a printed report using access?

navigation bar

each record in a database table of student records contains the name, address, total university credits, and total quality points for specific students. the students GPA is equal to the total quality points divided by total university credits. where would a database typically store a students GPA info?

nowhere, this is a calculated field that is typically created by a query at run time

what are reports strictly

outputs!

3 Advantages of forms

1. avoid accidental replacement of data 2. all data entry text boxes on one screen 3. can be customized

the steps in customizing simple forms

1. enter the appropriate settings in the from wizard dialog boxes 2. Customized the form

a form control that doesn't change from record to record is probably:

an unbound control

Suppose an employee's date of hire is changed in an employee table. When a database user subsequently runs a report showing the number of years the employee has worked for the company (a calculated field), what will happen?

The new report will show a new calculated value

resetting the tab order

create a customer order for the objects

each record in a database table of student records contains the name, address, total university credits, and total quality points for specific student. the students's GPA is equal to total quality points divided by total university credits. where would a database typical store a student' GPA information? a. in the same table as the student's other information b. in a new table of student details c. in a report stored in the reports section of the database d. nowhere; this is a calculated field that is typically created by a query at run time

d

Assume that salespeople at your firm make many errors when inputting sales data to the firm's Access database. Your manager has asked you to find a way to reduce data input errors. A good approach for reducing data entry errors would be to create a:

form

Assume that your manager has asked you to improve the efficiency and effectiveness of data entry for sales invoices by adding capabilities to the firm's Access database. In order to allow data entry for each invoice and multiple items on each invoice, you should create a:

form with a subform

the database of a vet clinic has records for the pets it treats in one table, records for pet owners in another, and records for employees in a third table. which of these is most likely to describe a database form and subform for this application?

owners in the main form and pets in the sub form

Reports

provide custom info to database users

reports

provide custom info to database users and can be simple documents or complex outputs

bound controls

text boxes, drop down boxes, have a limited selections

Which of these is an advantage of a subform?

the ability to display subordinate info AND the ability to be used in the same manner as regular forms

refining your design

toggle between run mode and design mode and continue to adjust the design as needed

what appends when you click on this symbol >| on a form's navigation bar?

you will go to the last record in the table

unbound controls

have unlimited selections

steps in creating reports with grouped data

1. create underlying query 2. use report wizard to create initial report 3. reformate report as seedier

5 ways to customize forms

1. form controls 2. bound controls 3. unbound controls 4. property sheet window 5. control source property

3 major sections of form

1. heading section 2. detail section 3. navigation bar

the 6 steps to creating a simple report

1. launch report wizard 2. select the underlying data source and desired fields 3. indicate any grouping levels 4. indicate any sort fields and select the desired report 5. name the report 6. modify the design of the report as desired

Steps in creating a simple report

1. launch report wizard 2. select underlying data sources and desired fields 3. indicate any grouping levels 4. indicate any sort fields and select desired report format 5. name report 6. modify design report as desired

why using a form is better than data sheet screen

1. only displays on record at once reducing errors 2. can display all the data-entry text boxed for entire record in one screen 3. you can customize them

the 2 method to creating subforms

1. when using the form wizard 2. after the creation of the the main form

Which of the following cannot be defined when using the Report Wizard in Microsoft Access?

all of these can be defined by the Report Wizard (data source selection, grouping, sorting, format design)

Which of the following is not an advantage of form data entry over datasheet data entry?

The forms are customizable by end users at run time

Manual forms, in terms of database form design, are:

Used to guide the development of electronic forms

the term "control bread" most closely associates with which of the following terms in access? a. groups of data b. bathroom break c. form control d. report header

a

Subform

a form within a form that displays data related to info in the main form

subforms

a form within a form that displays data related to the info on main form

which of these best identifies the underlying data source for an access report?

both tables and queries

a form control that does not change form record to record is probably; a. a design time control b. a bound control c. an unbound control d. a mistake

c

the database of a vet clinic has records for the pets it treats in one table, records for pet owners in another table, and records for employees in a third table. which of these is most likely to describe a database form a subform for this application? a. employees in the main form and pets in the subform b. pets in the main form and owners in the subform c. owners in the main form and pets in the subform d. owners in the main form and employees in the subform

c

which of these best identifies the underlying data source for an access report? a. only tables b. only queries c. both tables and queries d. tables, queries, and forms

c

which of these is not typical party of a printed report using access? a. report header b. report footer c. navigation bar d. detail line

c

if the form onscreen appears with grid lines and you can view the toolbox, this form is mostly likely in

design mode