DATABASE BASICS
What is a database basic?
What is a software that interacts with end users, applications, and the database itself to capture and analyze the data and provides facilities to administer the database?
What is a Query?
What is an object in access that provides a spreadsheet-like view of data similar to a table?
What is the purpose of a relationship?
They are used to show the similarities among one or more tables.
What does HTML stand for?
What is Hyper Text Markup Language?
Name three popular search engines?
What is Google, Bing, and Yahoo?
What is the purpose of a database?
What is helpful for storing and organizing an abundant amount if information?
What are three general queries?
What category does choosing parameters from a menu, query by example, and query language fall under?
What is an example of a relationship in a database.
Game modifications and the default game.
What are three examples of web basic concepts?
What are Internet, General programming, and designing the web?
What is the number one search engine?
What is Google?
What are the parts of an access database?
What are tables, forms, reports, queries, macros, modules?
What kind of information do queries combine?
What uses data from tables to present one specific topic or area?
What do relationships allow databases to do?
To split and store data in different tables, while linking disparate data items.
What are some basic services available to the public?
What is HTTP, WWW and URL?
What are the dangers of using search engines?
What can mislead a person using the computer and can direct a person to website with malware which may damage the computer and may even possibly slow it down?
What is a "one-to-one" database?
When does one table have the relationship with another table having the similar kind of column and each primary key relates to only one or no record in the related table?
Is a Query found in your search history or your browser history?
What is found in your search history and cannot be confused with browser history?
Describe the difference between an operational database and an analytical database.
one-to-many relationships is where one record from one table may be related to many records in the second table.
How can you copy a link from a web page?
What is right clicking the URL in the top box containing the web page then selecting copy to copy into the clipboard for?
What makes a good Search Engine?
What are Relevant results, Uncluttered interface, and helpful options to broaden or tighten a search?
Describe the difference between an operational database and an analytical database?
Define an operational database that is used in day-to-day business operations, while a another database is a collection of data that will be used for spotting trends that offer insights for tactical and strategic business decisions.
What do Queries allow us to do in Microsoft Access?
What allows us to update information, delete records, or retrieve and filter data?
To create a one-to-many relationship, what do you need to make sure is checked in the tables that you want a relationship with each other?
What is a Primary Key?
What does WWW stand for?
What is World Wide Web
What are the four components of a search engine?
What is a Web Crawler, Indexer, Database, Query processor?