ACCESS 2019 DATABASE ASSIGNMENT 1.What data type is used for the Contact First Name field? 2.What...
ACCESS 2019 DATABASE ASSIGNMENT
1.What data type is used for the Contact First Name field?
2.What data type is used for the Opened field?
3.What is the Field Size of the City field?
4.What is the Field Size of the State Abbrev field?
5.What is the Field Size for the Number of Employees field?
6.In Field Properties, what is the Default Value for the Number of Employees field?
7.What is the Company ID for the fifth record (“5 of 21”) in the table
8.What is the Company Name for the 20th record (“20 of 20”) in the table?
9.How many records are in the Companies table?
10. How many records can one form display?
11. How many records are in the Companies table now?
12. How many fields are in the Companies query?
13. How many records are in the Companies query?
14. How many fields are in the New York Companies query?
15. How many records are in the New York Companies query?
16. How many Companies printed on your report?
17.List the database object that allows you to view just one record at a time?
18. List the database object that allows you to use criteria to display only specific records?
19. List the database object that lets you print your data with customized layouts?
20. What does the acronym DBMS stand for?
DBMS. Stands for "Database Management System." In short, a DBMS is a database program. Technically speaking, it is a software system that uses a standard method of cataloging, retrieving, and running queries on data
Homework Answers
Answer to the above questions-
1. Short text.
2. Date/Time
3. 20
4. 15
5. Integer
6. Long Integer
According to the guidelines and terms of Chegg I am, to answer only the first four questions.
Please comment if you have any queries related to the answer.
Add Answer to:
ACCESS 2019 DATABASE ASSIGNMENT
1.What data type is used for the Contact First Name field?
2.What...
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 access to TUN SQL/Assistant using the default database = db_pvfc12_std 1.- Run a query to...
Please access to TUN SQL/Assistant using the default database = db_pvfc12_std 1.- Run a query to retrieve all the data field from db_pvfc12_std in table CUSTOMER_T 2.- Run a query to retrieve record --> CustomerID = 11, How many records did you get and why? 3.- Run a query to retrieve all the data field from table Order_T Once retrieved: 3.1.- Please name the fields showing: Primary Key, Foreign Key and other fields 3.2.- What type of...
Q) MyBooks is an android application has a homepage "Activity_MyBooks.xml" that shows a simple li...
Q) MyBooks is an android application has a homepage "Activity_MyBooks.xml" that shows a simple list. This list displays only the book title for each book in the user’s book database. The database has a table name “Books” which has the following fields (Book_id, BookTitle, Author, Year). This App connected to the Database by BookstDataSource class and BooksDBHelper class. Explain the following questions on your own words and no need to write a code. Explain how to create the Layout for...
1. You typically increase the decimal places from 1 to 2 for a(n) _____ field. A....
1. You typically increase the decimal places from 1 to 2 for a(n) _____ field. A. Currency B. AutoNumber C. Long Text D. Money 2. What button do you use on the Query Tools Design tab to add a field list to a query? A. Field List button B. Show Table button C. View button D. Table Names button 3. _____ view provides the most options for defining fields. A. Field Create B. Field Define C. Table Create D. Table...
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...
Project 2 (Clothing Rental) Fashion Rental is a rental company located in Manhattan, New York, sp...
Project 2 (Clothing Rental) Fashion Rental is a rental company located in Manhattan, New York, specializing in rental of high end wome en clothing for the fashion industry. Over the past 12 months, her business has experienced tremendous growth due to a boom in the fashion Industry. The business has kept the daily service records in a workbook format and now needs to expand its reporting capabilities to develop a relatio nal database to effect a more functional structure. Fashion...
6. With respect to database systems, which of the following statement(s) is (are) true? a. The...
6. With respect to database systems, which of the following statement(s) is (are) true? a. The physical view of data is how people conceptually organize and understand the relationships among data items. b. The DML builds the data dictionary, creates the database, describes logical views for each user, and specifies security constraints. c. A record layout shows the items stored in a file, including the type of data stored and both the order and length of the data fields. d....
x Assignment 1 - Database.pdf ... Learn how to access and use NCBI databases Question 1:...
x Assignment 1 - Database.pdf ... Learn how to access and use NCBI databases Question 1: Search Taxonomy database for: 1) Homo sapiens, 2) Heterodoxus macropus, 3) E. coli. a. What is the common name of the species? b. How many nucleotide or protein sequence records do you find (show your search results in cropped windows)? Question 2: Use the name "plague thrips" to search the Nucleotide database. a. What is the scientific name of the plague thrips? b. How...
Hide/Show Time Remaining Part 1 of 1- Question 1 of 38 When designing a new database,...
Hide/Show Time Remaining Part 1 of 1- Question 1 of 38 When designing a new database, the first question users should ask themselves is O A. How much information is going to be stored in this database? B. Where should this database be stored? O C. Who is going to use this database? O D. What questions should this database be able to answer? Question 2 of 38 When linking two tables in a relational database, a user will use...
Access 2016 Quiz 1) What view normally appears when you double-click a table? (1 point) a.Datasheet...
Access 2016 Quiz 1) What view normally appears when you double-click a table? (1 point) a.Datasheet view b.Form view c.Design view d.Layout view 2) What type of filter displays records based on a criterion you choose? (1 point) a.Exact Match filter b.Selection filter c.Toggle filter d.Filter by Report 3) Which of the following is not a valid criteria in a filter? (1 point) a. Is Null b. =>14 c. ="Fred" d. <>125 4) To view or modify a table's structure...
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...
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...
Project 2 (Clothing Rental) Fashion Rental is a rental company located in Manhattan, New York, specializing in rental of high end wome en clothing for the fashion industry. Over the past 12 months, her business has experienced tremendous growth due to a boom in the fashion Industry. The business has kept the daily service records in a workbook format and now needs to expand its reporting capabilities to develop a relatio nal database to effect a more functional structure. Fashion...
6. With respect to database systems, which of the following statement(s) is (are) true? a. The physical view of data is how people conceptually organize and understand the relationships among data items. b. The DML builds the data dictionary, creates the database, describes logical views for each user, and specifies security constraints. c. A record layout shows the items stored in a file, including the type of data stored and both the order and length of the data fields. d....
x Assignment 1 - Database.pdf ... Learn how to access and use NCBI databases Question 1: Search Taxonomy database for: 1) Homo sapiens, 2) Heterodoxus macropus, 3) E. coli. a. What is the common name of the species? b. How many nucleotide or protein sequence records do you find (show your search results in cropped windows)? Question 2: Use the name "plague thrips" to search the Nucleotide database. a. What is the scientific name of the plague thrips? b. How...
Hide/Show Time Remaining Part 1 of 1- Question 1 of 38 When designing a new database, the first question users should ask themselves is O A. How much information is going to be stored in this database? B. Where should this database be stored? O C. Who is going to use this database? O D. What questions should this database be able to answer? Question 2 of 38 When linking two tables in a relational database, a user will use...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago