Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
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
Access Final Review
| Term | Definition |
|---|---|
| Can Grow property | A property that controls the appearance of a control or section in a form or report when viewed, printed, or previewed. When you set the property to Yes, the control or section expands vertically to print or preview all the data within the control or sect |
| Date function | A function that returns the current date. |
| detail report | A report that displays fields in the Detail section for every record from the record source. |
| custom report | An existing report that you modify, or a new report that you create from scratch in layout view or Design View |
| Group, Sort, and Total pane | 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. |
| Group Footer section | 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. |
| Group Header section | 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. |
| grouping field | 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. |
| Hide Duplicates property | 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 | A property for a group in a report to keep parts of the group together on the same page. Settings for the property are "do not keep together on one page" (default), "keep whole group together on one page" (prints the group header, detail, and group footer |
| Label Wizard | An Access tool that asks you a series of questions, and then creates a mailing label report based on your answers. |
| multiple-column report | A report that prints the same collection of field values in two or more sets across the page. |
| newspaper-style column | A multiple-column report that prints with the "down, then across" layout. Also called snaking column. |
| orphaned footer section | 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 | A report header section that appears by itself at the bottom of a page. The first detail record that follows the orphaned header section appears at the top of the next page. |
| Page Footer section | A section that appears at the bottom of each page of a report and is used for page numbers, brief explanations of symbols or abbreviations, or other information such as a company name. |
| Page Header section | A section that appears at the top of each page of a report and is used for page numbers, column headings, report titles, and report dates. |
| Report Footer section | A section that appears once at the end of a report and is used for report totals and other summary information. |
| Report Header section | A report section that appears once at the beginning of a report and is used for report titles, company logos, report introductions, dates, visual elements such as lines, and cover pages. |
| Report view | Provides an interactive view of a report. You can use Report view to view the contents of a report and to apply a filter to the data in a report. You can also copy selected portions of the report to the Clipboard and use the selected data in another progr |
| summary report | A report that displays no detailed information; only grand totals and possibly subtotals are displayed based on calculations using fields from the record source. |
| action | An instruction to Access to perform an operation. |
| action catalog button | A toggle to open and close the Action Catalog pane, which lists all actions by category and all macros in a database. |
| argument | A piece of data that is required by Access to execute an action |
| clear filter button | A button used to clear the search box and display all actions and objects in the Action Catalog pane. |
| command button | A control on a form that starts an action, or a set of actions, when you click it. |
| comment | A text description in a macro that has no effect on the macro. |
| Data Mode argument | An action argument that specifies an object's data-entry options. Allowable settings for this argument are Add (users can add new records but can't change or delete existing records), Edit (users can change and delete existing records and can add new reco |
| event | A state, condition, or occurrence detectable by Access |
| event procedure | A procedure that Access executes when an event occurs. |
| event property | The property that specifies how an object responds when an event occurs. |
| FindRecord action | An action that finds the first record, or the next record if the action is used again, that meets the specified criteria |
| Left function | A function that provides the first character(s) in a text string. The format of the Left function is Left (text string, number of characters). |
| list box | A control that displays a scrollable list of values |
| load event | An even that occurs when Access opens a form or report |
| macro | An recorded action, or a set of actions, that you want Access to perform automatically for you. |
| macro builder | The name of the Build button when you use it to work with macros. |
| Macro Desginer | A development environment built into Access that allows you create and modify macros. |
| message box | 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. |
| MSysObjects table | A system table that keeps track of the names, types, and other characteristics of every object in an Access database. |
| navigation form | A form with tabs that allows you to display database objects in an organized way to users. |
| OpenForm action | a macro action that opens a specified form in a specified view. |
| Picture Caption Arrangement property | 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. |
| PrintSelection argument | An action argument that prints the selected form record |
| procedure | A group of statements using VBA code. |
| Row Source property | A property that specifies the data source, such as a table, a query, or an SQL statement, for a control in a form or report, for a field in a table or query, or a list box or other controls. |
| RunMenuCommand action | An action that selects and runs a command on the Ribbon. |
| search box | Allows you to enter a filter term to limit the actions and objects displayed in the Action Catalog pane. |
| SelectObject action | An action that selects a specified object so that you can run an action that applies to the object |
| SELECT statement | An SQL statement used to retrieve and present data from a database. |
| single step | Executes a macro one action at a time, pausing between actions, to test the accuracy of the macro. |
| SQL | SQL (Structred Query Language) A standard language used in querying, updating, and managing relational databases. |
| submacro | 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 | Special tables maintained by Access that store information about the characteristics of a database and about the structure of the objects in a database. |
| user interface | what you see and use when you communicate with a computer program. |
| View argument | 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 | An action argument that specifies the name of a table that will be opened when the macro is run |
| AfterUpdate event | An event that occurs after changed data in a control or a record is updated. |
| argument (for VBA) | A value passed to a VBA function and used in place of a parameter when the function is executed. |
| BeforeUpdate event | An event that occurs before changed data in a control or a record is updated in the database. |
| Case control structure | A conditional control structure that evaluates an expression, and then performs one of several alternative actions based on the resulting value (or condition) of the evaluated expression. |
| Case statement | A VBA statement that designates the start of an alternative set of actions for the Case control structure. |
| class module | A VBA module that is usually associated with a particular form or report. |
| Code window | The window in which you create, modify, and display VBA procedures. |
| coding | The process of writing instructions in a programming language such as VBA. |
| compilation | The process of translating modules from VBA to a translated form that a computer can understand. |
| compile | To translate a module from VBA to a translated form that a computer can understand. |
| Conditional control structure | A VBA control structure that evaluates an expression and then performs one of several alternative actions based on the resulting value of the evaluated expression. |
| control structure | A set of VBA statements that work together as a unit. |
| Current event | The event that occurs when the focus shifts to the next record loaded in a form, making it the current record. |
| debugging | Testing the VBA code you create. |
| Declarations section | The VBA statements at the beginning of a module that apply to all procedures in the module. |
| Dim statement | A VBA statement used to declare variables and their associated data types in a procedure. |
| End Function statement | The last statement in a VBA function. |
| End Select statement | A VBA statement that designates the end of a Case control structure. |
| End Sub statement | The last statement in a VBA Sub procedure. |
| event-driven language | A programming language that executes when a specific event occurs. |
| false-statement group | The group of VBA statements executed when an If statement condition is false. |
| ForeColor property | A property that determines a control's foreground, or font, color. |
| function | A procedure that performs operations, returns a value, can accept input values, and can be used in expressions. Also known as a Function procedure. |
| function call | A statement that contains the name of a function plus any parameters required by the function. |
| Function statement | The first statement in a VBA function |
| If statement | A VBA statement that executes one of two groups of statements based on a condition. If the condition is true, the true-statement group executes. If the condition is false, the false-statement group executes. |
| Immediate window | A Visual Basic Editor window that lets you enter different values to test the procedures you create without changing any data in the database. |
| IsNull function | A function that returns True when a control value is null and False when a control value is not null. |
| LCase Function | A built-in Access function that accepts a single string argument as input, converts the value of the argument to lowercase letters, and then returns the concerted value |
| logic error | A coding error that occurs when a VBA procedure produces incorrect results. |
| module | A group of related procedures that are stored together in a single object. |
| method | An action that operates on specific objects or controls. |
| object-oriented language | A programming lan guage that manipulates objects. |
| OnCurrent property | A property that specifies how a control or object responds when the Current event occurs. |
| parameter | A placeholder used in a VBA procedure that is assigned an argument value when the procedure is executed. |
| private procedure | 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 | A box in the VBA Code window that displays the event name for the current event procedure. |
| public procedure | A procedure in a VBA standard module that more than one object can use. |
| RGB function | A built-in function that returns an RGB (red, green, blue) color value, indicating the relative intensity of red (first value), green (second value), and blue (third value) in color of a property for a control. |
| scope | The specification of a VBA procedure as either a public procedure or a private procedure. |
| standard module | 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 | An individual instruction in a programming language such as VBA. |
| StrConv function | A function that converts the letters in a string to all uppercase letters or to all lowercase letters, or converts the first letter of every word in the string to uppercase letters and all other letters to lowercase letters. |
| string | A VBA value that has the text data type. |
| sub-procedure | A procedure that executes instructions and accepts input values, but does not return a value and cannot be used in expressions. |
| Sub statement | The first statement in a VBA Sub procedure that specifies the scope and name of the procedure. |
| true-statement group | The group of VBA statements executed when an If statement condition is true. |
| variable | A named location in computer memory that can contain a value and that is declared in the Declarations section or in the procedure where the variable is used. |
| VBA constant | A predefined memory location that is initialized to a value that doesn't change. |
| vbLowerCase constant | A VBA constant used with the StrConv function that specifies the conversion of the string to all lowercase letters. (AC 600) |
| vbProperCase constant | A VBA constant used with the StrConv function that specifies the conversion of the first letter in every word in a string to uppercase letters and the conversion of all other letters to lowercase letters. |
| vbUpperCase constant | A VBA constant used with the StrConv function that specifies the conversion of the string to all uppercase letters. |
| Visual Basic Editor (VBE, editor) | The program you use to create and modify VBA code. (AC 579) |
| Visual Basic for Applications (VBA) | The programming language for Microsoft Office programs. |
| Visual Basic window | The program window that opens when you use the Visual Basic Editor. (AC 579) |
Created by:
Rainmaker2123
Popular Computers sets