• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
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

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/46

Click to flip

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