0
A text field can have up to 255 characters Proud to be of service HoloGuides.com
Wiki User
∙ 14y ago
Wiki User
∙ 13y ago64
Add your answer:
Earn +20 pts
How many characters can a field name be up to in access?
It depends on the companies website. The number of characters in a filed for a name could go as high as sixty-four characters. These has always been the number of lengths.
How many characters a table name can have?
Depends on how many characters you got and how many columns it got
Field names can be a maximum of how many characters in length?
Field names can be a maximum of _____ characters in length
What is the linking field in the many table called?
Foreign key field
What is a foreign key in Microsoft Access?
It is a field in one table that is a primary key in another table. It is used to create a relationship between two tables, normally a one to many relationship. The one side is where it is the primary key and where it is the foreign key, that is the many tables.
What is a one-to-many relationship in Access?
The easiest way to create a one-to-many relationship in the Access Relationships window is by first dragging the tables you need onto the grey part of the screen. Theen drag the primary key field of a table onto a field of another table to create a one-to-many relationship. When you release the mouse button over the field in the other table, the "Edit Relationships" will will automatically appear. This window will allow you to create the one-to-many relationship and set referential integrity and cascading rules.
What are the data type available for Access table field?
Access Data Types are : Autonumber, Memo Text, Number, Yes/No, date/time, OLE object, Hyperlink, Currency.
Is a foreign key field always on the one side of a one-to-many relationship between two tables?
No. The foreign key is always on the many side. A foreign key is a field that is a primary key in another table, not in the table it is in. It can therefore be repeated in the table it is, so it can act as the many side. In its own table, it is the primary key, and only appears once.
Does redundancy usually results from placing too many fields ina table in access?
no
How are the different relations in a relational database tied together?
There must be at least one common field in the tables that are related. In simple terms you find a value in that field in one table and then find the corresponding value for that field in another. At least one of them will be unique, like in a one to many relationship. One the one table, that value can appear only once in the table. On the many table it can appear more than once. In a one to one relationship, each can only appear once in each table in the relationship. In a many to many relationship, an intermediate table is set up and two other tables are joined to it.
Why does many to many relationships of Microsoft access not work?
It works exactly as it is meant to. You don't understand how table relationships work.
In access tables names can be up to how many characters in length?
Names can be up to 64 Characters in length. You can find the answer in your text book page AC8 at the top =)
