Angel Peña

Company

2009-03-27T09:55:00.000-07:00

This is our logo. Our company is called "Cuñado's Trophy Engraving"

Lesson 3 Vocabulary Access

2009-03-10T10:07:00.000-07:00

1. Ascending Sort- Any sort that can be (A-Z or 1-10).
2. Calculated Field- To perform calculations in a query.
3. Concatenation- To perform mathematical calculations on the data it retrieves, to link the entries in two fields into a text string.
4. Criteria- allows you to work with a limited set or records that have the data you need.
5. Descending Sort- Any sort that can be (Z-A or 10-1).
6. Expression- a formula that calculates a value or defines criteria; in Access, you can use an expression to calculate new values or to specify which records should be displayed.
7. Filter- one or more criterion that you can apply to a datasheet to display a subset or records. Those records that do not meet criterion are "filtered out" and are not displayed in the subset of records.
8. Filter by Form- 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 datasheet.
9. Filter by Selection- a filtering technique in which you select a value or partial value for which you want to filter using the filter by selection button.
10. Select Query- The most common type of query in Access, the select query retrieves specific data from one or more tables and displays the results in a datasheet; however, it does not alter the data in the table(s)

Lesson 2 Vocabulary Access

2009-03-05T10:19:00.000-08:00

1. Data type: In Access, a field property that determine what type of data the field can contain.
2. Export: The process of copying data from an access table or query to another database or to another type of file.
3. Field Name: The name by which access recognizes a data field.
4. Field Property: A specific attribute of an access data field, such as name, caption, field size or input mask.
5. Import: The process of copying data from another source, such as a database or spreadsheet, into an access database.
6. Input Mask: in access, a field property that determines display format and limits the type of data that can be entered.
7. Junction Table: in access, a table that provides a link between two tables that have a many-to-many relationship.
8. Link: the connection between a source file and a destination file, or between two tables.
9. 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.
10. Many-to-Many Relationships: in access, a relationship between two tables in which each table can have many related records in the other table.
11. 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.
12. One-to-One Relationships: in access, a relationship between two tables in which each table has only one related record in the other table.
13. 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.
14. Primary Key: in access, one of more fields in a table whose values uniquely identify each record.
15. Primary Table: in access, the table on the "one" side of a one-to-many relationships.
16. 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.
17. Related Table: in access, the table on the "many" side of a one-to-many relationship.
18. 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.
19. 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.

2009-02-26T10:40:00.000-08:00

1. Database - is a collection of data, or information , related to a specific subject and kept together in a file.

2. Database Object - provides a structure through which you can store your data.

3. Database Window - used to access database objects contained in the database.

4. Datasheet - is the row-and-column-format.

5. Datasheet View - to add, modify, or delete data in a table or query.

6. Design View - to set or change the structure of any object.

7. Field - Every row is a unique record that contains all the data for a particular item.

8. Form - a window into the data on one or more tables.

9. Form View - commonly used because it allows you to view the fields for only one record at a time.

10. Print Preview - allows you to see how the data will look when you print a report.

11. Query - looks like a table, but it doesn't contain any data contain any data itself; instead, it displays only specific data from tables based on the criteria you supply.

12. Record - every row that contains all the data for a particular item.

13. Record Selector - you can select an entire record by clicking the record selector, a small gray box to the left of each record.

14. Relational Database - allows you to store categories of data in separate tables, yet combine data from any of the tables.

15. Report - a professional-looking printout of database data that usually contains summary information.

16. Table - is the only object in an Access database that contains data.

Lesson 1 Vocabulary Access

2009-02-26T10:20:00.000-08:00

1. Database- is a collection of data, or information , related to a specific subject and kept together in a file.

2. Database object- provides a strusture through wich you can store your data.

3. Database window- used to acess database objects contained in the database.

4. Datasheet- is the row-and-column-format.

5. Datasheet view- to add, modify, or delete data in a table or query.

6. Design view- to set or change the structure of any object.

7. Field - Every row is a unique record that contains all the data for a particular item.

8. Form- a window into the data on one or more tables.

9. Form View - commonly used because it allows you to view the fields for only one record at a time.

10. Print Preview - allows you to see how the data will look when you print a report.

11. Query - looks like a table, but it doesn't contain any data contain any data itself; instead, it displays only specific data from tables based on the criteria you supply.

12. Record - every row that contains all the data for a particular item.

13. Record Selector - you can select an entire record by clicking the record selector, a small gray box to the left of each record.

14. Relational Database - allows you to store categories of data in separate tables, yet combine data from any of the tables.

15. Report - a professional-looking printout of database data that usually contains summary information.

16. Table - is the only object in an Access database that contains data.

Product Endorsement Reflection

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

If the opportunity presented itself, I would endorse Adidas because I like many of their products

Picture of Document

2009-02-18T10:49:00.000-08:00

U.S. History Timeline Reflection

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

You could use this timeline as a game for young children because it enables them to click and go to the slide that corresponds to the button.

2009-02-04T09:52:00.001-08:00

Sell an Automobile Reflection

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

My ad wouldn't catch my attention because it isn't as professional as it should be. It may answer some of my questions but I tend to ask a lot of questions. It does tell you what the seller is selling but if a buyer wanted to call, the phone number isn't on there because I didn't want to put my number on there.

Fundraiser Spreadsheet (Atheletics) Reflection

2008-12-01T11:30:00.000-08:00

School clubs could have fundraiser for needed materials or field trips.

Sales Invoice Reflection

2008-12-01T11:27:00.000-08:00

Purcase Order and Balance Sheet

Accounts Payable Reflection

2008-12-01T11:23:00.000-08:00

