0
What else can I help you with?
In access to create a relationship between two tables the two connected fields must have the same what?
Primary key
What is displayed in the three row grid in the middle of the edit relationships window?
the common fields to be used to join the tables
How many fields does a database have?
Modern databases do not have a preset number of fields. Rather, the data architect determines the needed tables and number of fields per table and declares that to the database software. Fields can--with some restrictions--also be added and removed later as needed. That said, each database application does have a maximum limit on the number of fields per table and the number of tables per database, which information has to come from the database manufacturer. But those limits are usually vastly greater than anyone might want. It is part of a computer and it has many fields.
How do related tables improve the accuracy of a data in a database?
In short, they do not. Relating tables in a database defines the relationships between the data sets in the different tables and allows the data to be accessed more efficiently, but it does not affect the accuracy of the data entered.
What is the rounding tables?
Rounding tables are tools used to simplify numbers by rounding them to a specific place value, such as the nearest whole number, tenth, or hundredth. They provide a quick reference for determining rounded values, making calculations easier and faster, especially in fields like mathematics, finance, and science. These tables can help visualize how rounding affects numbers and facilitate estimation in various applications.
What is A line that Access draws between matching fields in two tables?
Join Line
What is a line that is drawn between matching fields in two related tables?
Join Line
Find records in two tables that have identical values in the matching fields?
join
In access to create a relationship between two tables the two connected fields must have the same what?
Primary key
What is the process of finding records in two tables with identical values in matching fields?
inner join
What do you mean about schema in RDBMS?
In a relational database, the schema defines the tables, the fields in each table, and the relationships between fields and tables.
What Are words that have a special meaning to Access and cannot be used for the names of fields or tables?
Reserved words!
What word or words have special meaning to Access and can not be used as names of fields or tables?
Reserved Words
What is the database that contains tables linked by common fields?
A relational database is a database that contains tables linked by common fields. These common fields are used to establish connections between the tables and to retrieve related data across multiple tables using queries.
Line between selected fields in two tables?
join line
Are reserved words the words that have a special meaning to Access and cannot be used for the names of fields or tables?
Yes.
How many relations may exist between two tables in a MS Access database?
only one relationship can exists between two tables in the MS ACCESS software
