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.

Lesson 5 Costumizing Word

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.