Access - Lesson 3 Vocab

1. Ascending Sort: A sort order that sorts text values from A to Z and numbers 1 to 10.
2. Calculated Field: A field in access query, form, or report in which the displayed values are the result of calculations performed on other fields.
3. Concatenation: In access, joining two values to display them as a single value.
4. Criteria: A limiting condition, such as "Arizona" or ">100" used in access queries and filters to show a limited set of records.
5. Descending Sort: A sort order that sorts text values from Z to A and number values from 10 to 1.
6. Expression: In access, you can use an expression to calculated new values or to specify which records should be displayed.
7. Filter: In access, one or more criterion that you can apply to a data sheet to display a subset of records.
8. Filter By From: In access, 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 data sheet.
9. Filter By Selection: In access, 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 stat from one or more tables and displays the results in a data sheet.

Access - 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.

Lesson 1 Access Terms

1. Database: A collection of data related to a particular topic.
2. Database Object: Tables, queries, reports, forms, and other objects that are the functional parts of an Access database.
3. Database Window: the window that appears when you first open an Access database.
4. Data sheet: In Access, data displayed in a row-and-column format in table, query, or form.
5. Data sheet View: In Access, an object view that displays records in a row-and-column format similar too a spreadsheet.
6. Design View: In Access, an object view that allows you to design and change tables, queries, forms, reports, and other objects.
7. Field: in Access, a field is displayed as a column in Data sheet view.
8. Form: An Access database object that holds controls for entering, editing, and displaying data from an underlying table or query.
9. Form View: In access, object view that usually displays data one record at a time, with added graphical elements for easier reading.
10. Print Preview: A document view that shows how your document will look when its printed.
11. Query: In Access, a database object that shows specific data you want to work with. The data may be drawn from multiple related tables, may have several filters applied and may include calculated expressions.
12. Record: Om Access. a set of information that belongs together, such as a customer's name and address information, or details about a product.
13. Record Selector: In access, the gray box at the left side of each record in Data sheet view or in Form view. Click the record selector to select the entire record.
14. Relational Database: A type of database in which information is stored in separate but related tables, which allows for non redundant, more efficient data storage and retrieval.
15. Report: In access, a database object that presents data organized and formatted to your specifications.
16. Table: In Access, a collection of data with the same subject of topic. Data are stored in records (rows) and fields (columns).

Product Endorsements

If i could endorse a product, i would probably want to endorse a clothing brand or company. I'm not really sure which one exactly, but i think that would be cool to do.

Marketing Intro.

McDonald's


McDonald's targets people who are on a tight budget and don't want to spend a lot of money, and also people who are in a hurry. McDonald's marketing mix is that the prices are low, they have many commercials and signs to promote their business, they have a wide variety of foods from burgers, to salads, to chicken, to ice cream and pie, and there are McDonald's everywhere you look it seems like.

Reflection: History Timeline

I think that this process could be effective in teaching younger kids in ways like this, or in a jeopardy format because it can be interactive with them and it can also involve pictures to keep them entertained.

Auto Flyer

I think that my add would catch my attention, but maybe not hold it for long. I would probably glace at it but never read it all the way through. It answers most of my questions, i dont know what they are selling the car. Yes, i think it describes the car well enough and it gives me information about the seller also.