Excel Review
Software systems used to store, retrieve, and run queries on data
What is Database Management Systems (DBMS)?
The default file exention for Databases assigned by SQLite
What is .db?
The SQL command used to insert data into a give table WITHOUT ALTERING the table columns themself?
What is INSERT INTO?
A summary of a large dataset that usually includes the total figures average, minimu, maximum, etc.
What is a Pivot Table?
The NULL value is a ____, but not a _____.
The default file extention for PROJECTS assigned by SQLite
What is .sqbpro?
The data type most suitable for use with Primary Keys?
What is Integer data type?
Shortcut is F4. Symbolized in Excel using the $
Absolute Cell Reference
Would be the data type to store 00005 while ensuring all digits are maintained?
The required file extension when importing tables from Excel files into CSV Files
What is Comma Separated Value Files (.csv)?
The statement is used to return only distinct (different) values from a table.
What is the SELECT DISTINCT function?
The four types of Excel Functions covered in this program
What is Mathematic, Logical, Statistical, and Reference?
The BLOB Storage Class can hold up to how many bytes of data?
What is up to 65,535 bytes of data?
Saves changes made to a Database File using the ___ command, saves changes made to a Project File using the ___ command, saves changes made to all open Database/Project Files using the ___ command
What is Write Changes, Save Project, Save All?
The IN statement is most commonly used in conjunction with what this statement (and it's negative)
What is WHERE/WHERE NOT?
Defined by the formula
= ____(lookup_value, table_array, col_index_num, [range_lookup])
What is the VLOOKUP function?
The five storage classes used in SQLite
What is Null, Integer, Real, Text, and Blob?
When creating large-scale data projects, the command under the FILE menu for linking together multiple databases under a single project
What is FILE > Attach Database...?
The _____ is used when you want to return only records having pair on both sides, and you’ll use _____ when you need all records from the first table called in the statement, no matter if they have pair in the “right” table or not.
What is INNER JOIN, LEFT JOIN?