How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask TechGuy Your Own Question

TechGuy
TechGuy, Computer Hardware Engineer
Category: Computer
Satisfied Customers: 577
Experience:  MCSE, CCEA, A+
Type Your Computer Question Here...
TechGuy is online now
A new question is answered every 9 seconds

Multiple Choice Answers! 1. (TCO 1) Which sequence represents

Customer Question

Multiple Choice Answers! <br />1. (TCO 1) Which sequence represents the hierarchy of terms from smallest to largest?          Database, table, record, field          Field, record, table, database          Record, field, table, database          Field, record, database, table <br />   2. (TCO 2) Consider the following tables and relationships: CustomerTable CustomerID (PK) LastName Firstname Address CityID (FK) CityTable CityID (PK) CityName OrderTable OrderID (PK) OrderDate CustomerID (FK) OrderProductTable OrderID (PK)(FK) ProductID(PK) (FK) Quantity Price ProductTable ProductID (PK) ProductDescription Which of the following describes a one-to-many relationship as it exists in the tables shown above?          Each city can be associated with only one customer, but a customer can be associated with many cities.          Each customer can be associated with only one city, but a city can be associated with many customers.          Each Customer can be associated with only one order, but an order can be associated with many different customers          Each product can be associated with only one order, but each order can have many products.    <br />3. (TCO 3) Which of the following is true with respect to an individual's hire date and years of service, both of which appear on a query that is based on an employee table?           Hire date should be a calculated field; years of service should be a stored field.          Hire date should be a stored field; years of service should be a calculated field.          Both should be stored fields.          Both should be calculated fields.    <br />4. (TCO 4) Social Security Number should not be used as a primary key because:          The Social Security Number is XXXXX and primary key fields should be text.          The Social Security Number is XXXXX unique.          The Social Security Number is XXXXX long.          Using the Social Security Number may expose employees or customers to identity theft.<br /> 5. (TCO 5) Which of the following describes a validation rule?        Makes a value entered into a field appear in a particular format          Compares the values of two fields          An error message that appears when a value is incorrectly entered into a field          Can prohibit values from being entered that may not meet a criterion    <br />6. (TCO 5) Which of the following statements would NOT be a good design consideration for a form?          Keep background colors of bound and unbound controls matching.          Make labels descriptive and clear.          Arrange controls closely together or in a sequence that is easy to read by the user.          Right align labels followed by a colon, while left aligning bound controls.    <br />7. (TCO 5) Which of the following describes validation text?          An error message that provides instruction on what to fix when an incorrect value is entered in a field          A list of predefined values that can be entered in a field          A comparison of values entered in two fields          A field that requires a value of characters or text only    <br />8. (TCO 6) In the example, which part identifies the total number of payments of a loan? Pmt(.055/12, 9*12, 55000,1,0)          .055/12          9*12          55000          0    <br />9. (TCO 6) In the example, which part identifies the interest per period of a loan? Pmt(.070/12, 25*12, 130000,0,0)          .070/12          25*12          130000          0    <br />10. (TCO 6) Which of the following is true about a select query?          It may reference fields from more than one table or query.          It may reference fields from a table, but not a query.          It may reference fields from either a table or a query but not both.          It may reference fields from a form.   <br />1. (TCO 6) After running a query, it will display in ____________ View.          Design          Datasheet          Query          Table    <br />2. (TCO 7) Which of the following are important things to know as you create an Access report?          Access cannot calculate data in a report.          Reports can be summarized, but the summaries have to be designed in the underlying query.          Reports cannot draw data from multiple tables.          What type of delivery mechanism will be used, fax, e-mail Word, Excel, PowerPoint, Internet, or printer, and what type and size of paper will be used for the report    <br />3. (TCO 7) If you want to create mailing labels from your Customers table, the fastest and easiest tool would be Access':        Report Tool          Report Wizard          Label Wizard          Mailing Wizard    <br />4. (TCO 7) To organize your data in a highly usable and readable report, you may use:          Nested tables          Nested groups          Nested queries          Calculated fields    <br />5. (TCO 8) Normalization refers to:          using the same naming convention for columns and tables throughout the database. One example is word separator characters such as hyphens between multi-word column and table names. (example last_name, product_description)          designing databases that use column names that are considered familiar, or normal to business users          the process of eliminating redundancy (such as repeating rows) from a database design          A process used to ensure queries are structured to run as quickly as possible    <br />6. (TCO 9) A security violation that includes unauthorized access, change, or destruction of data is:          limited to the hardware of a company.          limited to the databases and how the data is accessed.          called a countermeasure.          categorized into two groups: physical and logical security.    <br />7. (TCO 9) When a database is open for exclusive access:          only selected persons have access to the database.          two or more people cannot open the same database at the same time.          a password XXXXX XXXXX to open a database.          only one person has access to a database at any time.    <br />8. (TCO 9) Which statement best describes the results of digitally signing an Access database?          A timestamp is created for an Access database file.          Only the entity or company that digitally signed the database have access to its contents.          A packaged database that is converted to ACCDC file format and digitally signed with the creator's certificate is created.          A converted file to a new file format that encrypts the data of an Access database is created. <br />   9. (TCO 10) Which statement best describes backing up a database?          You can take care of backing up only after saving and completing the database.          You don't need to back up, as Access will back up your file every 5 minutes.          You can back up your database file through the backup utility found in the Office button.          You don't need to back up, as your Information Technology Department will back up the database on a daily basis.    <br />10. (TCO 10) When analyzing a database, the third normal form process will remove:          all primary keys that use an AutoNumber data type.          all primary keys.          transitive dependencies.          all fields that have duplicate names
Submitted: 3 years ago.
Category: Computer
Expert:  TechGuy replied 3 years ago.
1. Field, record, table, database
2. Each customer can be associated with only one city, but a city can be associated with many customers.
3. Hire date should be a stored field; years of service should be a calculated field.
4. Using the Social Security Number may expose employees or customers to identity theft
5. Can prohibit values from being entered that may not meet a criterion
6. Keep background colors of bound and unbound controls matching.
7. An error message that provides instruction on what to fix when an incorrect value is entered in a field
8. 9*12
9. .070/12
10. It may reference fields from more than one table or query.
1. Datasheet
2. What type of delivery mechanism will be used, fax, e-mail Word, Excel, PowerPoint, Internet, or printer, and what type and size of paper will be used for the report
3. Label Wizard
4. Nested tables
5. the process of eliminating redundancy (such as repeating rows) from a database design
6. categorized into two groups: physical and logical security.
7. only one person has access to a database at any time
8. A packaged database that is converted to ACCDC file format and digitally signed with the creator's certificate is created
9. You can back up your database file through the backup utility found in the Office button.
10. all fields that have duplicate names
Expert:  TechGuy replied 3 years ago.
If my solution was useful please hit"ACCEPT" so I can get credit for my time. Thank you.

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • I am very happy with my very fast response. Eric is very knowledgeable in the subject area. Thank you! RP Austin, TX
  • Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill Bill M. Schenectady, New York
  • The Expert answered my Mac question and was patient. He answered in a thorough and timely manner, keeping the response on a level that could understand. Thank you! Frank Canada
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
 
 
 

