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
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: the 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
Is about Access 2016 15) Access does not allow the creation of formulas for computation. ...
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 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 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 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 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 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 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 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 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, 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...