ISTM 210 TAMU Phinney Exam III, Access Terms With Solutions 100% Correct
0 view 0 purchase
Course
ISTM 210
Institution
ISTM 210
ISTM 210 TAMU Phinney Exam III, Access
Terms With Solutions 100% Correct
When the data from two tables are associated, we say there is a________ between the tables.
Relationship
What is an entity? Database tables store information about specific things called entities.
Customers in a table...
ISTM 210 TAMU Phinney Exam III, Access
Terms With Solutions 100% Correct
When the data from two tables are associated, we say there is a________ between the tables.
Relationship
What is an entity? Database tables store information about specific things called entities.
Customers in a table would be an entity in the database.
What is a record and where is it stored The collection of information you have for an
instance of an entity is called a record. Records are stored in the rows of tables.
What is an attribute? Data stored for each database record is an attribute. Attributes are
stored in the columns of tables. In the case of our customer table; first and last name, email
address, and the elements of the physical address are all attributes.
Access refers to the attributes of a table as ______? Fields
Does access let you use spaces in your field names? Yes, but not recommended
, ISTM 210 TAMU Phinney Exam III, Access
Terms With Solutions 100% Correct
Short text is limited to how many characters? 225
Long text is limited to how many characters? 65,536
What does field size change? It determines how large a field will be
What does an input mask do? This is used to set rules for how the data will be entered for
the field. For example, you can use an input mask to make sure that users enter 10 digits for a
telephone number.
The default value is used for what? It is used to have Access automatically set a starting
value for a field when a new record is added to the table.
What is a validation rule They are used to have Access check values when they are
entered into a table to make sure they fit a specific rule. For example, you could use a validation
rule to make sure that all of the values entered into a field are greater than 10.
A required rule is used to? Make sure something is entered in a field
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller UpperClass. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $14.49. You're not tied to anything after your purchase.
