Study your flashcards anywhere!

Download the official Cram app for free >

  • 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/45

Click to flip

45 Cards in this Set

  • Front
  • Back
What is a database?
a collection of info/data stored in the computer
Where might you see a database?
The doctor's office
What does a database allow you to do?
enter, access, or analyze info
What is the info?
A collection of lists - ex. a medical history
How does Access org. info?
uses tables ( like in Excel )
What is the difference between Access and Excel?
Access: analyzes and connects data; Excel: stores and organizes numbers
What kind of database is access?
a relational database - so info is linked together
Can Excel make a relationship between the tables?
No
Because of Access's relationship, what can you do?
Search and analyze info
In Access, what are the columns called?
Fields
In Access, what are the rows called?
Records
In Access, what do you do?
Create tables and then connect them
In Access, when do you save the database?
Before you add anything
In Excel, when do you save the database?
After you add something
What are the three ways you can open Access?
Blank, Templet, Existing
What are examples of fields?
Zip code, state, first name, last name, etc.
What can you do in a datasheet view?
Create a table or enter records/info.
What is a design view?
YOU CAN NOT enter info; you can ONLY create a table; you have advanced functions; you select data type and select field properties
If you have a field recording today's date, what would you pick ( data type ) ?
Date/time
If you have a field recording salary, what would you pick ( data type )
Number AND currency
If you have a field recording an explanation ( paragraph ), what would you pick ( data type ) ?
Memo
What is the value of yes/no? ( data type )
Yes/no - only
What data types do you need to know?
Text, memo, date/time, currency, autonumber, and yes/no
How many characters ( letters, numbers, and symbols ) can a field hold? What happens if you leave it at the maximum?
255; if you leave it like that, the program will slow down
What is the primary key?
A unique identifier for each record that allows you to avoid duplication
How many records can a table have?
1 or more
What are rows?
Numbers
What do columns have?
Letters
Give an example of a cell reference.
B2
Explain the advantage of using a cell reference in a formula.
If the value in the cell changes, the answer automatically does, too.
Can rows and columns be widened?
Yes
How many worksheets does Excel have when you open it?
3
In Excel, one rectangle is called a ----.
Cell
The highlighted rectangle is called what?
The active cell
List 4 things you can do with Excel.
Make a chart, a budget, keep inventory, and use functions
What is the multiplication sign in Excel?
*
What is the division sign in Excel?
/
How could one find the website for Jefferson County Public Library?
Go to Internet Explorer and type in the search box, Jefferson County Public Library and click on Jefferson County Public Library - Colorado
Where would one search for a book?
Click on Find Library Books and More
How many different searches are there to find a book?
10
What is the difference between a search engine and a web browser?
Web browser: NEEDED to open up a search engine; Safari or Internet Explorer are examples; Search engine: Google, Yahoo
What does TLC-You See More help you find?
The Develyn Library
How many databases could you use to search country specific info?
6
How do you cite a book?
Author's last name, first name, middle initial., book title., city published: publisher, year published * - remember: IT MUST BE IN ALPHABETICAL ORDER!
What are the 5 W's of website evaluation?
WHO - who wrote it; WHAT - what is the purpose; WHEN - when was it created; WHERE - where does the info come from; WHY - why is it useful for your purpose