Database Basic
What is a field and/or record?
What is a database?
Fields and records related with others because the stored data and tabled for same subject.
What are the store in field and records ?
True or False: Can you modify data in a table?
True
An object in access that provides a spreadsheet-like view of data similar to a table.Â
What is a Query?
The relationship between two tables in Access where a common field links the tables together. The linking field is called the primary key field in the “one†table of the relationship and the foreign key field in the “many†table of the relationship.
What is a one-to-many relationships?
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 database basic?
It's a structure of data held in a computer.
write the difference between filed and records?
A database table is composed of records and fields that hold data. Tables are also called datasheets. Each table in a database holds data about a different, but related, subject.
What is a database table?
A query answers a question about the information in the database.
What is the purpose of a query?
one-to-one, one-to-many, many-to-many
What three types of relationships are there in Microsoft Access?
It is used to manage data that is organized into lists, such as information about customers, products, vendors, employees, projects, or sales.
What is Rational database used for?
A single set of data.
What makes up a field in a computer's database?
Their names must be unique.
What is a requirement for tables?
A data source is a stored set of information that allows Excel and Microsoft Query to connect to an external database
What is a query in Excel?
Click on the “Database Tools†ribbon, go to the relationships section and then click on the tab called “relationshipsâ€. You will then choose the table to connect relationship with one another as you drag the title to the title is relates to.
How do you create a relationship between two tables?
It's a structure of data held in a computer.
What is the main definition of Database Basics?
Can be used as a way to organize records in a particular order and provide a section before and after each group of records.
What is Grouping
Click Insert > Tables > Insert Table from the dropdown menu. In the Insert Table dialog box, enter the number of columns and rows you want in thistable (four columns and five rows).
How would you inserted a table Microsoft word?
What is a function of queries?
To retrieve data from a table or make calculations
 A context of database is a situation that exists between two relational databases tables.
What are relationships on the computers?
It opens in datasheet view
What happens when you double click a Table, Queries, Reports, etc.
You right click the top of the field or the left of the record where the grid starts and click on "delete record/field" with the red "x".
How do you delete a field or record?
 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
what is
d) all of the above
By selecting the create tab on the ribbon and locating the queries group.
What is create a query?
Game modifications and the default game.
What is an example of a relationship in a database.