isbc quick check
what is the detail report? a summary report?
. A detail report displays fields from the record source in the Detail section. A summary report displays only summary information, such as grand totals and subtotals.
The default Field Size property setting for a Short Text field is .
255
What is the function and syntax to print the current date in a report?
=Date()
what is a CSV file?
A CSV file is a text file in which commas separate values, and each line is a record containing the same number of values in the same positions.
A ________ is a set of restrictions you place on the records in an open data sheet or form to isolate a subset of records temporarily.
A Filter
What is a PDF file?
A PDF file is encoded in portable document format.This file format preserves the original formatting and pagination of its contents no matter where it's viewed.
What is the difference between a bound control and an unbound control?
A bound control is connected to a field in the database; an unbound control is not
What is a bound form, and when do you use bound forms?
A bound form has a table or query as its record source, and is used to maintain and display table data.
A(n) is a criterion, or rule, that determines which records are selected for a query datasheet.
A condition
what is the focus?
A control is said to have focus when it is active and awaiting user action.
what is a custom report?
A custom report is a report created by the Report tool or the Report Wizard that you modify in Layout view or Design view, or a report you create from scratch in Layout view or Design view.
What is a split form?
A form that displays a form's data in Form view and Datasheet view at the same time; the views are synchronized with each other at all times.
What is the Multiple Items tool?
A form tool that creates a customizable form that displays multiple records from a source table or query in a datasheet format.
what is a grouping field?
A grouping field is a report sort field that includes a Group Header section before a group of records having the same sort field value and a Group Footer section after the group of records.
What is a multiple-column report?
A multiple-column report prints the same collection of data in two or more sets across the page.
List three reasons why you should specify a primary key for an Access table.
A primary key uniquely identifies each record in the table; a primary key prevents duplicate values from being entered in the same field; Access forces you to enter a value for the primary key field in every record in the table; records will always be displayed in a meanginful order by primary key, regardless of the order in which you entered them; Access responds faster to requests for specific records based on the primary key.
What is the Microsoft Graph program?
A program that allows you to create and change charts in a form or report
Define the Validation Rule property, and give an example of when you would use it.
A property that specifies text that appears in a dialog box if auser violates a field's validation rule. You could display the message "Must be a positive integer" if the user enters a value less than or equal to zero.
What is property propagation?
A property that specifies the valid values that users can enter in a field. You could use this property to specify that users can enter only positive numeric values in a numeric field.
What is a find duplicates query?
A query that finds duplicate records in a table or query based on the values in one or more fields.
What is a select query?
A select query is a general query in which you specify the fields and records you want to select.
What is a static webpage?
A static webpage shows the state of the database at the time the page was created; any subsequent changes made to the database object, such as updates to field values in records, are not reflected in a static webpage.
How are a table datasheet and a query datasheet similar? How are they different?
A table datasheet and a query datasheet look the same, appearing in Datasheet view, and can be used to update data in a database. A table datasheet shows the permanent data in a table, whereas a query datasheet is temporary and its contents are based on the criteria you establish in the design grid.
What is a theme, and how do you apply one to an existing form?
A theme is a predefined set of formats including colors, fonts, and other effects that enhance a form's appearance and usability. To apply a theme to a form, display the form in Layout view, click the Themes button in the Themes group on the Design tab, and then click a theme in the gallery to apply it to all objects or right-click the theme and choose to apply it to the current object only.
A ____ folder is a location where you can place databases that you know are safe.
A trusted
What happens if you set a query's Top Values property to 2, and the first five records have the same value for the primary sort field?
Access displays the first five records.
Explain how the saving process in Access is different from saving in other Office programs.
Access saves changes to the active database automatically, when a record is changed or added or when you close the database. You use the Save button in Access only to save changes to the design of an object, such as a table, or to the format of a datasheet—but not to save the database file.
Which group on the Fields tab contains the options you use to add new fields to a table?
Add and delete
What is the Documenter?
An Access tool that creates detailed documentation of selected objects in a database.
what is an HTML template?
An HTML template is a file that contains HTML instructions for creating a webpage with both text and graphics, together with special instructions that tell Access where to place the Access data in the page.
What is the difference between an application part and a template?
An application part can be inserted into the current database and a template is used to create a new database.
What is an application part?
An application part is a specialized template that appears in the User Templates menu in the Application Parts section and can be inserted into the current database.
How do you move a selected field value box and its label at the same time?
Click the field value box to select it, position the pointer anywhere on the border of the field value box (but not on a move or sizing handle), and then drag the field value box and its attached label.
What rearranges the data and objects in a database to decrease its file size and enhance the speed and performance of the database?
Compacting a database
What is the keyboard shortcut for inserting the value from the same field in the previous record into the current record?
Ctrl + '
How do you insert a page number in the Page Header section?
Display the report in Layout view or Design view; click the Page Numbers button in the Header/Footer group on the Design tab; specify the format, position, and alignment of the page number; and then click the OK button.
In Design view, which key do you press to move from the Table Design grid to the Field Properties pane?
F6
Which object(s) should you use to perform all database updates?
Forms
The _____ operator divides selected records into groups based on the values in a field.
Group by
In a _____ report, the data from a record in the primary table appears together, followed on subsequent lines by the joined records from the related table.
Grouped
What is HTML?
HTML is the language used to create most webpages.
What command can you use in Datasheet view to remove the display of one or more fields from the datasheet?
Hide Fields
What is the name of the field that Access creates, by default, as the primary key field for a new table in Datasheet view?
ID
The function returns one of two values based on whether the condition being tested is true or false.
IIf (or Immediate If)
In the Navigation Pane, each database object has a unique _________ to its left that identifies the object's type.
Icon
What guidelines should you follow when designing a database?
Identify all the fields needed to produce there aquirred information, organize each piece of data into its smallest useful part, group related fields into tables, determine each table's primary key, include a common field in related tables, avoid data redundancy, and determine the properties of each field.
Identify three types of modifications you can make to a report in Layout view.
In Layout view for a report, you can apply a theme to the report, change the alignment of field values, move fields, resize fields, change the font color of text in the report, and insert a picture in the report.
In Datasheet view, what is the difference between navigation mode and editing mode?
Innavigationmode,theentirefieldvalueisselectedandanythingyoutype replaces the field value; in editing mode, you can insert or delete characters in a field value based on the location of the insertion point
What does a find unmatched query do?
It finds all records in a table or query that have no related records in a second table or query.
What is the purpose of a crosstab query?
It performs aggregate function calculations on the values of one database field and displays the results in a spreadsheet format.
Which comparison operator selects records based on a specific pattern?
Like
The property lets you change the default navigation label from the word "Record" to another value.
Navigation Caption
The _______ is the area of the Access window that lists all the objects in a database, and it is the main control center for opening and working with database objects.
Navigation pane
Must the page number reside only in the Page Header section?
No. You may place the page number anywhere in the report you wish.
According to the naming conventions used in this session, you use the ______ prefix tag to identify queries.
Qry
Setting a Long Text field's Text Format property to _____ lets you format its contents.
Rich text
The ____ property specifies the data source for a control in a form or report or for a field in a table or query.
Row source
How do you resize a control?
Select the control, position the pointer on a sizing handle, and then drag the pointer in the appropriate direction until it is the desired size.
What are the four query wizards you can use to create a new query?
Simple Query Wizard, Crosstab Query Wizard, Find Duplicates Query Wizard, Find Unmatched Query Wizard
What is the purpose of the Data Type property for a field?
The Data Type property determines what field values you can enter into the field and what other properties the field will have.
What is the purpose of the Form Header section?
The Form Header section lets you add titles, instructions, command buttons, and other controls to the top of a form. This section of the form does not change as you navigate through the records.
a function that performs an arithmetic operation on selected records in a database
The Form tool creates a form automatically using all the fields in the selected table or query; the Form Wizard allows you to choose some or all of the fields in the selected table or query, choose fields from other tables and queries, and display fields in any order on the form.
list and describe the seven sections of an access report.
The Report Header section appears once at the beginning of a report. The Page Header section appears at the top of each page of a report
Explain the difference between the Tab Stop property and tab order.
The Tab Stop property specifies whether users can use the Tab key to move to a control on a form. Tab order is the order in which you move from control to control, or change the focus, in a form when you press the Tab key.
what is the table analyzer?
The Table Analyzer is an Access tool that analyzes a single table and, if necessary, splits it into two or more tables that are in third normal form.
Describe the field list and the design grid in the Query window in Design view.
The field list contains the table name at the top of the list and the table's fields listed in the order in which they appear in the table; the design grid displays columns that contain specifications about each field you will use in the query.
the quickest way to create a form is to use the what?
The form tool
What is the default category for the display of objects in the Navigation Pane?
The object type
When you define multiple sort fields in Design view, describe how the sort fields must be positioned in the design grid.
The sort fields must be arranged from left to right in the design grid, with the primary sort field being the leftmost of the sort fields.
How do you negate a selection criterion?
Use the Not logical operator to negate a condition.
How do you change a label's caption?
With the label selected, open the Property Sheet, click the Format tab or the All tab, and then change the entry in the Caption box.
________ is a programming language that describes data and its structure.
XML (Extensible Markup Language)
can a report be a modified in layout view
Yes. Modifying a report in Layout view is similar to modifying a form in Design view. When you open a report in Layout view, the Report Layout Tools Design, Arrange, Format, and Page Setup contextual tabs appear on the ribbon. You use the commands on these tabs to modify and format the elements of the report.
Besides viewing a report, what other actions can you perform in Report view?
You can apply a filter and you can copy selected portions of the report to the Clipboard.
How can you edit data in a table that has been linked to an Excel file?
You can make the change in Excel and the change will automatically update in Access
What happens when you set a query's Top Values property?
You limit the number of records displayed in the query results.
Describe the process for moving a control to another location on a report in Layout view.
YoucanselectoneormorecontrolsonareportinLayoutview,andthendrag them to a new location; or, for more precise control over the move, you can use the arrow keyboard keys to move selected controls.
What is a lookup field?
a field that lets you select from a list of possible values
What is an aggregate function?
a function that performs an arithmetic operation on selected records in a database
what is a question you ask about the data stored in a database?
a query
What is the purpose of the asterisk (*) in a pattern match query
a wildcard that represents any string of characters in a pattern match query
As the screen's size and resolution change, the ____ property for a control automatically resizes the control.
anchor
the term for a database is the process of making a copy of the database file to protect the database against loss or damage.
backing up
The ______ property, when set to Yes, expands a field value box vertically to fit the field value when a report is printed, previewed, or viewed in Layout and Report views.
can grow
The ______ property specifies how a field's name is displayed in database objects, including table and query data sheets, forms, and reports.
caption
A(n) _____ control provides the features of a text box and a list box.
combo box
You connect the records in two separate tables through a _____ that appears in both tables.
common field
in a report (or form) ______ is special formatting applied to certain field values depending on one or more conditions.
conditional formatting
A _______ is an item on a form, report, or other database object that you can manipulate to modify the object's appearance.
control
The ______ gallery allows you to add a group of related fields to a table at the same time, rather than adding each field to the table individually.
data type
A(n) ______ text file is one in which fields of data are separated by a character such as a comma or a tab.
delimited
When you create a report based on two tables that are joined in a one-to-many relationship, the field values for the records from the related table are called the records
detail
To perform a calculation in a query, you define a(n) containing a combination of database fields, constants, and operators.
expression
what is a single characteristic of a person, place, object, event, or idea?
field
The Control Source property setting can be either a(n) _____ or a(n) _______
field name, expression
Why might you want to hide duplicate values in a report?
hiding duplicate values a report easier to read; duplicate values clutter the report
_______ data is a process that allows you to copy the data from a source without having to open the source file.
importing
In the design grid, where do you place the conditions for two different fields when you use the And logical operator, and where do you place them when you use the Or logical operator?
in the same criteria row; in different criteria rows
A _____ is a predefined format you use to enter and display data in a field.
input mask
The ______ property prints a group header on a page only if there is enough room on the page to print the first detail record for the group; otherwise, the group header prints at the top of the next page.
keep together
The larger handle in a selected object's upper-left corner is the _______ handle.
move
For a Date/Time field, how do the records appear when sorted in ascending order?
oldest to most recent date
A(n) section appears by itself at the top of a page, and the detail lines for the section appear on the previous page.
orphaned footer
The ______ whose values uniquely identify each record in a table, is called a ______ when it is placed in a second table to form a relationship between the two tables.
primary key; foreign key
The ________ is the "one" table in a one-to-many relationship, and the is the "many" table in the relationship.
primary table; related table
_______ is a set of rules that Access enforces to maintain consistency between related tables when you update data in a database.
referential integrity
Clicking the Title button in the Header/Footer group on the Report Design Tools Design tab adds a report title to the ______ section.
report header
To print only the current record displayed in a form, you need to select the ______ option button in the Print dialog box.
selected record
For which three types of fields can you assign a field size?
short text , number, and outnumber
The ______ property has settings such as Raised and Sunken.
special effect
To copy the records from a table in one database to another table in a different database, the two tables must have the same
structure
You use the _____ tool to add a subform to a form
subform/subreport
To calculate subtotals and overall totals in a form or report, you use the _______ function
sum
To create a combo box to find records in a form with the Combo Box Wizard, the form's record source must be a(n)
table or query
Which Access tool do you use to create an expression for a calculated field in a query?
the expression builder
What is the effect of deleting a field from a table structure?
the field and all its values are removed from the table
The ______ consists of the dotted and solid lines that appear in the Header, Detail, and Footer sections in Design view to help you position controls precisely in a form.
the grid
Which table record is displayed in a form when you press the Ctrl+End keys while you are in navigation mode?
the last record in the table
In a form that contains a main form and a subform, what data is displayed in the main form and what data is displayed in the subform?
the main form displays from the primary table and the subform displays the date from the related table
Which view enables you to see the total number of pages in a report and navigate through the report pages?
the print preview
Which wildcard character matches any single alphabetic character?
the question mark ( ?? )
What does a pencil symbol at the beginning of a record represent? What does a star symbol represent?
the record being edited; the next row available for a new record
When working in Layout view for a report, which key do you press and hold down so that you can click to select multiple controls (field labels, field value boxes, and so on)?
the shift key
When do you use the In comparison operator?
to define a condition with 2 or more values
When do you use a parameter query?
when you want to prompt the user to enter one or more selection criteria when the query runs
