- Daylin MorganUpdated 21 hours ago
- Daylin MorganUpdated 21 hours ago
- Daylin MorganUpdated 21 hours ago
- Karina J AdumUpdated on Tuesday
- Karina J AdumUpdated on Tuesday
- Karina J AdumUpdated on Tuesday
- Chapter 9-15 Condensed NotesBy Karina J Adum and Daylin Morgan in CIS 105 · Edit Doc
HEY CIS FRIENDS!
I never study, but when I do I prefer doing it this way *Dos Equis commercial voice*
HOW TO DO IT
1. Read the book or full notes ( I know it sucks. Do it) & take all the bold words (keywords) down and set definitions YOU UNDERSTAND to them.....
2. that's it....
The key is to make the definition as small (yet understandable) as possible. (As you can see they're all a line long). It does miracles for your brain. swear.
Chapter Nine- Intro to Access
Field - Smallest data element contained in a table
Record - Complete set of all data elements
Table - Foundation of a database, collection of related records
Database - One or more tables of sorted data
Navigation Pane - Organizes and lists the database objects (tables, macros, forms)
Datasheet View - Grid containing fields & rows like a spreadsheet
Design View - Used to modify table's design specific to fields associated
Primary Key - Field that identifies each record in a table, prevents duplicates
Form - An object that enables you to enter, modify, delete data
Query - Questions you ask about the data in tables of the database
Criterion - Expression used to filter records in a table
Report - Professional formated information from underlying tables & queries
Access Speed - Time measured that it takes the storage device to make the file available
Compact & Repair - This reduces size of database & "backup" makes duplicates
Filter - Displays a subset of records based on specified criteria
Filter by selection - Displays on records that match selected criteria
Filter by Form - Displays table records based on multiple criterion
Comparison Operator- Evaluates relationships between 2 quantities to see if equal or not
Sort - Lists records in a specific sequence
Ascending - In alphabetical order, lowest to highest, descending is reverse
Relationship - Connection between 2 tables using a common field (is efficient)
Relational DB MS - Database management system, manage 2 groups of data w/ rules
Join Lines - Creates relationships between 2 tables using a common field
Foreign Key - Field in one table that is also primary key of another table
ERI - Enforce Referential Integrity, only primary keys can be on related tables
Chapter Ten - Relational Databes and Queries
Table - Sorage location in database that has related information
Calculated Field - Makes value from an expression in ref of 1 or more existing fields
Constant - Unchanging value, birthdate
Date Arithmetic - Process of subracting a constant from a date
CamelCase - Notation used by database developers for field/object/file names
Data Type - Fields have this to determine type of data entered for operations
AutoNumber - Data type automatically increases each time a record is added
Field Property- Characteristic of field that determines how field looks/behaves
Text Data Type - A field with this can store either text or numerical characters
Number Data Type - Stores Numerical Data
Caption Property - Makes readable labels that appear on top row of data sheet view
Validation Rule - Checks the data entered when the user exits the field
Cascade Updated - Related Fields opt so when primary key is modified so are foreign
Cascade Delete - Related Records opt so if primary is deleted, so will in related tables
Indexed Property - Set to yes when primary key is set in access, enables quick sorting
One -to- Many - Made when primary can match many foreign keys in related tables
QueryDesignView - Creates queries, top shows tables, bottomw shows fields/criteria
SimpleQueryWiz - Provides dialog boxes to guid you through query design processes
Select Query - Displays only records that match criteria in Design View
Field Row - In Query Design View shows the field name
Table Row - In QDV displays the data source
Sort Row - In QDV lets you sort in ascending/descending order
Show Row - In QDV controls whether the field will be displayedi n query results
Criteria Row - In QDV sets the rules that dictate which record will be selected
Delimiter - Special character that surrounds criterion's value
Wildcards - Special character that reps 1 or more characters in text value like "*"
Null - Term Access uses for a blank field
QuerySortOrder - Determines the order of records in a query's datasheet view
And Logical Operation - Query results will display on records that match all criteria
Or Logical Operation - Query results will display records that match specific criteria
Not Logical Operation - Returns all records except the specified criteria
Run Command - Run query by using this in the Results group
Multi-Table Query - Contains 2 or more tables, lets you use relationships in databse
Related Tables - Tables that are joined in a relationship using a common field
Chapter Eleven - Customize, Analyze, and Summarize Query Data
Expression - Used to calculate new fields from the values in existing fields
Syntax - Set of rules that Access follows when evaluating expressions
ExpressionBuilder - Tool helps create more complicated expressions
Function - Produces a result based on inputs known as arguments
Argument - Variable/Constant that is needed to make output for a function
PMT function - Monthly loan payment given interest rate, term, original value
IIF function - Evaluates an expression and shows a value if true, another if false
Date formatting - Affects date’s display w/o changing actual underlying value
Date Arithmetic - Creates expressions to calculate lapsed time
DatePart Function - Enables you to isolate a specific part of a date, like the year
AggregateFunction - Perform calculations on full column of data to give 1 single value
Total Row - Displayed as last row on datasheet view to show totals
Total Query - Has extra row in querydesign grid and displays aggregate data
Chapter Twelve - Creating and Using Professional Forms and Reports
Form - Has extra row in querydesign grid and displays aggregate data
Record Source - Table/Query that supplies the records for a form/report
StackedLayout - Displays fields in vertical column, one record at a time
TabularLayout - Shows records horizontally, labels across top, data values in rows
Layout View - Can modify design of form with this
Split Form - Combines two views of same record source
Splitter Bar - Divides form into 2 halves
MultipleItemsForm - Displays many records in tabular layout similar to data sheet view
Datasheet form - Replica of table/query’s datasheet view, but holds form properties
VBA - Visual Basic for Apps, MO programming language in all products
Layout Control - Has guides to help keep controls aligned and give uniform look
Office Theme - Defined set of colors, fonts, graphics to apply to forms
Form Header Sect - Displays at the top of each form
Detail Section - Displays records in the form’s record source
Form Footer Sect - Displays at the bottom of the form
Form View - Use this to add edit delete data in a form
Text Box Control - Displays data found in a form’s record source
Label Control - Literal word/phrase describes the data
Bound Control - Text box that is connected to a field in table/query
Unbound Control - Label or other design element not connected to data source
Calculated Control- expression that generates calculated result displayed in Form View
Report - Printed document displays information from database
Report Tool - Used to create tabular reports based on table/query selected
Report Wizard - Asks you questions then uses answers to generate a report
Label Wizard - Create mailing labels, specialized tags
Mailing Label - Specialized report that comes pre-formatted to coordinate w/ stuff
ReportHeader - Prints at beginning of each report
PageHeader - Appears at top of each page
Detail Section - prints one line for each record in report’s record source
PageFooter Section - Appears at bottom of each page
GroupHeader Section - Appears just above detail section in design view
GroupFooter Section - Appears just below Detail section in design view
Print Preview See what report will look when printed
Report View See what a printed report will look on continuous page layout
Chapter Thirteen - PivotTables and PivotCharts
Data Mining - Process of analyzing large volumes of data to see patterns/trends
PivotTable - Data summary tool that can sort/filter/total data in table/query
DropZone - Area in PivTable where you drop fields to organize data
Row Field - Data source that you use to group data horizontally into rows
Column Field - Data source field that you use to vertically align groups of data
Detail Field - Holds the data to be analyzed
Drill Buttons - Enable you to expand the details for that particular group
Filter Field - Data source field that is used to make specific criteria to filter data
Aggregate Funct - Provides summarized view of a set of detail records
AutoCalc Tool - Apply aggregate functions using this tool
Column Chart - Default chart, displays quantitative data in vertical columns
Bar Chart - Displays quantitative data in horizontal bars
Line Chart - Displays continuous data over time, ideal for trends in data
Smoothline Chart - Like line chart, shows trends over time, but lines are curved
Area Chart - Like line chart, except that area below line is shaded
ScatterPlot Chart - Plotted points where coordinates rep values (variables) in data
Pie Chart - Displays 2+ categories in a data source as slices of a pie
Doughnut Chart - Shows parts of a data source in relationship to a whole
Plot Area - Rectangular area where graphical data are located
Series - Represented in different colors or patterns when in charts
Axes - Main vertical/horizontal scales that show value of the data plotted
Gridline - LIne that runs horiz/vertic across plot area to help reader w/ chart
Legend - Tells which color &/or pattern represents each data series
Chart Filter - Lets user narrow data source to isolate portion of a whole
CalculatedDetail - Field that generates new field based on values in details record
CalculatedTotal - Field generates new field based on values in the aggregate data
Chapter Fourteen - Advanced Queries
Action Query - Adds, edits, deletes data in database
Update Query - Changes data values in fields for all records that have same criteria
Append Query - Gets records from 1 or more tables, adds them to existing tables
MakeTable Query - Selects records from 1 or more tables, uses them to create a new 1
Delete Query - Selects records from a table then removes them from that table
Parent Record - Stored in 1 table in a one-to-many relationship
Child Record - Stored in a “many” table in a one-to-many relationship
Parameter Query - Select query where user provides the criterion at run time
Crosstab Query - Summarizes data into grid: intersections show aggregate data
Row Headings - Displays field values along the left side of a crosstab query
Column Headings - Displays field values along the top of a crosstab query
FindUnmatched - Query compares records, shows records found in 1, not in other
FindDuplicate - Query helps you identify duplicate values in a table
Chapter Fifteen - Using Macros and SQL in Access
Macro - Series of actions that can be programmed to automate tasks
StandAlone Macro - Created to be used independently from other controls or objects
Embedded Macro - Executes when an event attached to a control or object occurs
Event - When a user enters/edits/deletes data or opens/uses report/form
MacroBuilder - Enables you to create/edit macros
Argument - Expression needed to produce output for an action
SQL - Structured Query Language, industry standard for using database
Developed by IBM, Language for defining, manipulating data
SelectStatement - Is used to retrieve data from tables in database
SELECTkeyword - Instructs Access to return the specific fields from 1 or + tables
FROMkeyword - Specifies the table that will be searched
WHEREkeyword - Specifies criteria that records must match to be included in results
ORDERBYkeyword - Used to sort records by field in either ascending/descending order
Open flow potential : The calculated maximum flow rate that a system may provide in the absence of restrictions. The term may be qualified as relating to a specific zone, such as a perforated interval or be used in referring to the production capability of the well.
Openhole completion : A well completion that has no casing or liner set across the reservoir formation, allowing the produced fluids to flow directly into the wellbore. This type of completion suffers the major disadvantage that the sandface is unsupported and may collapse. Also, without any casing or liner installed, selective treatments or remedial work within the reservoir section are more difficult.
Openhole gravel pack : A type of sand-control completion in which the gravel pack screen is packed off in an openhole section with no casing or liner to support the producing formation. The openhole interval is often prepared by underreaming a section of reservoir below the last casing shoe. When the treatment is to be applied on an existing well, a section of casing may be milled out.
Openhole packer : A type of packer designed for use in openhole applications such as drillstem testing. Openhole packers are typically configured with one large element that can be deformed easily to contact the uneven formation surface, yet retain strength and sufficient integrity to withstand the anticipated differential pressures.
Openhole test : A drillstem test performed in an openhole section of the wellbore. The test once was a popular method of assessing the productivity of exploration wells without the need to run casing or liner across the reservoir interval. Openhole testing now is less common because of the risks and limits associated with fluid flow from an unsupported formation.
Opening bomb : A device used in stage cementing to open the stage collar or diverting valve through which the second or subsequent cement stage is placed. The opening bomb is dropped down the casing string to land in a seat within the stage collar. Applying pump pressure then activates a sliding collar that opens access ports, enabling circulation across the upper casing interval.
Operating gas-lift valve (OGLV) : The lowermost gas-lift valve in a gas-lift completion through which the lift gas is injected during normal production. During startup, the upper gas-lift valves open in sequence, from the top down, to enable the tubing fluids to be displaced. At predetermined pressures, each of the upper valves closes to eventually route all lift gas through the operating valve, which is placed at the optimal depth for the reservoir and completion conditions.
Orifice valve : A type of valve, typically found on small-diameter pipework, that incorporates an orifice or flow-restriction device to control fluid flow.
O-ring : A type of circular seal commonly found in downhole tools and a wide range of surface equipment applications. The specification of O-ring material depends on the conditions for which the seal is intended, such as system operating temperature and pressure. Various backup systems are used to support the O-ring seal in either dynamic or static sealing applications.
Oxygen scavenger : A chemical agent used in some brines and completion fluids to reduce corrosion resulting from, or exacerbated by, dissolved oxygen. Oxygen scavengers capture the dissolved oxygen in a harmless chemical reaction that renders the oxygen unavailable for corrosive reactions. The use of oxygen scavengers is more critical in applications in which fluids are to be circulated in the wellbore. Additional oxygen may be dissolved during agitation at surface.
Pack off : To effect hydraulic isolation, either with a sealing device, such as a packer, or with a specialized plastic or fluid, such as a sealing compound.
Packer : A downhole device used in almost every completion to isolate the annulus from the production conduit, enabling controlled production, injection or treatment. A typical packer assembly incorporates a means of securing the packer against the casing or liner wall, such as a slip arrangement, and a means of creating a reliable hydraulic seal to isolate the annulus, typically by means of an expandable elastomeric element. Packers are classified by application, setting method and possible retrievability.
Packer fluid : The fluid that remains in the tubing-casing annulus above the packer after the completion has been run and all circulation devices have been isolated. Packer fluids are prepared for the requirements of the given completion. Generally, they should be of sufficient density to control the producing formation, be solids-free and resistant to viscosity changes over long periods of time, and be noncorrosive to the wellbore and completion components.
Packing gland : A device used to seal around a reciprocating or rotating shaft or spindle. A malleable packing compound is forced into place by an adjustable packing nut, or similar arrangement. This enables the seal or packing to be tightened to suit the operating conditions and allows subsequent adjustment to account for wear.
Paraffin : A hydrocarbon compound that often precipitates on production components as a result of the changing temperatures and pressures within the production system. Heavy paraffins occur as wax-like substances that may build up on the completion components and may, if severe, restrict production. Paraffin is normally found in the tubing close to surface. Nevertheless, it can form at the perforations, or even inside the formation, especially in depleted reservoirs or reservoirs under gas-cycling conditions.s subsequent adjustment to account for wear.
Perforating acid : An acid treatment placed in the wellbore over the interval to be perforated. Because of the overbalance conditions at the time of perforating, the perforating acid is forced into the newly formed perforation tunnel to stimulate the crushed zone. Formulation of the perforating acid depends on the characteristics of the formation and the downhole equipment used.
Perforating fluid : A specially prepared fluid placed in the wellbore over the interval to be perforated. The ideal fluid is clean and solids-free (filtered), and will not react to cause damaging by-products on contact with the reservoir formation. Perforating in a dirty fluid may result in significant permeability damage that is difficult to treat and remove.
Pipe stretch : The increase in length resulting from the combination of forces acting on a string within the wellbore. The principal factors resulting in an increase in string length are the weight of the string itself and the effects of thermal expansion.
Plug and abandon : To prepare a wellbore to be shut in and permanently isolated. There are typically regulatory requirements associated with the P&A process to ensure that strata, particularly freshwater aquifers, are adequately isolated. In most cases, a series of cement plugs is set in the wellbore, with an inflow or integrity test made at each stage to confirm hydraulic isolation.
Plunger lift : An artificial-lift method principally used in gas wells to unload relatively small volumes of liquid. An automated system mounted on the wellhead controls the well on an intermittent flow regime. When the well is shut-in, a plunger is dropped down the production string. When the control system opens the well for production, the plunger and a column of fluid are carried up the tubing string. The surface receiving mechanism detects the plunger when it arrives at surface and, through the control system, prepares for the next cycle.
Polished joint : A generic term for a completion component that has been polished or prepared to enable an efficient hydraulic seal. The polished joint may have an internal or external polished surface and is typically configured in a length that enables some movement of the completion string or associated components without compromising the hydraulic seal.
Polished rod : The uppermost joint in the string of sucker rods used in a rod pump artificial-lift system. The polished rod enables an efficient hydraulic seal to be made around the reciprocating rod string.
Pore pressure : The pressure within the reservoir rock. The formation pressure value can be further categorized as relating to flowing well or shut-in conditions.
Positive displacement pump : A type of fluid pump in which the displacement volume of the pump is fixed for each rotation of the pump. Generally associated with high-pressure applications, positive-displacement pumps are commonly used in drilling operations to circulate the drilling fluid and in a range of oil and gas well treatments, such as cementing, matrix treatments and hydraulic fracturing.
Premium thread : A class of high-performance thread types that are commonly used in modern oilwell and gaswell completions. Premium threads are available in a number of configurations and are typically designed to provide superior hydraulic sealing, improved tensile capacity and ease of make-up. Unlike conventional threads, the sealing areas in premium thread connections are independent of the thread profile and are included as two or three areas within the tool joint, thereby providing some redundancy.
Pressure buildup analysis : An analysis of data obtained from measurements of the bottomhole pressure in a well that is shut-in after a flow period. The profile created on a plot of pressure against time is used with mathematical reservoir models to assess the extent and characteristics of the reservoir and the near-wellbore area.
Pressure drawdown : The differential pressure that drives fluids from the reservoir into the wellbore. The drawdown, and therefore the production rate, of a producing interval is typically controlled by surface chokes. Reservoir conditions, such as the tendency to produce sand, may limit the drawdown that may be safely applied during production before damage or unwanted sand production occurs.
Pressure transient test : A means of assessing reservoir performance by measuring flow rates and pressures under a range of flowing conditions and applying the data to a mathematical model. Fundamental data relating to the interval under test, such as reservoir height and details of the reservoir fluids, are also input. The resulting outputs typically include an assessment of reservoir permeability, the flow capacity of the reservoir and any damage that may be restricting productivity.
Primary cementing : The process of placing a cement sheath around a casing or liner string. The main objectives of primary cementing operations include zonal isolation to prevent migration of fluids in the annulus, support for the casing or liner string, and protection of the casing string from corrosive formation fluids.
Primary completion components : The main elements of an oil or gas well, including the production tubing string, that enable a particular type or design of completion to function as designed. The primary completion components depend largely on the completion type, such as the pump and motor assemblies in an electrical submersible pump completion.
Primary recovery method : The means by which the initial reservoir production is achieved, such as natural production from a gas-drive reservoir. In many cases, a secondary recovery method, such as waterflood, is required to maintain a viable reservoir production rate.
Production casing : A casing string that is set across the reservoir interval and within which the primary completion components are installed.
Production packer : A device used to isolate the annulus and anchor or secure the bottom of the production tubing string. A range of production packer designs is available to suit the wellbore geometry and production characteristics of the reservoir fluids.
Production wing : The portion of a Christmas tree or surface production facility through which production fluids flow. The production wing typically includes a wing valve and a choke to control or isolate flow from the wellbore.
Productivity Index (PI) : A mathematical means of expressing the ability of a reservoir to deliver fluids to the wellbore. The PI is usually stated as the volume delivered per psi of drawdown at the sandface (bbl/d/psi).
Profile modification : The process of controlling undesirable water production from a well by conducting treatments to prevent coning or cresting. A range of treatment options is available for profile modification applications, most of which are designed to reduce the permeability of the water-bearing zones to encourage preferential flow from the oil-bearing formation. The injection of polymers, or similar chemicals, that form a rigid gel within the formation matrix is a common treatment.