ISTM 210 Study guides, Class notes & Summaries

ISTM 210 - Exam 3 Review (HTML and Chapters 11, 12, 13, and 14) 100% Correct <h#></h#> Heading - Starts a section, smaller number is larger text (1-6) <p></p> Starts and ends a paragraph <ul></ul> Bullet (unordered) list <li></li> List item <hr /> Horizontal rule; no closing tag; can be measured in width or px (do not need to specify px (automatically assumed)). Can have color. <b></b> Bold <i></...

ISTM 210 Exam 3 Phinney with Complete Solutions tables used to store the data in Access. A table consists of columns, which store data fields, and rows, which store database records queries used to find the specific data you need from the database forms present the data in a table in a separate window one record at a time reports allow you to organize and present the data in your database Database Management Systems (DBMS) -The software systems used to create databases -First...

Who used carrier pigeons to get news and stocks from Belgium to Germany? - Reuters What was the first way the world connected? - The Telegraph The study, design, development, implementation, support, and management of computer-based information systems, particularly software and hardware - Information Technology (IT) Who is in charge of all computer assets for an organization? - Chief Information Officer (CIO) The knowledge that enables a person to understand something - Competency ...

Information Technology - the study, design, development, implementation, support, and management of computer-based information systems, particularly software and hardware. End-Users - People that use computers Competency - The knowledge that enables a person to understand something, in this case, a computing system and its relationship to business Critical thinking - A way of thinking that involves analysis and evaluation and includes considering all possible outcomes in order to form a...

Father of Intel - Gordon Moore 1965 Information Technology (IT) - study, design, development, implementation, support, and management of computer-based information systems, particularly software and hardware. YES - is IT technology (Information Technology) a core compentency end-users - People that use computers. Sarbanes-Oxley Act of 2002 - attempts to protect investors from accounting and reporting fraud Competency - knowledge that enables a person to understand something, in th...

Phinney's Fav formula - CONCATENATE CONCATENATE function - CONCATENATE (text1,[text2],...) - combines blocks of text SEARCH function - NOT case sensitive COUNT function - A function that determines how many cells in a range contain a number. Workbook - excel file that stores all information, calculations, and analyses. Worksheet - A computerized spreadsheet in Excel. Cells - store individual pieces of data/collections Cell Address - The name of the cell is determined by the...

RATE - calculates the interest rate earned for an investment given the number of payments made as part of the investment, the payment amount, and the current value of the investment. (nper, pmt, pv, [fv], [type], [guess]) =RATE(Number of Payments, Monthly Payment Amount, Loan Amount)*12 EFFECT - calculates the annual percentage rate for an interest rate given the number of times per year that interest is charged. (nominal_rate, npery) =effect(Interest Rate, Number of Payments per ...

Chapter 11 Prometheus - Learning Forms What are databases best at doing? - Storing data What is Microsoft access? - A database application What is the company prometheus pulls a lot of data from and what does it do? - QuickStove, LLC, a small company that sells emergency preparedness and backpacking equipment What are the 4 types of objects in access, and what is each's function? - Tables- are used to store the data in Access Queries-are used to find the specific data you need from...

Google, DropBox, and Microsoft are company examples of what type of providers? - Cloud Service Providers (CSP) Using data visualization instead of _______________________, makes business programming much easier to understand. - Structured Query Language (SQL) Business Intelligence - Can be described as computer applications that change data into significant, meaningful information that helps organizations make better decisions. A well thought-out collection of computer files - Database ...

object view - displays finished object design view - edit the object layout view - easier to use what is a technical term for a table? - relation database tables store information for specific things, called _______ - entities record - collection of information you have for an entity, stored in the rows of tables attribute - AKA fields, data stored for each database record, stored in the columns of tables database table - collection of records that have all the same attribut...