Autumn Pearson

Access - Lesson 3 Vocab

2009-03-12T09:45:00.000-07:00

Ascending Sort: A sort order that sorts text values from A to Z and numbers 1 to 10.
Calculated Field: A field in access query, form, or report in which the displayed values are the result of calculations performed on other fields.
Concatenation: In access, joining two values to display them as a single value.
Criteria: A limiting condition, such as "Arizona" or ">100" used in access queries and filters to show a limited set of records.
Descending Sort: A sort order that sorts text values from Z to A and number values from 10 to 1.
Expression: In access, you can use an expression to calculated new values or to specify which records should be displayed.
Filter: In access, one or more criterion that you can apply to a data sheet to display a subset of records.
Filter By From: In access, a filtering technique in which you can type the values for which you want to filter using a form that contains all the fields in the data sheet.
Filter By Selection: In access, a filtering technique in which you select a value or partial value for which you want to filter using the Filter By Selection button.
Select Query: The most common type of query in access, the select query retrieves specific stat from one or more tables and displays the results in a data sheet.

Access - Lesson 2 Key Terms

2009-03-05T09:45:00.000-08:00

Data type: In Access, a field property that determine what type of data the field can contain.
Export: The process of copying data from an access table or query to another database or to another type of file.
Field Name: The name by which access recognizes a data field.
Field Property: A specific attribute of an access data field, such as name, caption, field size or input mask.
Import: The process of copying data from another source, such as a database or spreadsheet, into an access database.
Input Mask: in access, a field property that determines display format and limits the type of data that can be entered.
Junction Table: in access, a table that provides a link between two tables that have a many-to-many relationship.
Link: the connection between a source file and a destination file, or between two tables.
Look up Field: in access, a field that looks up a list of values in another table or in a static list and presents the list of values for data entry selection.
Many-to-Many Relationships: in access, a relationship between two tables in which each table can have many related records in the other table.
One-to-Many Relationships: in access, a relationship between two tables in which only one table can have many related records in the other table.
One-to-One Relationships: in access, a relationship between two tables in which each table has only one related record in the other table.
Orphan: in access records in a related table that are left unrelated if their related record in the primary table is deleted or changed so that the relationship is broken.
Primary Key: in access, one of more fields in a table whose values uniquely identify each record.
Primary Table: in access, the table on the "one" side of a one-to-many relationships.
Referential Integrity: a system of rules that access uses to ensure that relationships between records in related tables are valid, and that you done accidentally delete or change related data.
Related Table: in access, the table on the "many" side of a one-to-many relationship.
Relationships: in access, the association between two tables that share a field with matching values; the matching fields allow the tables to be joined, so that a query can select data from both tables.
Subdatasheet: in access, a data sheet that is nested within another data sheet and contains records related to the records in the data sheet in which it is nested.

Lesson 1 Access Terms

2009-02-26T09:50:00.001-08:00

Database: A collection of data related to a particular topic.
Database Object: Tables, queries, reports, forms, and other objects that are the functional parts of an Access database.
Database Window: the window that appears when you first open an Access database.
Data sheet: In Access, data displayed in a row-and-column format in table, query, or form.
Data sheet View: In Access, an object view that displays records in a row-and-column format similar too a spreadsheet.
Design View: In Access, an object view that allows you to design and change tables, queries, forms, reports, and other objects.
Field: in Access, a field is displayed as a column in Data sheet view.
Form: An Access database object that holds controls for entering, editing, and displaying data from an underlying table or query.
Form View: In access, object view that usually displays data one record at a time, with added graphical elements for easier reading.
Print Preview: A document view that shows how your document will look when its printed.
Query: In Access, a database object that shows specific data you want to work with. The data may be drawn from multiple related tables, may have several filters applied and may include calculated expressions.
Record: Om Access. a set of information that belongs together, such as a customer's name and address information, or details about a product.
Record Selector: In access, the gray box at the left side of each record in Data sheet view or in Form view. Click the record selector to select the entire record.
Relational Database: A type of database in which information is stored in separate but related tables, which allows for non redundant, more efficient data storage and retrieval.
Report: In access, a database object that presents data organized and formatted to your specifications.
Table: In Access, a collection of data with the same subject of topic. Data are stored in records (rows) and fields (columns).

Product Endorsements

2009-02-19T09:54:00.000-08:00

If i could endorse a product, i would probably want to endorse a clothing brand or company. I'm not really sure which one exactly, but i think that would be cool to do.

Marketing Intro.

2009-02-06T09:53:00.000-08:00

McDonald's

McDonald's targets people who are on a tight budget and don't want to spend a lot of money, and also people who are in a hurry. McDonald's marketing mix is that the prices are low, they have many commercials and signs to promote their business, they have a wide variety of foods from burgers, to salads, to chicken, to ice cream and pie, and there are McDonald's everywhere you look it seems like.

Reflection: History Timeline

2009-02-05T10:04:00.000-08:00

