Lesson 2 key terms

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

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

Sell an automobile reflection

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.

• 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

This is my dream house.