Question

Is about Access 2016 15) Access does not allow the creation of formulas for computation.           ...

Is about Access 2016

15) Access does not allow the creation of formulas for computation.

              a) True

              b) False

16) The columns of a table corresponds to

              a) Field

              b) Record

              c) Folder

              d) File

17) An Access data base can contain a maximum of

             a) any number of the table

             b) Four

             c) Ten

             d) Twenty five

18) Which of the following is true about creating Access 2016 Table.

             a) Each Table must have a primary key

               b) A table can have multiple Primary keys

               c) It can only have one table

               d) Tabes do not have to be related to share information

19) In Access, Go to External Data Tab to establish relationship.

              a) True

              b) False

20) Lookup Wizard data type creates a field that lets you lookup a value in another Access Table.

              a) True

              b) False

21) Autonumber Data type is best for currency data.

              a) True

              b) False

22) It is easier to use Design View to create reports than Report Wizard.

              a) True

              b) False

23) Form Wizard is used to create on-screen forms.

              a) True

              b) False

24) Use Date data type for birth dates.

              a) True

              b) False

25) You can back up an Access database within Access's program.

              a) True

              b) False

0 0
Add a comment Improve this question Transcribed image text
Answer #1

15
Ans: b) false
Explanation:
you can use expression builder for that

16
Ans: a) field
Explanation:
columns of a table corresponds to the field

17
Ans: a) any number of table
Explanation: t
he max size of the database could be 2gb. No limitation on no of tables

18
Ans: a) each table must have a primary key
Explanation
: the primary key is must in each table

According to CHEGG policy, we are only supposed to answer 1 question or 4 sub-parts per window

Add a comment
Know the answer?
Add Answer to:
Is about Access 2016 15) Access does not allow the creation of formulas for computation.           ...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Microsoft Access 0 database name should be the broad name of what will be inside it....

    Microsoft Access 0 database name should be the broad name of what will be inside it. If I were creating a database on the history of the Pittsburgh Steeler Coaches I would call mine SteelerCoaches.accdb, for example. A. Design one table with at least a. 6 Fields (can have more, but not more than 10) b. Correct datatypes for your fields c. Property changes appropriate to the fields. Have all Field names with more than one word have no spaces...

  • Please I need Help with this question, 1. Which of the following is a method tocreatea...

    Please I need Help with this question, 1. Which of the following is a method tocreatea new table inMS Access? A All the answers b. Using Design View c. CreateTable Wizard d. Directly Entering Data 1. Which field type will you select if you need to enter long text in that field? a Currency b Text c Hyperlink d Memo 1. The columns in a microsoft access table are also called _______ a Fields b Rows c Records d Columns...

  • 16) What does Access do to denote action queries differently in the Navigation pane? A) It...

    16) What does Access do to denote action queries differently in the Navigation pane? A) It displays them in bold text. B) It displays them in a larger typeface. C) It displays them in a section called Action queries. D) It displays them using specific icons. 17) Which of the following is not a rule for using an Append query? A) Data types in both tables much match (with some exceptions). B) There must be the same number of fields...

  • If the focus in a form moves from left to right and you want the focus...

    If the focus in a form moves from left to right and you want the focus to move from top to bottom, change the _____. . a. . sort order . b. . tab order . c. . form layout . d. . focus grouping    What do you change when you drag the right border of a form in Form Design view? . a. . the layout of the form . b. . the width of the form ....

  • erms Matching Match the key terms with their definitions. Write the key term letter by the...

    erms Matching Match the key terms with their definitions. Write the key term letter by the appropriate numbered definition k. Foreign key 1. Multitable query m. Nul a. AND condition b. Auto Number c. Caption property d. Cascade Delete Related Records e. Cascade Update Related fields f. Comparison Operator 8. Criteria row h. Data redundancy i. Data type 1. Field property o. OR condition p. Query q. Referential Integrity r. Simple Query Wizard 5. Wildcard Special character that can represent...

  • Database Questions (Please help if you can) For the same query task, different DBMSs may use...

    Database Questions (Please help if you can) For the same query task, different DBMSs may use different SQL statements. true         (b)         false Given a table, any column of this table can be used as a key of the table. true         (b)         false It is allowed to have multiple keys in a table. true         (b)         false When we create a table in a DBMS, if we do not explicitly specify the database, the table can never be created the DBMS does...

  • In JavaScript the inner function can access the variables from the outer scope even after the...

    In JavaScript the inner function can access the variables from the outer scope even after the outer function has returned. This is because the variables are still bound in the inner function and not dependent on the outer function. This is called closure. True False 3 points    QUESTION 2 Which of the following statements is true about JSON? a. JSON stands for JavaScript Object Notation. b. JSON is a syntax for storing and exchanging data. c. JSON is text,...

  • Start Access. Open the downloaded Access file named exploring_acap_grader_a1_Loans.accdb. Import the exploring_acap_grader_a1_Clients.xlsx Excel workbook into a...

    Start Access. Open the downloaded Access file named exploring_acap_grader_a1_Loans.accdb. Import the exploring_acap_grader_a1_Clients.xlsx Excel workbook into a table named Clients. While importing the data, make sure to select the option First Row Contains Column Headings, and select ClientID as the primary key field. After you have completed the import, open the Clients table in Design view. Change the ClientID field size to 6 and remove the @ symbol from the ClientID format property. Change the ZIP field size to 5. Change...

  • A Customer can have many Venues. A Venue can only be controlled by one Customer. Page 2 Introducing Access Office 2010 A Venue can have many Taps. particular Tap belongs to only one Venue.ie seri...

    A Customer can have many Venues. A Venue can only be controlled by one Customer. Page 2 Introducing Access Office 2010 A Venue can have many Taps. particular Tap belongs to only one Venue.ie serial no.12456-1 is only found A in Venue X A Tap Type can have many Taps. A Tap can belong to only one particular Tap Type that one Tap can be installed in one Venue, but one Venue can have many Taps installed. Therefore we need...

  • Assume that The Queen Anne Curiosity Shop designs a database with the following tables. CUSTOMER (CustomerID,...

    Assume that The Queen Anne Curiosity Shop designs a database with the following tables. CUSTOMER (CustomerID, LastName, FirstName, EmailAddress, EncyptedPassword, City, State, ZIP, Phone, ReferredBy) EMPLOYEE (EmployeeID, LastName, FirstName, Position, Supervisor, OfficePhone, EmailAddress) VENDOR (VendorID, CompanyName, ContactLastName, ContactFirstName, Address, City, State, ZIP, Phone, Fax, EmailAddress) ITEM (ItemID, ItemDescription, PurchaseDate, ItemCost, ItemPrice, VendorID) SALE (SaleID, CustomerID, EmployeeID, SaleDate, SubTotal, Tax, Total) SALE_ITEM (SaleID, SaleItemID, ItemID, ItemPrice) The referential integrity constraints are: ReferredBy in CUSTOMER must exist in CustomerID in CUSTOMER Supervisor...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT