abel aguirre

Lesson 3 key terms

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

Ascending sort- Any sort that can be (A-Z or 1-10).
Calculated field- To perform calculations in a query.
Concatenation- To perform mathematical calculations on the data it retrieves, to link the entries in two fields into a text string.
Criteria- allows you to work with a limited set or records that have the data you need.
Descending sort- Any sort that can be (Z-A or 10-1
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 key terms

2009-03-05T10:07: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.

Key terms lesson 1

2009-02-26T10:41: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 endorsements

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

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

Sell an automobile reflection

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

My ad was not as good as i know about what i can do because i was
kind of lost yestorday.

Unit 2 lesson 1 vocab.

2008-10-29T09:52:00.000-07:00

column index-the column number in the table array from wich the matching value must be returned.
comment- text in visual basic added to code that explains how thw code works.
conditional formatting- format such as cell shading or font color.
custom filter- a list taken from within a larger lists where the only records shown are the rows that meet the criterria you specify for a column.
data list- worksheets rows that contain related data.
document element- top most element ina XML file.
end tag- specifies the end of a element.
export- to use data in another program.
extensible markup language-strutured data from an application in a standard, consistent way.
filter- list taken frrom within a larger list where the only records shown are the rows that meet the criteria you choose from a dro down list for a column.
HLOOKUP- 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.
interactive data- html file that contains special components that allow browser users to interact with the workbook.
lookup value- value to be found in the first column of the table array when using a lookup function.
named range- word or string of characters that represent a cell, range of cells, formula, or constant value.
start tag-the tag that begins an XML statement.
static data- data appears as it would in excel, including tabs that users can click to switch the worksheets.
table array- the table information in wich data is lookedup when using LOOKUP function.
VLOOKUP- a function that searches for a value in the left most column of a table.
world wide web consortium- a consurtiom 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:51:00.001-07:00

This is my dream house.

Lesson 5 Costumizing Word

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

macros- allow you to record a sequence of keystrokes and mouse clicks that you can replay later.
menus- at the top of the document are designed to help you work quickly and efficiently by making the mosst frequently used feutures easy to access.
record macro- can make creating sophisticated Word document easy.
toolbars- at the top of the document are designed to help you work efficiently by making the most frequenly feutures aesy to access.
visual basic editor- add or remove lines of code.

This Day in History

2008-10-16T10:11:00.000-07:00

The way I approach the writting process and the steps that you go through
to have a finished paper is very simple I check that I have an introduction,
a body, anda conclusion. Pretty much when I have that I check for the minor
herrors like spellinng, and punctuation. That is the way I go through to have
a finished paper.

Highlighting is helpful

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

The difference between an adjective and a adverb is that an adjectiveis a person place or a thing, and an adjective is a part of speech that modifies a verb, adjective, or other adverbs.

week #7 terms

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

carry- to take or support from one place to another.
calculate- to determine or ascertain by mathematical methods.
choose- to select from a number of possibilities.
classify- to arrange or organize by classes.
collect- to gather together.
communicate-to import knowledge of.
compare-to examine (two or more objects, ideas, people, etc.) in order to note similarities and differences
connect-to join, link, or fasten together; unite or bind.
construct-to build or form by putting together parts.
contrast-to compare in order to show unlikeness or differences.
convert-to change (something) into a different form or properties.

Warm-up

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

1. Act- anything done, being done, or to be done.
2. Activate- to make active; cause to function or act.
3. Add- to unite or join so as to increase the number, quantity, size, or importance.
4. Analyze- to separate into constituent parts or elements; determine the elements or essential features.
5. Answer- spoken or written reply or response to a question, request, letter, etc.
6. Approximate- near or approaching a certain state, condotion, goal, or standard.
7. Ask- to put a question to; inquire of:
8. Apply- to make use as revelant, suitable, or pertinent:

vocab. lesson 3

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

1. check boxes- a type of fprm field that allows for several choices that users can click to select more than one option.
2. comments- electronic notes that are edit suggestions or other kinds of notes.
3. digital signiture- an electronic enccryption-based secure stamp of authentication on a macro or document.
4. drop down-a form field menu that provides several predefined answers.
5. form- print or electronic documents with text and fields that users can fill uot or click to give feedback.
6. hyperlinks- clackable text or graphic links within HTML that leads to another place in the document or display a new document in browser.
7. merge- the process of combining information from one document into another.
8. protect document- the process that keep viewrs from making changes to a document or making any changes the reviewr makes.
9. reviewrs- a person who reads a document and uses Word tools like tracked changes or comments to edit the documnet.
10. text field- a form field that allows users to type text in a variaty of different formats.
11. track changes- a feauture that shows tha additions and deletions made by the author or reviewer in color and margin notes.
12. versions- a record of changes made to a document that is saved within the document.

vocab.

2008-09-15T11:30: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- toolbar with with buttons for inserting pictures and drawing many different types of objects.
3. Section Breaks- you can make major changes to several pages in the middle of the document.
4. Styles- Collections of text and paragraph fprmatting commands that can be applied to text thruoghout a document.
5. Text box- a feature available on the drawing tollbar that allows you to input text in a box anywhere in a word document.
6. Widow/orphan control- An orphan is the first line of the graph printed alone at the bottom of the page.
7. Word Art- a feuture avilable from the drawing tools that create 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 diologue 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.
11. Endnote-a reference or cituation at the end of a document.
12. footnote-a reference or situation at the bottom of a page in a document.
13. index-lists of subjects terms, names, titles and other items and corresponding page numbers at the end of document.
14. master document-a document made up of subdocuments.
15. outline level-a place on the outline hierachy shown in the outline view.
16. outline view- one of the display options available from the view menu.
17. subdocument- a part of a set of documents that are linked to and make up master document.
18.- table of contents- list of the major headings and corresponding page numberrs in a document displayed at the beginning.

Wonderful me

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

1. Name- Abel Aguirre
2. I was born in Dallas
3. I have lived in this town for about five years
4. I have also lived in the following states and/or cities, Houston.
5. I have three sister and zero brothers.
6. I live with mom and dad.
7. My favorite subject in school are math and science.
8. I like to read books about sports.
9. My special interests, activities, hobbies are soccer and cross country.
10. The one thing i enjoy doing more than anything else in the whole wide world is playing soccer.
11. If i were going to set one goal for myself this year, it would be graduate.
12. My most valluable material possession is my soccer ball signed by Mexico's soccer team.
13. My most valuable non-material possession is my brain.