I think that this process could be effective in teaching younger kids in ways like this, or in a jeopardy format because it can be interactive with them and it can also involve pictures to keep them entertained.

Auto Flyer

2009-02-03T10:16:00.000-08:00

I think that my add would catch my attention, but maybe not hold it for long. I would probably glace at it but never read it all the way through. It answers most of my questions, i dont know what they are selling the car. Yes, i think it describes the car well enough and it gives me information about the seller also.

Fundraiser Spreadsheet (Athletics)

2008-11-07T10:02:00.000-08:00

Reflection:

One reason is to help pay for equipment, events, uniforms, trips, and other things.
Another reason is to maybe keep kids involved more in the program.

Creating A Check Register

2008-11-07T09:50:00.001-08:00

Reflection:

Advantages: are that it will automatically update the end result because of the formulas that you input.

Disadvantages: you can put in the wrong formulas and you can end up with a result thats not correct, and you can think that you have more money than you actually have.

Why? you should keep a current balance on your account so that you will know how much money you have to spend, so that you dont overspend.

Payroll

2008-11-07T09:48:00.000-08:00

Reflection: Her net pay increase will be $158.81.

College Budget

2008-11-05T10:23:00.000-08:00

Reflection: You can cut some things out completely, you can reduce some areas of your budget, and you can create more income.

Unit 2, Lesson 1 Vocab

2008-10-29T10:38:00.000-07:00

1. Column index: The column number in the table array from which the matching value must be returned when using LOOKUP function.
2.Comment: Electronic notes that are edits, suggestions or other kinda of notes about the document and are attached to a document in specific places.
3.Conditional Formatting: A format, such as cell shading of font color, that Excel automatically applies to a cell of group of cells if a specified condition is true.
4. Custom Filter: A list taken from within a larger list where the only records shown are the rows that meet the criteria you specify for a column.
5.Data List: A series of worksheet rows that contain related data. The first row of the list has labels for the columns.
6. Document Element: The top most element in XML file; it is used to name the table when imported in to an application.
7.End-tag: The tag that specifies the end of an element; it is case-sensitive.
8.Export: To use data in another program.
9.Extensible Markup Language: A format for delivering rich, structured data from an application in standard, consistent way.
10.Filter: A list taken from within a larger list where the only records shown are the rows that meet the criteria you choose from a drop-down list for a column.
11.HLOOKUP: A function that searches for a value in the top row of a table and then returns a value in the same column from a row you specify in the table.
12.Import: To use data from another program.
13.Interactive data: an HTML file that contains special components that allow browser users to interact with the workbook.
14.Lookup Value: The value to be found in the first column of the table array when using a LOOKUP function.
15.Named Range: A word or string of characters that represent a cell, range of cells, formula, of constant value.
16.Processing Statement: A statement in XML format that provides additional application-specific information about the document; it begins and ends with a question mark.
17.State-tag: The tag that begin an XML statement; for example begins the Name Field.
18.Static data: Data appears as it would in Excel including tabs that users can slick to switch between worksheets; however, users cannot change or interact with the data in the browser.
19.Table array: The table of information in which data is looked up when using a LOOKUP function.
20.VLOOKUP: A function that searches for a value in the left-most column of a table, and then returns a value in the same row from a column you specify in the table.
21.World Wide Web Consortium: A consortium of commercial and educational institutions that oversees research and promoter standards in all areas related to the World Wide Web.

My House

2008-10-24T09:55:00.000-07:00

This is my house, itkinda looks somewhat like this!

LESSON 5 CUSTOMIZING WORD

2008-10-20T11:17:00.000-07:00

1. Macros: An action or a set of actions you can use to automate tasks.
2. Menus: A list of commands that is contained in one drop-down list available by clicking the title of the menu.
3. Record Macro: A feature on the Tools menu that allows you to name and record a series of commands for a macro.
4. Toolbars: At the top of a Word document that is designed to help you work quickly and efficiently by making the most frequently used features easy to access.
5. Visual Basic Editor: A program within Word and Excel that allows you to edit of delete the commands in a macro.

This day in History

2008-10-16T09:47:00.000-07:00

My personal writing process:

brainstorm what I'm going to talk about
research some of my ideas
begin writing
revise and spell check

I approach my writing process by thinking about the different topics i am going to talk about and the ways i can talk about them effectively. Once Ive decided what direction my paper is going, i begin writing and after i write some i go back and reread it to make sure it flows and makes sense of what I'm saying. I do that until i have finished and i proofread several time and spell check, and then i am done!

Thank You Letter

2008-10-16T09:46:00.000-07:00

I think that it is important that you send a thank you letter after a job interview because i shows that you really are interested in working there and that you care about the company, not just the pay.

Relection Page 13

2008-10-14T10:18:00.000-07:00

An Adjective describes someone or something while an adverb describes a verb.

Week #7 Terms

2008-10-07T09:59:00.000-07:00

