Access - Lesson 2 Key Terms

Data Type: In access a field property that determines 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, such as an Excel worksheet.
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 open Access database.
Input mask: In access , a field property that determines display format and limits the type of data that can be entered; makes data entry faster and more precise.
Junction table: In access, a table that provides a link between two tables that have a many-to-many relationship;the junction table has a one-to-many relationshipwith each of the two tables it links
Link: The connection between a source file and a destination file, or between two tables; any changes made later to the source file are reflected in the destination file.Contrast with embed.
Lookup 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 Relationship: In access a relationship between two tables in which only one table can have many related records in the other table.
One-to-one Relationship: 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 relationship 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 or more fields in a table whose values uniquely identify each record.
Referential Intergrity: A system of rules that access uses to ensure that relationships between records in related tables are valid, and that you don't accidentally delete or change related data.
Related Table: In access, the table on the many side of a one-to-many relationship.
Relationship: In access, the association between two tables that share a field with amtching values; the 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 datasheet that is nested within another datasheet and contains records related to the records in the datasheet in which it is nested.

Access Lesson 1:Key terms

Database:A collection of data related to a particular topic. An Access database is a single file that contains all the tables, queries, forms, and reports for that collection of information.
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. The Database window gives you access to all the objects in a database.
Datasheet:In access, data displayed in a row -and-column format in a table, query, or form.
Datasheet View:In access, an object view that displays records in a row-and-column format similar to a spread-sheet.Datasheet view allows you to see many records at the same time.
Design View: In access, an object view that allows you to design and change tables, queries, forms, reports, and other objects.
Field:In word, a special placeholder for channgeable information such as the date or time. In access, field is displayed as a column in datasheet 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, an object view that usually displays data one record at a time, with added graphical elements for easier reading. This view is covenient for entering and editing data in tables.
Print Preview: A document view that shows how your document will look when it is printed.
Query:In access, a data base ovject that shows specific database object that shows specific data you want to work with. The data may be drawn from multiple related tables, may invlude calculated expressions.
Record: In 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 Datasheet 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 seperate but related tables, which allows for nonredundant, 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 or topic. Data are stored in records and fields.

My house

This is my house. I really couldnt get into it like i wanted to because i was absent.
Its not all that big i mean its a house not a mansion.

This is my house

Class Activities-Week #7 Terms

Carry: transport: move while supporting, either in a vehicle or in one's hands or on one's body
Calculate: judge to be probable
Choose: pick out, select, or choose from a number of alternatives
Classify: arrange or order by classes or categories
Collect: roll up: get or gather together
Communicate: transmit thoughts or feelings
Compare: examine and note the similarities or differences of
Connect: connect, fasten, or put together two or more pieces
Construct: make by combining materials and parts
Contrast: the opposition or dissimilarity of things that are compared
Convert: change from one system to another or to a new plan or policy

Formatting Fun,pg.12

1.Nouns:the word class that can serve as the subject or object of a verb, the object of a preposition, or in apposition
2.Verb: the word class that serves as the predicate of a sentence
3.Prepositions:are locational or time words

Terms: Weeks 6

act: perform an action, or work out or perform behave in a certain manner
active:tending to become more severe or wider in scope; "active tuberculosis"
add: make an addition (to); join or combine or unite with others; increase the quality, quantity, size or scope of;
analyze:consider in detail and subject to an analysis in order to discover essential features or meaning
answer: react verbally
approximate :not quite exact or correct but close to it
ask:inquire about
apply:use: put into service; make work or employ for a particular purpose or for its inherent or natural purpose

Chapter 3 vocab.

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: Electronic notes that are edits, suggestions, or other kinds of notes about the document and are attached to a document in specific places.
3.Digital Signature: An electronic, encryption-based, secure stamp of authentication on a macro or document. This signature confims that the macro or document originated from the signer and has nat 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 fields that users can filll out or click to give feedback.
6.Hyperlinks: Clickable 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 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.