Fields and Records
What is the definition for Database
a collection of organized data that allows access, retrieval, and use of data
What is a Query?
An object in access that provides a spreadsheet-like view of data similar to a table.
What is a table?
A) a tool for collecting and organizing information
B) a place where you sit down and eat
C) user interface in which you can enter and edit your data
D) an object of a database which is used to hold data used in reports and applications
What is the purpose of a relationship?
They are used to show the similarities among one or more tables.
What is a website?
A collection of various pages written in HTML markup language
What is a database?
A set of data held in a computer that can be access in different ways.
What is a query in Excel?
A data source is a stored set of information that allows Excel and Microsoft Query to connect to an external database
What data can be put in tables in Access?
a) A company’s customers and their addresses
b) A list of products a company would sell
c) Track customer orders
d) all of the above
d) all of the above
What are relationships in Access?
A relational database is Access. The data in one table is related to the data in other tables. Generally speaking, tables can be related in one of three different ways: The relationship is used to cross reference information between tables.
TRUE/FALSE is the Web considered the Internet?
FALSE
What is a database useful for?
A database is useful for searching functionality such as sales department could bring up results in a fast manner
Is a Query found in your search history or your browser history?
A query is found in your search history, it cannot be confused with browser history because that is the history of the websites you've been to not the questions you've asked.
Why are Tables a crucial part of Excel?
Tables are crucial to Excel because they are a series of rows and columns in a worksheet that contains related data. Basically a table is a block of cells with rows and columns. Without these tables, there would be nowhere to input data.
What do relationships allow databases to do?
To split and store data in different tables, while linking disparate data items.
Which of the following have an emphasis on content?
a) The Internet
b) CSS
c) The Web
d) HTML
c) The Web
What is Database and what is it used in everyday?
Database is a storage unit that is used for most online equipment like sports, social gaming, competitive gaming, twitter and social media.
What are database queries?
A query is a request for data or information from a database table or combination of tables. This data may be generated as results returned by Structured Query Language (SQL) or as pictorials, graphs or complex results, e.g., trend analyses from data-mining tools.
What is difference between database and table?
A database is a collection of several components like tables, indexes, stored procedures and so on. A table is a two dimensional structure that contains several columns and rows. It is contains all the data in form of several records.
Name a few databases that a relationship can be used in?
A few databases that a relationship can be used in is a graph database, a relational database, a multidimensional database, an object database, and a document oriented database.
What is web basics and what is it used for?
web basics is like using programs like the news, email, and the world wide web
What are the main subject that related with database ?
Answer:Store various data.A relational database at its simplest is a set of tables used for storing data. Each table has a unique name and may relate to one or more other tables in the database through common values.The two things records and table main things for database.
Records:Data is stored in records. A record is composed of fields and contains all the data about one particular person, company, or item in a database. In this database, a record contains the data for one customer support incident report. Records appear as rows in the database table.
Field:A field is part of a record and contains a single piece of data for the subject of the record. In the database table illustrated in Figure 4, each record contains four fields:
What are three general queries?
1.Choosing parameters from a menu
2.Query by example
3.Query language
If a table labeled customers, and a second table labeled orders were available to you how would you organize it to present the customer to their order?
first thing would be to open the create ribbon on top then click on query wizard in the queries box an proceed to select each table an finalizing the selection.
What are the 3 types of relationships in a database?
One-to-one: Both tables can have only one record on either side of the relationship.
One-to-many: The primary key table contains only one record that relates to none, one, or many records in the related table.
Many-to-many: Each record in both tables can relate to any number of records (or no records) in the other table.
What are the types of Web technologies?
Introduction: In order to make websites look and function a certain way, web developers utilize different languages.
Markup Languages
Hypertext
Hypertext Markup Language (HTML)
Hypertext Transfer Protocol (HTTP)
Cascading Stylesheets (CSS)
Types of CSS
Web Design Programs