1. Carry: To move while supporting.
2. Calculate: To determine by mathematical processes;to reckon by exercise of practical judgment.
3. Choose: To select freely and after consideration.
4. Classify: To assign (as a document) to a category.
5. Collect: To gather or exact from a number of persons or sources.
6. Communicate: To convey knowledge of or information about; make known.
7. Compare: To examine the character or qualities of especially in order to discover resemblances or differences.
8. Connect: To become joined.
9. Construct: To make or form by combining or arranging parts or elements.
10. Contrast: To compare or appraise in respect to differences.
11. Convert: To bring over from one belief, view, or party to another.

Reflection

2008-10-02T10:16:00.001-07:00

NOUNS: person, place, or thing
VERBS: action word, what they are doing
PREPOSITION: words like a, the, of

Terms Week #6

2008-09-29T11:13:00.000-07:00

1. Act: To do something; exert energy or force; be employed or operative.
2. Active: Engaged in action; characterized by energetic work, participation.
3. Add: To unite or join so as to increase the number, quantity, size, or importance.
4. Analyze: To unite or join so as to increase the number, quantity, size, or importance.
5. Answer: A spoken or written reply or response to a question, request, letter.
6. Approximate: To come near to; approach closely to.
7. Ask: To put a question to; inquire of.
8. Apply: To make use of as relevant, suitable, or pertinent.

Lesson 3 Vocab

2008-09-23T10:14:00.000-07:00

1. Check Boxes: A type of form fields that allows for several choices that users can click to select more than one option.
2. Comments: Texts in Visual Basic added to code that's explains how the code works. It begins with an apostrophe.
3. Digital Signature: An electronic encryption-based, secure stamp of authentication on a macro or document. This signature confirms that the macro or document originated from the signer and has not been altered.
4. Drop-down: A form fields menu that provides several predefined answers from which users can choose one.
5. Form: Print of electronic documents with text and fields that users can fill out or click to give feedback.
6. Hyperlinks: Click able text or graphic links within an HTML document that lead to another place in the document or display a new document in the browser.
7. Merge: The process of combining information form one document into another.
8. Protect Document: The process that keeps reviewers from making changes to a document or marking any changes a reviewer makes.
9. Reviewers: A person who reads a document and uses Word tools like tracked changes or comments to edit the document.
10. Text Field: A form field that allows users to type text in a variety of different formats.
11. Track Changes: A feature that shows the additions and deletions made by the author or reviewer in color and with margin notes.
12. Versions: A record of changes made to a document that is saved within the document.

Reflection 9/17

2008-09-17T10:09:00.000-07:00

What is the literary term for a describing word?
-Adjective.

Lesson 1& 2 vocab

2008-09-15T11:45:00.000-07:00

1. Clip Art Gallery: A collection of clip art graphics available through the Insert Clip Art task pane.
2. Drawing Toolbar: A toolbar with buttons for inserting picture and drawing many different types of objects.
3. Section Breaks: A break in a document that you can format differently than previous and following sections.
4. Styles: Collections of text and paragraph formatting commands that can be applies to text throughout a document.
5. Text Box: A feature available on the Drawing toolbar that allows you to input test in a box anywhere in a Word document, including over graphics.
6. Widow/Orphan Control: An orphan is the first line of a paragraph printed alone at the bottom of the page. A widow is the last line of a paragraph that is printed alone at the top of a new page.
7. Word Art: A feature available from the drawing tools that creates words with different shapes and colors.
8. Bookmark: A marked location in the text of a Word document that can be returned to quickly through the Bookmark dialog box.
9. Cross-Reference: An index entry that refers to another index entry.
10. Document Map: A pane that can be displayed on the left side of the screen that lists and links to the headings in a document so that a reader can jump to different sections by clicking the links.
11. End note: A reference of citation at the end of a document.
12. Footnote: A reference or citation at the bottom of a page in a document.
13. Index: A list of subjects, terms, names, titles, and other items and corresponding page number at the end of a document.
14. Master Document: A document made up of sub documents.
15. Outline Level: A place on the outline hierarchy shoe in the Outline View.
16. Outline View: One of the display options available from the View menu that shows different levels of text in a document.
17. Sub Document: A part of a set of documents that are linked to and make up a master document.
18. Table of Contents: A list of the major heading and corresponding page numbers in a document displayed at the beginning.

Wonderful Me!

2008-09-09T10:27:00.000-07:00

Name: Autumn Pearson
I was born in Austin, TX.
I have lived in manor for my whole life.
I have never lived anywhere else.
I have no sisters and no brothers.
I live with my parents.
My favorite subject in school are English.
I like to read books about romance.
My special interest, activities, hobbies are color guard, my church, and doing things with friends.
The one thing i enjoy doing more than anything else in the whole wide world is going and doing silly things with friends.
If i were going to set one goal for myself this year, it would be getting my applications and scholarship in and getting in to the college that i want.
My most valuable material possession is my necklace.
My most valuable non-material possession is my faith.