Exam (elaborations)
MISY 5325 EXAM QUESTIONS AND ANSWERS
- Course
- Institution
MISY 5325 EXAM QUESTIONS AND ANSWERS
[Show more]
Content preview
MISY 5325 EXAM QUESTIONS AND ANSWERS.accdb - answer - access database
True or False: By default the database will automatically create Report 1. - answer - False
It will automatically create Table 1
What are the objects in the Create Tab in Access? - answer - Table
Queries
Forms
Reports
Macros & Code
Table object - answer - used to store data
Query object - answer - used to retrieve data from the table efficiently
Forms object - answer - used to interact with data in table to either add data, modify data, or delete data
Report object - answer - used to present data neatly
Macros object - answer - is a series of programming that allows us to run or execute any objects.
True or False: Data Type Short Text can store any characters that are shorter than 245 characters - answer - False
shorter than 255 characters
True or False
Data Type Long Text can store an unlimited amount of characters - answer - True
True or False
Data Type Number can store only number data but can not be calculated - answer - False stores only number and can be calculated
True or False
Data Type Date/Time can store data about time or date - answer - True
True or False Data Type Currency is similar to number except that ti will be formatted with 2 decimal place, dollar sign, and 1000 comma separator. - answer - True
True or False
Data Type Auto Number you will have to manually generate a number - answer - False
number will automatically generate
True or False: Data Type Yes/No can store only three pairs of data - answer - False
can store only two pairs of data "Yes or No" and " True or False"
True or False
Data Type OLE Object can store image files that are Bitmap - answer - True
The Data Type Hyperlink can store - answer - the URL address of a website
The Data Type Attachment can store - answer - a file
The Data Type Calculate will - answer - calculate and store data for the filed using data from other fields in the table.
Primary Key serves as a - answer - unique identifies for a record in each table.
True or False
As a Primary Key no more that two records can have the same data for that field - answer - False
no more than one record can have the same data for that field
**True or False
A table can have more than one Primary Key - answer - False
It can only have one Primary Key
**True or False
One Primary Key can consist of two or more attributes or fields - answer - True
True or False
In Access you can auto fit the column and row - answer - False
you can only auto fit the column
The Design View is used to - answer - create fields for the table
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 GEEKA. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
73243 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now