Studied by 0 people
Over Microsoft Access, and database concepts
database objects
tables, queries, forms, reports
one
Only ____ database can be open at a time
automatically
changes are saved _______ when moving to a new record, closing a table, closing database
true
Security warnings appear in the message bar when files are copied from another medium
Navigation Pane
lists all the names of every database object in open database grouped by categories
Status bar
displays messages, current view, view buttons
work area
displays opened objects
50
“Recent” in backstage shows how many of recently opened databases?
Hard drive
If uploading from OneDrive it must be saved to _____ when edited
CTRL + F4
close objects
Table
Organizes data in fields/records; base for other objects
True
Database must have at least one table
Reports
Prints data from tables/queries
Datasheet view
Tables open in
pencil icon
editing; not saved
false
changes to database layout are saved automatically
13.11
Field Column default width
true
by default Access prints a table on letter size paper in portrait with 1 inch margins
Join Lines
show links/relationships between tables
relational database
has related tables to reduce redundant data
short text
alphanumeric; up to 255 characters
unique names and no spaces
Fields must have
True
Field names cannot have _ or #
Caption
What users see
open the report in design view
Which of the following steps should be performed first when moving control objects to another section?
5
A report can contain up to _____ sections, not including Group Header and Group Footer.
table or query to use to create the chart
At the first Chart Wizard dialog box, what information are you asked to provide?
all reports and forms in the database
Changing a theme for one report automatically changes the theme for
subreport
stored as a separate object outside main report
design or layout view
If a report was not grouped when using the Report Wizard, group records can be added after the report is generated using which of the following?
move the chart
In chart-editing mode, you can do all of the following except
Header/Footer
The Page Numbers button is in the _____ group on the Report Design Tools Design tab.
main
The report into which a subreport is inserted is called the _____ report.
name
To use a calculated control object as a field in another formula, reference the calculated object in the formula by its _____ property.
It ensures that a section does not split over two pages because of a page break.
What does the Keep Together property do?
same tools for forms
What tools and techniques are available to add graphics to Access reports?
one object for the date format and another object for the time format.
When both the date and the time are added to a report from the Date and Time dialog box, Access creates
connect table or query
When building a report in Design view, what must you do before adding fields to the Detail section?
count values
Which of the following functions can be used in a report grouping either numeric or non-numeric fields?
median
Which of the following functions cannot be added to a group in a report?
repeating values
you can group
Record Source
designates connected table or query
Note 
Flashcard (41)