Meet The Experts:

 
 
 
  • Andy

    Computer Consultant

    Satisfied Customers:

    5311
    11yr exp, Comp Engg, Internet expert, Web developer, SEO
< Last | Next >
  • http://ww2.justanswer.com/uploads/EN/Engineer1010/2012-6-9_132423_jaj12a.64x64.jpg Andy's Avatar

    Andy

    Computer Consultant

    Satisfied Customers:

    5311
    11yr exp, Comp Engg, Internet expert, Web developer, SEO
  • http://ww2.justanswer.com/uploads/BA/barrenrock/2011-10-19_215925_JamesJAFinal.64x64.jpg James's Avatar

    James

    Sr. Computer Support Expert

    Satisfied Customers:

    8376
    20 years of experience building, fixing and servicing PCs and operating systems.
  • http://ww2.justanswer.com/uploads/zeyank/2009-09-26_154244_P8110079.png Ryan H.'s Avatar

    Ryan H.

    Computer Support Specialist

    Satisfied Customers:

    1741
    A+ Certified Technician - 10 Years experience working with all types of computer systems.
  • http://ww2.justanswer.com/uploads/JA/jadedangel57/2011-11-8_193134_janenewsm.64x64.jpg Jane Lefler's Avatar

    Jane Lefler

    Sr Prog Analyst / Technician

    Satisfied Customers:

    0
    Computer Programmer / Technician/ Consultant 16+ years
  • http://ww2.justanswer.com/uploads/RO/robmpreston/2013-9-23_233814_mijiFZm.64x64.jpg RPI Solutions's Avatar

    RPI Solutions

    Support Specialist

    Satisfied Customers:

    3476
    5+ Years in IT, BS in Computer Science
  • http://ww2.justanswer.com/uploads/BA/barunrath/2012-7-5_201954_Profilepic2.64x64.jpg B. Rath's Avatar

    B. Rath

    Computer Support Specialist

    Satisfied Customers:

    8671
    Certified Computer/Networking Support Specialist.
  • http://ww2.justanswer.com/uploads/FS/fszcze/2012-6-18_181848_500test.64x64.jpg Frederick S.'s Avatar

    Frederick S.

    Computer Specialist

    Satisfied Customers:

    7240
    Computer technician and founder of a home PC repair company.