|
Access Chapter 4 & 5 Creating Reports and Forms, SQL
Know: Relational Database, Primary Key, Foreign Key, One-to-Many, One-To-One, Referential Integrity, .ldb extension (Access 203) and .laccdb extension (Access 2007)
1.
To use the Report Wizard to create a report for a table, select the
table for the report in the Navigation Pane, click the Create tab, and then
click the _____ button.
2.
_____ shows the report on the screen but also allows you to make
changes to the report.
3.
_____ are not associated with data from the database and are
used to display such things as the report’s title.
4.
To add totals or other statistics to a report, use the _____
button on the Format tab.
5.
To resize a column, point to the boundary of the column so that
the mouse pointer becomes a _____ arrow.
6.
You use the _____ button in the Report Wizard dialog box to
specify subtotals or other calculations within the wizard.
7.
To delete a field from a report, click the field and then press
the _____ key(s).
8.
To use the Form Wizard to create a form for a table, select the
table for the form in the Navigation Pane, click the Create tab, and then
click the _____ button.
9.
The _____ section appears at the top of the form and usually
contains the form title.
10. The body
of the form is in the _____ section.
11. The _____
section appears at the bottom of the form and often is empty.
12. _____
shows the form on the screen and allows you to use the form to update data.
13. _____
allows you to make changes to the form layout and object alignment, but it
does not allow you to enter data.
14.
The _____ command on the Advanced menu allows you to sort
records and enter criteria to restrict retrieval.
15.
The _____
data type is used for a field that contains text that is variable in length
and that can potentially be very lengthy.
16.
To insert
data into an Attachment field, use the _____ on the Attachment’s field’s
shortcut menu.
17.
A form
that is contained with another form is called a(n) _____.
18.
To ensure
that a collection of controls is aligned properly with each other, select all
of the affected controls, and then use the appropriate alignment button on
the _____ tab.
19.
To switch
from Design view to Form view to display the form, click the _____ button.
20.
Enter
_____, in the Criteria row of a memo field on a query window would retrieve
all records where the memo field had any mention of Healthcare.
21.
To begin
creating a new SQL query, click the _____ button on the Create tab.
22.
To see
the SQL code for a query after viewing the results of a query, click the View
button arrow and then click _____ on the View button menu.
23.
To include
all fields in a SQL query, use the _____ symbol after the word SELECT.
24. In SQL, to select only certain fields from a table, use the key word 25. In SQL, to find records that meet specific criteria, use the key word 26.
In SQL,
to create and name a computed field, use the key word
27.
In SQL,
to create and name a computed field, use the key word
28.
To sort
the output of a SQL query, use the key word
29. When opened, the rows of a table correspond to 30. The columns of a table correspond to 31. An Access table contains 32. In which of the following objects does Access store data? 33. Which of the following is used to search or answer a question about a database? 34. To move to the last field in the last record in table datasheet view you would press 35. A report may be based on a 36. A record can be added to an Access table by using a … 37. A well-designed table will 38. Which of the following should be defined as a text field? 39. Which of the following may be included on an Access Report? 40. Each of the following is an example of a valid Access data type except 41. A control that is linked to a data source in the underlying table is called a(n) 42. When tables are linked by key fields it is called a 43. In which view would you most likely be if you are using the Text Box tool? 44. Which section is used to build the main body of a report? 45. Which of the following is used to add the current date to a report each time it is printed? 46. Which of the following would be returned if you type F* in a text field of a select query? 47. Which row in the Design grid determines which records will be selected in a query? 48. Mail merge must involve… 49. Access Queries are written in which language? 50. What would cause #Name? to be displayed on an Access form?
|
|
Office-Exam3 Access and PowerPoint Review Sheet Access Terms: Know all the tools on the Access Toolbar. Text Box, Label, Command Button, Option Group, Relationships, Combo boxes, Check boxes, Filter tool… |
|
|
ASCII |
Macros |
|
Autoexec macro |
Mail merge |
|
Autonumber |
memo field |
|
Bound controls |
Now( ) |
|
Calculated control |
Number field |
|
calculated field |
OLE field |
|
Columns, |
Page Footer |
|
Criteria |
Page Header |
|
Ctrl End |
Parameter |
|
Datasheet view |
Query |
|
Date/Time Field |
Query Calculations |
|
Default value |
Records |
|
Detail |
relational database |
|
End |
Report Footer |
|
ESC |
Report Header |
|
Field size |
Reports |
|
Field types |
Rows |
|
Fields |
SQL Select From As Order By Where |
|
Files |
Startup property |
|
Format |
Tables |
|
Hyperlink |
text field |
|
Input mask |
Unbound control |
|
Lookup Wizard |
VBA |
|
Macros |
Wildcard * |
|
|
|
|
POWERPOINT Terms also Know the PowerPoint Tool Icons |
|
|
. bmp |
Linking |
|
. jpg |
Pack and Go |
|
.gif |
page numbers |
|
.wav |
PageUp |
|
Animation |
Password Protection |
|
Background |
print outlines, handouts |
|
Embedding |
Slide Master |
|
Esc |
slide transitions |
|
F5 |
Spell check |
|
Fast Saves |
Timing |
|
Hyperlinks |
Web Page |
|
|
|