Access Final Review
Help!
|
|
||||
|---|---|---|---|---|---|
| Can Grow property | show 🗑
|
||||
| Date function | show 🗑
|
||||
| show | A report that displays fields in the Detail section for every record from the record source.
🗑
|
||||
| custom report | show 🗑
|
||||
| show | A pane in Layout and Design views for a report in which you can modify the report's grouping fields and sort fields, and the report calculations for the groups.
🗑
|
||||
| show | A report section that appears after each group of records that has the same sort field value, and that usually displays subtotals or counts for the records in that group.
🗑
|
||||
| show | A report section that appears before each group of records that has the same sort field value, and that usually displays the group name and the sort field value for the group.
🗑
|
||||
| show | A report sort field that includes a Group Header section before a group of records that has the same sort field value and that includes a Group Footer section after the group of records.
🗑
|
||||
| show | A property you use to hide a control in a report when the control's value is the same as that of the preceding record.
🗑
|
||||
| Keep Together property | show 🗑
|
||||
| show | An Access tool that asks you a series of questions, and then creates a mailing label report based on your answers.
🗑
|
||||
| multiple-column report | show 🗑
|
||||
| newspaper-style column | show 🗑
|
||||
| show | A report footer section that appears by itself at the top of a page; the detail lines for the section appear on the previous page.
🗑
|
||||
| orphaned header section | show 🗑
|
||||
| Page Footer section | show 🗑
|
||||
| Page Header section | show 🗑
|
||||
| Report Footer section | show 🗑
|
||||
| Report Header section | show 🗑
|
||||
| Report view | show 🗑
|
||||
| show | A report that displays no detailed information; only grand totals and possibly subtotals are displayed based on calculations using fields from the record source.
🗑
|
||||
| show | An instruction to Access to perform an operation.
🗑
|
||||
| show | A toggle to open and close the Action Catalog pane, which lists all actions by category and all macros in a database.
🗑
|
||||
| argument | show 🗑
|
||||
| show | A button used to clear the search box and display all actions and objects in the Action Catalog pane.
🗑
|
||||
| command button | show 🗑
|
||||
| comment | show 🗑
|
||||
| Data Mode argument | show 🗑
|
||||
| event | show 🗑
|
||||
| event procedure | show 🗑
|
||||
| show | The property that specifies how an object responds when an event occurs.
🗑
|
||||
| FindRecord action | show 🗑
|
||||
| Left function | show 🗑
|
||||
| list box | show 🗑
|
||||
| load event | show 🗑
|
||||
| show | An recorded action, or a set of actions, that you want Access to perform automatically for you.
🗑
|
||||
| show | The name of the Build button when you use it to work with macros.
🗑
|
||||
| show | A development environment built into Access that allows you create and modify macros.
🗑
|
||||
| show | A dialog box that contains a message and a command button, but no options. The message box remains on the screen until the user clicks the OK button.
🗑
|
||||
| show | A system table that keeps track of the names, types, and other characteristics of every object in an Access database.
🗑
|
||||
| navigation form | show 🗑
|
||||
| show | a macro action that opens a specified form in a specified view.
🗑
|
||||
| show | A property for a command button that specifies how a command button's Caption property value is arranged in relation to the picture placed on the command button. The choices are No Picture Caption, General, Top, Bottom, Left, and Right.
🗑
|
||||
| show | An action argument that prints the selected form record
🗑
|
||||
| procedure | show 🗑
|
||||
| Row Source property | show 🗑
|
||||
| show | An action that selects and runs a command on the Ribbon.
🗑
|
||||
| show | Allows you to enter a filter term to limit the actions and objects displayed in the Action Catalog pane.
🗑
|
||||
| show | An action that selects a specified object so that you can run an action that applies to the object
🗑
|
||||
| show | An SQL statement used to retrieve and present data from a database.
🗑
|
||||
| single step | show 🗑
|
||||
| SQL | show 🗑
|
||||
| show | A complete macro with a Submacro header within a macro. Using submacros allows you to consolidate related macros and to manage large numbers of macros.
🗑
|
||||
| system tables | show 🗑
|
||||
| user interface | show 🗑
|
||||
| show | An action argument that specifies the window view (for example, Datasheet, Design, Form, and Print Preview views) in which to open an object.
🗑
|
||||
| Table Name Argument | show 🗑
|
||||
| show | An event that occurs after changed data in a control or a record is updated.
🗑
|
||||
| show | A value passed to a VBA function and used in place of a parameter when the function is executed.
🗑
|
||||
| show | An event that occurs before changed data in a control or a record is updated in the database.
🗑
|
||||
| Case control structure | show 🗑
|
||||
| show | A VBA statement that designates the start of an alternative set of actions for the Case control structure.
🗑
|
||||
| class module | show 🗑
|
||||
| show | The window in which you create, modify, and display VBA procedures.
🗑
|
||||
| show | The process of writing instructions in a programming language such as VBA.
🗑
|
||||
| show | The process of translating modules from VBA to a translated form that a computer can understand.
🗑
|
||||
| compile | show 🗑
|
||||
| Conditional control structure | show 🗑
|
||||
| control structure | show 🗑
|
||||
| Current event | show 🗑
|
||||
| show | Testing the VBA code you create.
🗑
|
||||
| show | The VBA statements at the beginning of a module that apply to all procedures in the module.
🗑
|
||||
| show | A VBA statement used to declare variables and their associated data types in a procedure.
🗑
|
||||
| End Function statement | show 🗑
|
||||
| End Select statement | show 🗑
|
||||
| End Sub statement | show 🗑
|
||||
| event-driven language | show 🗑
|
||||
| show | The group of VBA statements executed when an If statement condition is false.
🗑
|
||||
| ForeColor property | show 🗑
|
||||
| function | show 🗑
|
||||
| function call | show 🗑
|
||||
| Function statement | show 🗑
|
||||
| If statement | show 🗑
|
||||
| show | A Visual Basic Editor window that lets you enter different values to test the procedures you create without changing any data in the database.
🗑
|
||||
| show | A function that returns True when a control value is null and False when a control value is not null.
🗑
|
||||
| LCase Function | show 🗑
|
||||
| show | A coding error that occurs when a VBA procedure produces incorrect results.
🗑
|
||||
| show | A group of related procedures that are stored together in a single object.
🗑
|
||||
| show | An action that operates on specific objects or controls.
🗑
|
||||
| show | A programming lan
guage that manipulates objects.
🗑
|
||||
| OnCurrent property | show 🗑
|
||||
| show | A placeholder used in a VBA procedure that is assigned an argument value when the procedure is executed.
🗑
|
||||
| show | A procedure in a VBA class module for a form or report that is used only by that form or report. Also known as a local procedure.
🗑
|
||||
| Procedure box | show 🗑
|
||||
| show | A procedure in a VBA standard module that more than one object can use.
🗑
|
||||
| RGB function | show 🗑
|
||||
| scope | show 🗑
|
||||
| show | A VBA module that is a database object stored in memory with other database objects when you open a database and that is listed in the Navigation Pane.
🗑
|
||||
| statement | show 🗑
|
||||
| StrConv function | show 🗑
|
||||
| string | show 🗑
|
||||
| show | A procedure that executes instructions and accepts input values, but does not return a value and cannot be used in expressions.
🗑
|
||||
| show | The first statement in a VBA Sub procedure that specifies the scope and name of the procedure.
🗑
|
||||
| true-statement group | show 🗑
|
||||
| variable | show 🗑
|
||||
| show | A predefined memory location that is initialized to a value that doesn't change.
🗑
|
||||
| vbLowerCase constant | show 🗑
|
||||
| vbProperCase constant | show 🗑
|
||||
| vbUpperCase constant | show 🗑
|
||||
| show | The program you use to create and modify VBA code. (AC 579)
🗑
|
||||
| Visual Basic for Applications (VBA) | show 🗑
|
||||
| Visual Basic window | show 🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
Rainmaker2123
Popular Computers sets