NEW
Font size
WorksheetsAccess Database relationships
Total questions: 25
Worksheet time: 13mins
It is a type of special value that indicates that that row, that column does not contain any value, which we can find
0 Value
Null value
Numeric value
Alphanumeric value
It allows to unequivocally identify each row in the table, so there cannot be two rows with the same value in a table.
Foreign key
Modified key
Primary key
None of the above
It is the association that can be made between entities or tables.
Table
Record
Database
Relationship
It is one of the relationships in which the entities intervene and is associated one by one.
One to many
Many to one
One by one
Many to many
In the following figure, what part of the entity-related model does it represent?
Relationship
Decision
Entity
Cardinality
What are the views that Microsoft Access has?
Normal and data sheet
Print and design
Design and data sheet
Read only and datasheet
To modify the design of a table from the design view we must follow the steps:
ight click on the base - Select Table - Design view - Place in the field
Right click on the table - Select Design view - Place yourself in the field to be modified
Left click on the table - Select Design view - Place yourself in the field to modify
None of the above
When modifying the structure of the Data Table, in a field, can we change the data type from short text to numeric without losing information?
True
False
The Datasheet View serves me mainly to:
Enter and modify data in a record
Enter and modify data in a database
Enter and modify data in a table
None of the above
In the following figure. The Bar that is shown helps me to move in all the records of the database.
Status bar
scrollbar
Design bar
Datasheet bar
It is one of the relationships in which the entities intervene and is associated one by one.
One to many
Many to one
One by one
Many to many
A database contains a Customer table. What would be stored in a record of the Customer table?
Information about one customer
Information about all the customers
Information about one order
Information about every order
Why does data inside a database need to be organized?
So the data is neat and tidy
So data integrity can be maintained
So the data can be searched from the Internet
So the data can be found when needed
You discover many errors in a database table. What has been lost?
Data Integrity
Database Management System
Fields and Records
Primary Key
In a Table, a row is known as a ...
record.
garden.
field.
area.
