- Shuffle
Toggle OnToggle Off
- Alphabetize
Toggle OnToggle Off
- Front First
Toggle OnToggle Off
- Both Sides
Toggle OnToggle Off
Front
How to study your flashcards.
Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key
Up/Down arrow keys: Flip the card between the front and back.down keyup key
H key: Show hint (3rd side).h key
PLAY BUTTON
PLAY BUTTON
46 Cards in this Set
- Front
- Back
|
What are the 6 basic objects?
|
Table, queries, reports, forms, macros, modules
|
|
What is a primary key?
|
A field that identifies each record as being unique
|
|
What is a form?
|
Allow the user to create an interface that can be more user friendly and attractive than datasheet view
|
|
What is the answer to a query?
|
A dataset
|
|
What does a backup do?
|
Produce a copy of your file with a default file name
|
|
What does compact and repair do?
|
Fixes problems due to inefficient file storage and growth of a database
|
|
What do filters create?
|
A subset of records
|
|
What is filter be selection?
|
Selects records that are only matching preselected criteria
|
|
Know when to use Access vs. Excel
|
Look at list on sg
|
|
What is a relational database?
|
Allow data to be grouped into tables and relationships created between the tables
|
|
What does referential integrity ensure?
|
That the data in a relational database maintains consistency when the data changes
|
|
What are validation rules?
|
Avoid data errors by restricting what you enter
|
|
What is Sarbanes Oxley Act?
|
Protects people from fraudulent activities. Must save records for at least 5 years and be made available to the SEC
|
|
What does PNPI safeguard?
|
Social security, credit card numbers, bank accounts, and medical records
|
|
What is normalization?
|
Reduces redundancy
|
|
What is CamelCase notation?
|
No spaces between words
|
|
What is the strength of Access?
|
That it is a relational database
|
|
What is a select query?
|
Searches associated tables and returns a dataset that matches the query parameters
|
|
What is an asterisk?
|
Searches for a pattern that includes any number of characters in the position of an asterisk
|
|
What is a IS NULL value?
|
Has no value, blank
|
|
What is the order of precedence?
|
Rules for establishing the sequence by which values are calculated
|
|
What is an expression?
|
Formulas based on existing fields
|
|
What is an IIF Function?
|
Evaluates a condition, if it is true one thing is posted, if it is false another thing is posted
|
|
What is Date Formatting?
|
Access stores dates as serial numbers so the format does not change
|
|
What is Data Aggregation?
|
Allows summarization and consolidation of data
|
|
What does a count function with an asterisk do?
|
Includes a IS NULL value
|
|
What is a report?
|
Printed document that displays information from the database
|
|
What is print preview?
|
Displays the report as it will when it is printed
|
|
What is a page header?
|
A header located at the top of every page
|
|
What is a control?
|
Position, display, format and calculate report data
|
|
What is a bound control?
|
A control that is tied to an underlying source
|
|
What is a PivotTable?
|
Interactive table that shows how information fits together
|
|
What are drop zones?
|
Accept dropped data from the fields list
|
|
What is the default chart type?
|
Column chart
|
|
What is a border?
|
Controls the border or line around an object
|
|
What are action queries?
|
Change underlying table data, create a new table, cannot be undone, maintain a database
|
|
What are crosstab queries?
|
Output resembles a PivotTable, crosstab for end-user, will not work on related data, one or more tables
|
|
What is a parameter query?
|
Information intentionally omitted by the designer, more flexible, select query, lock query, design
|
|
What is an event?
|
Action triggered by a user or a system
|
|
What is SQL?
|
Defines and processes database queries
|
|
What is Visual Basic Editor?
|
Workspace for writing/editing VBA procedures
|
|
What is syntax?
|
Rules for entering statements
|
|
What procedures perform an action?
|
Sub and function
|
|
What are decision structures?
|
Perform logical tests to compare statements
|
|
What is a Local Variable?
|
Available to a specific procedure
|
|
What should you do before using variables
|
Dim
|