I think that accounts receivable means the amount that a company is owed for goods and services.
The definition is : Money which is owed to a company by a customer for products and services provided on credit.

Create a Check Register Reflection

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

It's helpful to keep track of your balance on a spreadsheet because it does most of the calculations for you. You are more likely to make a mistake and throw off your balance more than a computer.
I can't think of a very bad disadvantage other than other may be able to see the file on a computer. But its smart to keep track of your balance just in case you ever suspect that you are missing any money. You can always go back and check each entry.

Payroll Reflection

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

If Diana worked 5 extra hours at 1 1/2 times her rate of pay, it would increase her net pay by $43.31. Her net pay would increase to $254.31

College Budget Reflextion

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

If the budget is short, I would minimize unnecessary spending and if that doesn't help much then possibly find another college that would fit the budget.

Unit 2, Lesson 1 Key Terms

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

1. Column Index: The column number in the table array from which the matching value must be returned when using a LOOKUP function.
2. Comment: Text in Visual Basic added to code that explains how the code works. It begins with an apostrophe.
3. Conditional Formatting: A format such as a cell shading or font color, that Excel automatically applies to a cell or 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 an XML file; it is used to name the table when imported into 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 a 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 represents a cell range of cells, formulas, or 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. Start-Tag: The tag that begins an XML statement.
18. Static Data: Data appears as it would in Excel, including tabs that users can click 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 (W3C): A consortium of commercial and educational institutions that oversees research and promotes standards in all areas related to the World Wide Web.

My House

2008-10-24T10:50:00.000-07:00

This is the closest I could get to my actual house. The only main difference is the color of the grass, which at home is yellow and dead. I'm missing a triangle above the front window but other than that, its the same.

Lesson 5 Customizing Words

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

1. Macros: An action or 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: Designed to help you work quickly and efficiently by making the most frequently used features easy to access.
5. Visual Basic Editor: A basic program within Word and Excel that allows you to edit or delete the commands in a macro.

This Day in History

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

I don't really have a writing process. I always have a very difficult time starting my papers. It has never been my strong point. I kind of just put something down on paper and hope it's good enough.

Thank You Letter

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

It is important to write a thank you letter because you are letting the interviewer know that you appreciate them taking the time to interview you.

Highlighting is Helpful

2008-10-14T09:59:00.001-07:00

An adjective describes a noun.
An adverb describes a verb.

Week #7 Terms

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

1. Carry: to take or support from one place to another; convey; transport.
2. Calculate: to determine or ascertain by mathematical methods; compute.
3. Choose: to select from a number of possibilities; pick by preference.
4. Classify: to arrange or organize by classes; order according to class.
5. Collect: to gather together; assemble.
6. Communicate: to impart knowledge of; make known.
7. Compare: to examine in order to note similarities and differences.
8. Connect: to join, link, or fasten together; unite or bind.
9. Construct: to build or form by putting together parts; frame; devise.
10. Contrast: to compare in order to show unlikeness or differences; note the opposite natures, purposes, etc.
11. Convert: to change (something) into a different form or properties; transmute; transform.

Formatting Fun pg. 12

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

1. Noun: a person, place, thing, or idea.
2. Verb: The part of speech that expresses existence, action, or occurrence.
3. Preposition: any member of a class of words found in many languages that are used before nouns, pronouns, or other substantives to form phrases functioning as modifiers of verbs, nouns, or adjectives, and that typically express a spatial, temporal, or other relationship.

Terms Week #6

2008-09-30T09:49:00.000-07:00

act: to perform in or as if in a play; represent dramatically: act out a story
active: to make active; cause to function or act
add: to join or combine or unite with others
analyze: to examine carefully and in detail so as to identify causes, key factors, possible results, etc
answer: to speak or write in response; make answer; reply
approximate: nearly exact; not perfectly accurate or correct
ask: to put a question to; inquire of
apply: to make use of as relevant, suitable, or pertinent

Lesson 3 Vocab

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

1. Check Boxes: A type of form field that allows for several choices that users can click to select more than one option.
2. Comments: Text in Visual Basic added to code that 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 field menu that provides several predefined answers from which users can choose one.
5. Form: Print or electronic documents with text and field that users can fill out or click to give feedback.
6. Hyperlinks: Clickable text or graphic link within an HTML document that lead to another place on the document or display a new document in the browser.
7. Merge: The process of combining information from 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

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

A describing word is an adjective.

Lesson 1 & 2 Vocab

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

1. Clip Art Gallery: a collection of clip art graphics available through the Insert ClipArt task pane.
2. Drawing Toolbar: a toolbar with buttons for inserting pictures 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 comands that can be applied to text throughout a document.
5. text box: a feature available on the Drawing toolbar that allows yout to input text 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 at the last line of a paragraph that is printed alone at the top of a new page
7. WordArt: 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. endnote: a reference or 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 numbers at the end of a document.
14. master document: a document made up of subdocuments.
15. Outline level: a place on the outline hierarchy shown 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. subdocument: 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 headings and corresponding page numbers in a document displayed at the beginning.

Wonderful Me!

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

1. Name: Angel Peña.
2. I was born in Orange, CA.
3. I have lived in this town for four years.
4. I have also lived in the following states and/or countries: California
5. I have two sisters and no brothers.
6. I live with my parents and my sisters.
7. My favorite subjects in school are math.
8. I like to read books about interesting things.
9. My special interests, activities, hobbies are computers and doing sports.
10. The one thing I enjoy doing more than anything else in the whole wide world is doing sports.
11. If I were going to set one goal for myself this year, it would be to bump up in my school ranking.
12. My most valuable material possesion is my 8 year-old two dollar bill.
13. My most valuable non-material possession is my brain.