0
Add your answer:
Earn +20 pts
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.
How many tables measuring 152cm can you fit into a marquee 26' x 65'?
It is not possible to answer this question with the information available. Both, the length and the breadth of the table are required. Also, presumably, the answer required is for a scenario where there is room to sit around the tables, move between tables etc. That is not quite the same as the number of tables that can be fitted into a marquee.
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.
Are reserved words the words that have a special meaning to Access and cannot be used for the names of fields or tables?
Yes.
Line between selected fields in two tables?
join line
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
