Answer:
(C) Scalable image without pixilation
What are the two types of process automation?
The two types of process automation are
1. Robotic Process Automation (RPA)
2. Business Process Automation (BPA)
What are the disadvantages of automation?1. High Initial Costs: Automation requires a significant financial investment, which may be difficult for some businesses to afford.
2. Job Losses: Automation can reduce the number of jobs available in an industry, as machines replace human labor.
3. Complexity: Automation can be difficult and time consuming to set up and maintain.
4. High Maintenance Costs: Automation requires frequent maintenance and repairs, which can be costly.
5. Human Errors: Automation can be prone to errors due to incorrect programming or faulty hardware.
6. Limited Flexibility: Automation is limited in its ability to adapt to changing conditions.
7. Security Risks: Automation may pose security risks if not properly managed.
To learn more about automation refer to:
https://brainly.in/question/53276335
#SPJ4
List two companies that provide preventive measures for e-commerce sites. What are included in their offerings? What are the costs? When you purchase from online businesses, how do you know that a Web site is secure?
The two companies that provide preventive measures for e-commerce sites are Akamai and Amazon.
What is companies?Companies are legal entities that are legally registered in accordance with the Company Act. The companies are the main motive of the earning the profit. The companies are the making the profit to run the business.
Two Companies that provide preventive measures for e-commerce sites:
Akamai delivers a content delivery network that is by far the greatest cloud dispersed cloud computing environment accessible. Content distribution network, DDOS mitigation, and so forth.
Amazon Web Services: Amazon provides cloud infrastructure services under the term Amazon Web Services (AWS). It is now easier for e-commerce sites to do business and grow it to the desired level thanks to AWS.
Learn more about on companies, here:
https://brainly.com/question/29354835
#SPJ4
What program is used to transfer files from one computer to another and can be used to upload your web pages to your Web server?
File management tasks on a server are performed via FTP clients. Among the list of FTP clients are: FileZilla. With support for FTP, FTPS, and SFTP, this free FTP client is available for Windows, macOS, and Linux.
What is FTP (File Transfer Protocol)?The Transmission Control Protocol/Internet Protocol (TCP/IP) connection format is used by the network protocol known as FTP (File Transfer Protocol) to transfer files between computers. FTP is categorized as an application layer protocol within the TCP/IP stack.The computer of the end user is commonly referred to as the local host in an FTP transaction. A remote host, or server, is typically the second machine in an FTP connection. To transfer data with FTP, both computers must be properly set up and linked to a network. To access these services, clients must have FTP software installed on their computers and servers must be configured to run FTP services.FTP is still frequently used to transfer files behind the scenes for other applications, such as banking services, even though many file transfers may be carried out using HTTP, a different protocol in the TCP/IP suite. Using web browsers, it is occasionally used to download fresh software.To Learn more About FTP clients refer to:
https://brainly.com/question/28486886
#SPJ4
The VLOOKUP function looks up values in a table with which feature?
column labels in the top row
column labels in the bottom row
row labels in the leftmost column
row labels in the rightmost column
The VLOOKUP function looks up values in a table with the feature that allows row labels in the leftmost column. Thus, the correct option for this question is C.
What is the VLOOKUP function?The VLOOKUP function may be characterized as a built-in Excel function that helps you look for a specified value by searching for it vertically across the sheet. This function in Excel may sound complicated, but you will find out that it is a very easy and useful tool once you try it.
The VLOOKUP function lets you search the leftmost column for a value and return another value on the same row in a column you specify. The range of cells in which the VLOOKUP will search for the lookup_value and the return value.
Therefore, row labels in the leftmost column are the feature through which the VLOOKUP function looks up values in a table. Thus, the correct option for this question is C.
To learn more about VLOOKUP function, refer to the link:
https://brainly.com/question/29646445
#SPJ1
Answer:
A -column labels in the top row.
Explanation:
Is the correct answer.
What is a programmable electronic device that accepts data input performs processing operations on that data and outputs and stores the results?
A computer is a device that can be configured to take in data (input), turn it into information that is useful (output), and then store the information away (in a secondary storage device) for safekeeping or future use.
What is computer ?"Radio, movies, and television mixed," a six-year-old said of a computer. The phrase "a television set you can talk to" was used by a ten-year-old to describe a computer. The ten-year-definition old's is more accurate, but he or she still does not see the computer as a tool with the ability to alter things.Although hardware does the processing, software controls how input is converted to output.A computer system needs input, processing, output, and storage in order to operate. These are the four main data handling components. Following is a description of how the hardware in charge of these four regions works:Data is accepted via input devices in a format that a computer can understand, and after being sent there, it is processed.The electronic circuitry that transforms input data into the information humans seek is found in the processor, also referred to more technically as the central processing unit (CPU). Computer instructions contained in the program are carried out by the central processing unit.The processed data-information is presented to users in a usable way through output devices.Typically, storage refers to backup storage. Diskettes and other items that can store data and applications outside of the computer are examples of secondary storage. The computer's memory, which will be seen to be only briefly able to store data and programs, is supplemented by these devices.To Learn more About computer refer to:
https://brainly.com/question/21474169
#SPJ4
which of the following is not an advantage that data marts have over data warehouses? a. they are less expensive. b. access to data is often faster because of their smaller size. c. they are larger and often more complex. d. response time for users is improved.
The statement that is not an advantage that data marts have over data warehouse is they are larger and often more complex.
Data marts are smaller, more focused data stores that are designed to provide fast, efficient querying and analysis for a specific business line or team. They can be faster and more efficient to use than a larger data warehouse because they contain only a subset of data and are typically designed for a specific purpose. Data marts can be easier to set up and maintain than data warehouses, which can be more complex and expensive. They can also improve response time for users because they are optimized for a specific set of queries and are generally smaller in size, which can make them faster to access.
Learn more about data marts, here https://brainly.com/question/13989635
if you were to shoot a video that contained a promo message and then shared it with your friends, what is this called? viral video answer print master tape wireframe animation
If you shot a video that contained a promo message and shared it with your friends, it could be called a viral video.
A viral video is a video that becomes popular through the process of Internet sharing, typically through video sharing websites, social media and email. Viral videos often have a short shelf life, as they are quickly replaced by newer, more popular videos. However, some viral videos can be highly successful in terms of views and influence, and can generate significant attention and publicity for the people or organizations featured in the video. Viral videos can be created intentionally or unintentionally. Some companies and organizations create viral videos as part of a marketing campaign, with the goal of getting as many people as possible to view and share the video.
Learn more about viral video, here https://brainly.com/question/2452527
#SPJ4
the number of elements shifted in insertion sort depends on where it will be inserted. group of answer choices true false
The straightforward sorting technique known as insertion sort compares each item in turn to create the final sorted array (or list).
What is insertion sort?Comparing it to more sophisticated algorithms like quicksort, heapsort, or merge sort on large lists, it performs significantly worse. But there are a few benefits to using insertion sort:Easy to implement A five-line optimized version of Jon Bentley's three-line C/C++ version is shown. Effective for (quite small) data sets, similar to other quadratic (i.e., O(n2)) sorting algorithmsIn comparison to the majority of other basic quadratic algorithms, such as selection sort and bubble sort, it is more effective in practice.Adaptive, i.e. effective for data sets that have previously been considerably sorted: When each input element is no more than k positions from its sorted location, the time complexity is O(kn), meaning that the order of elements with equal keys remains stable.Online, i.e., may sort a list as it is received In-place, i.e., only needs a constant amount O(1) of additional memory spaceMost individuals employ an approach resembling insertion sort when manually sorting cards in a bridge hand.To Learn more About insertion sort refer to:
https://brainly.com/question/23161056
#SPJ4
What 3 things make a reliable source?
Answer: (read explanation)
Explanation:
There are several characteristics that can make a source reliable. These characteristics include:
Authority: A reliable source is typically written or produced by someone who is an expert in the field or topic that the source covers. This expert may be a researcher, scholar, or other qualified individual who has knowledge and experience in the subject matter.
Accuracy: A reliable source provides accurate information that is supported by evidence and can be verified through other sources. The information in a reliable source is factual, well-researched, and free from errors or bias.
Objectivity: A reliable source presents information in an unbiased manner, without trying to persuade the reader to adopt a particular point of view. The information in a reliable source is presented objectively, allowing the reader to form their own opinion based on the evidence provided.
Overall, a reliable source is one that is written or produced by an expert, provides accurate information, and presents this information in an objective manner.
Problem with your Seller Account
You’re currently unable to add or edit listings because either the credit card on file is invalid or the credit card is in the process of validating, which typically takes an hour (but could take up to 24 hours). Please ensure that you have a valid credit card uploaded in Account Settings.
Return to your Seller Account. How to deal with this problem?
Check the credit/debit card associated with both 'charge method' and 'Advertising charge method' on the merchant's main settings page. Make sure neither has expired and both have sufficient funds for Amazon's test withdrawal.
What does charge method mean?Charge Method means the method of payment for Fees agreed between Customer and Provider and specified in the relevant Order Form.
What is the direct charge method?A direct billing scheme is one in which a particular in-group service is charged directly on a uniquely identified basis.
Why can't Amazon charge my credit card?Check whether: 1) you have entered your credit card number, credit card expiration date, billing address, and phone number correctly in your account. 2) the purchase outside your normal spending range.
Some banks block transactions due to security concerns. Read by touch.
To learn more about Seller account visit:
https://brainly.com/question/26352742
#SPJ4
Co-created content on social media refers to content that
Co-created material on social media refers to posts that were made in collaboration with another profile.
Social media are interactive media platforms that facilitate the creation and distribution of content through online networks and communities, such as knowledge, ideas, interests, and other forms of expression. Despite the difficulty in defining social media due to the variety of separate and combined social media services currently available, there are certain common traits: Social media are Web 2.0 interactive apps that are Internet-based. User-generated material, which might take the form of textual postings or comments, digital photos or videos, or statistics from all online interactions, is what keeps social media platforms alive. The social media company creates and maintains service-specific profiles for the website or app that users develop. Social media helps the development of online social networks by tying a user's profile to those of other individuals or groups.
Learn more about Social media here
https://brainly.com/question/23976852
#SPJ4
which of the following will be a 'fact' measure in a data cube used at a chain retail business? 1) Product category 2) Month name 3) City name 4) Sales revenue
Answer:
Option (4)
Explanation:
All dimensions connect in order to create a certain fact – the finest part of the cube. A fact has a corresponding measure in the data cube. Typically, the fact measure in a data cube for a chain retail business is the revenue.
Use nested for-loops to have the turtle draw a snowflake of polygons. Use the variable turnamount to turn after each shape and the variable n for the sides of the polygon
An interlocking loop is referred to as nested loop . These are frequently utilized while working in two dimensions, such as when printing stars in rows and columns.
How do two for loops that are nested work?An inner loop encloses the body of an outer loop, creating a nested loop. In order for this to operate, the inner loop must be triggered by the outer loop's initial pass in order to begin working. The inner loop is then reactivated during the second transit of the outer loop.
The for loop may be nested, right?For loops that are nested are placed inside of one another. With each outer loop iteration, the inner loop is repeated.
To know more about nested for-loops visit :-
https://brainly.com/question/13971698
#SPJ4
which of the following is a true statement about program commenting?question 20 options:program commenting is useful during initial program development and also when modifications are made to existing programs.program commenting is only needed for programs in development; it is not needed after a program is completed.program commenting should not be changed after it is first written.program commenting is useful when programmers collaborate but not when a programmer works individually on a project.question 21 (5 points)
All of the following statements are true about program commenting:
- When creating new programs or making changes to already-existing ones, program commenting is helpful.
- Not only is program commenting necessary for developing new programs, but it is also helpful for maintaining and updating already-existing programs.
- After it has been written, program comments shouldn't be modified. As comments offer significant context and information about the code, it is crucial to preserve their integrity.
- Both when programmers collaborate on a project and when a programmer works alone, program commenting is helpful. Other programmers will find it simpler to comprehend and use the code if there are comments that aid to clarify the code's functioning and intended use.
Learn more about program commenting here:
https://brainly.com/question/26346748
#SPJ4
Which of the following has the least volatile data?
- CPU storage
- RAM
- Hard drive
- Kernel tables
The option that has the least volatile data is option C: Hard drive.
What are hard drives, and what do they do?A hard disk drive (HDD), often known as a hard disk, hard drive, or fixed disk, is an electro-mechanical data storage device that stores and retrieves digital information utilizing magnetic storage on one or more rigid, quickly rotating platters coated with magnetic material.
Therefore, one can say that the least volatile data of those listed is that found on a hard drive. All other sources are some form of memory, which disappears when a system is switched off.
Learn more about Hard drive from
https://brainly.com/question/1558359
#SPJ1
What are the positive and negative effects of using smartphones?
answer:
positive effects:
- it's useful for learning online
-you can use internet if you don't understand anything.
-can help you to stay in contact with with your friend and family
Negative effects:
-it can damage your eyes by watching too much smartphone
-distract your learning
which of the following statements best summarizes the author’s predictions for how humans will meet the future nutritional needs of a growing population using current agricultural technology?
The best summarizes the author’s predictions for how humans will meet the future nutritional needs of a growing population using current agricultural technology is humans have maximized the crop yield with improving technology and the implementation of modern genetic techniques to further increase crop productivity and resilience in order to meet the demand.
What is agricultural technology?Аgriculturаl technology or аgrotechnology is the use of technology in аgriculture, horticulture, аnd аquаculture with the аim of improving yield, efficiency, аnd profitаbility. Аgriculturаl technology cаn be products, services or аpplicаtions derived from аgriculture thаt improve vаrious input/output processes.
To аddress these forces poised to further roil the industry, аgriculture must embrаce а digitаl trаnsformаtion enаbled by connectivity. These new technologies cаn upgrаde decision mаking, аllowing better risk аnd vаriаbility mаnаgement to optimize yields аnd improve economics.
Your question is incomplete, but most probably your full question was
Which of the following statements best summarizes the author's predictions for how humans will meet the future nutritional needs of a growing population using current agricultural technology?
A) The effects of global climate change will decrease as farmers employ advanced technological methods to agriculture.
B) Less-developed countries must change from a meat-based protein diet to a more grain-based diet. This will allow the global population to continue to meet the agricultural demands of a growing population.
C) Humans have maximized the crop yield with improving technology and the implementation of modern genetic techniques to further increase crop productivity and resilience in order to meet the demand.
D) The only way to meet the agricultural demand of a growing world population is to convert more grassland and forests into working agricultural land. Genetically modified foods are no longer nutritious, and the nutrients in the forest and grassland soil will increase yield and nutrition.
Thus, the correct answer is C.
For more information about agricultural technology refer to the link:
https://brainly.com/question/20450639
#SPJ4
Make a list of symptoms of computer virus and preventive measures from computer virus.
Answer:
Intrusive pop-ups. Slow performance. Frequent crashes. Unknown login items. Storage space shortage. Missing files.
Explanation:
those are symptoms
What are the 3 types of training?
The 3 types of training is On the job training , Off-the-job training , E-learning.
What are the 3 types of training?On-the-job training: This kind of training takes place when a less inexperienced coworker, supervisor, or manager trains an employee to carry out a particular job task or role within an organization. It typically takes place at work and may include a demonstration, some practice, and instructor comments. Since it enables employees to learn in the setting where they will be carrying out the responsibilities, on-the-job training is sometimes seen as the most effective.Off-the-job training: Off-the-job training is a type of instruction that is conducted outside of the typical workplace setting. This kind of training could take place in a different area, structure, or even location.It is frequently used to teach staff members skills that are either too complicated to be taught on the job or have no bearing on the particular task they are performing.E-learning : A website or an online learning platform can be used for e-learning, which is a type of instruction that takes place online. It can be used to teach employees a variety of skills and expertise, such as customer service, product knowledge, and computer skills. This kind of training is frequently self-paced, allowing participants to take their time and learn at their own pace.To learn more about the 3 types of training refer to:
https://brainly.com/question/29829957
#SPJ4
write a program that first reads in the name of an input file and then reads the file using the csv.reader() method. the file contains a list of words separated by commas. your program should output the words and their frequencies (the number of times each word appears in the file) without any duplicates. ex: if the input is: input1.csv and the contents of input1.csv are: hello,cat,man,hey,dog,boy,hello,man,cat,woman,dog,cat,hey,boy
High-level, all-purpose programming languages like Python are available. With the usage of extensive indentation, its design philosophy places an emphasis on code readability.
What is meant by Python?High-level, all-purpose programming languages like Python are available. With the usage of extensive indentation, its design philosophy places an emphasis on code readability. Garbage collection and dynamic typing are features of Python.It supports a number of programming paradigms, such as functional, object-oriented, and structured programming. Python is a computer programming language that is frequently used to create software and websites, automate processes, and perform data analysis. Because Python is a general-purpose language, it may be used to develop a wide range of programs and isn't tailored for any particular issues. Python is a great language for experienced programmers as well. Perhaps due to how simple it is to learn for novices, it is one of the most widely used programming languages in the world.The program in Python, where comments are used to explain each line is as follows:
#This imports csv module
import csv
#This initializes a dictionary
kounter = {}
#This gets input for the file name
fname = input("Filename: ")
#This opens and iterates through the file
with open(fname, 'r') as cfile:
#This reads the csv file
cfile = csv.reader(cfile)
#This iterates through each line
for line in cfile:
#This iterates through each word on each line
for words in line:
#This counts the occurrence of each word
if words not in kounter.keys():
kounter[words] = 1
else:
kounter[words] + 1
#This prints the occurrence of each word
print(kounter)
To learn more about Python refer to:
https://brainly.com/question/26497128
#SPJ4
How do I get to easy settings in Windows 10?
What are the two types of malicious code?
There are many different types of malicious code, but two common categories are viruses and worms. A virus is a type of malware that is designed to replicate itself and spread to other computers by attaching itself to a host program or file. A worm, on the other hand, is a standalone program that can replicate itself and spread to other computers without needing to attach itself to a host program or file. Other common types of malicious code include Trojans, ransomware, and spyware.
The priority code point field in a frame consists of how many bits?
The priority code point field in a frame consists of 3 bits. The smallest unit of data on a computer is a bit, which is a binary digit. There are just two values that a bit can store: 0 or 1
In order to transport one of 64 distinct differentiated services field code point (DSCP) values, the Differentiated Services (Diffserv) architecture mandates that the DS field in IPv4 and IPv6 packet headers be used.
For the purposes of codepoint assignment and management, the codepoint space is divided into three pools: a pool of 32 codepoints (Pool 1) that will be assigned by Standards Action as defined in [RFC8126], a pool of 16 codepoints (Pool 2) that will be reserved for experimental or local use (EXP/LU), and a pool of 16 codepoints (Pool 3), initially available for experimental or local use, but which should be used preferentially for Standardized assignments now use codepoints from Pool 3
Learn more about Code here:
https://brainly.com/question/17293834
#SPJ4
Wwhich file should you edit for sendmail configuration?
The file to update for sendmail configuration details and optional settings needed to control the sendmail daemon's behaviour is /etc/mail/sendmail.mc.
Sendmail is a server programme that allows organisations to send email over the Simple Mail Transfer Protocol (SMTP). It is often deployed on a dedicated workstation that takes outgoing email messages and subsequently forwards them to the specified recipient. If a receiver is not immediately accessible, messages are queued, and authentication is offered as a measure to avoid spam. Sendmail, on the other hand, simply sends email and does not support POP or IMAP, which would allow it to accept messages and store them in user inboxes. As a result, Sendmail is usually installed alongside other software that allow users to configure their inboxes.
Learn more about Sendmail here:
https://brainly.com/question/12996669
#SPJ4
a system uses simple/pure paging and tlb each memory access requires 100ns tlb access requires 5ns tlb hit rate is 90%. work out the actual speedup because of the tlb? speedup
Each process in the operating system will have its own page table, which will contain Page Table Entry (Memory Management Technique: Paging) (PTE).
What is Translation Lookaside Buffer (TLB) in Paging?The frame number (the address in main memory to which we want to refer) and a few other essential bits (such as the valid/invalid bit, dirty bit, protection bit, etc.) will be included in this PTE. This page table entry (PTE) will indicate where the actual page is located in main memory.The issue now is where to put the page table such that overall access time (or reference time) will be less.Fast main memory content access using a CPU-generated address (i.e., a logical or virtual address) presented a challenge at first. Since registers are high-speed memory, some people at first considered utilizing them to store page tables since access times would be shorter.The concept employed here is to store the page table entries in registers, so that when a request is created from the CPU (virtual address), it will be matched to the correct page number of the page table, which will then reveal where in the main memory the corresponding page is located.Everything appears to be in order, but the issue is that the register size is small (in practice, it can only hold a maximum of 0.5k to 1k page table entries) and the process size may be large, so the required page table will also likely be large (let's say this page table contains 1M entries). As a result, the registers might not be able to hold all of the PTEs of the page table. Therefore, this strategy is not workable.The Complete Question is Page Table Entry.
To Learn more About Page Table Entry refer to:
https://brainly.com/question/15409133
#SPJ4
HELP ME!
How do you change the file type of an downloaded image?
Answer:
To change the file type of an image, you can use an image editing software or a file conversion tool. Here's a step-by-step guide:
Open the image file using an image editing software such as Adobe Photoshop, GIMP, or Paint.
Go to the "File" menu and select "Save As."
In the "Save As" dialog box, select the desired file format from the "Save as type" drop-down menu.
Choose a name and location for the file, and then click "Save."
Alternatively, you can use a file conversion tool to change the file type. These tools allow you to convert the image file to a different format without requiring any special software. Some popular file conversion tools include Online-Convert, Zamzar, and FileZigZag. To use a file conversion tool, follow these steps:
Go to the website of the file conversion tool you want to use.
Select the option to convert an image file.
Choose the image file you want to convert by clicking the "Choose Files" button or dragging and dropping the file into the designated area.
Select the desired file format from the drop-down menu.
Click the "Convert" button to start the conversion process.
Once the conversion is complete, the tool will typically allow you to download the converted file. Save the file to your computer and open it to verify that the conversion was successful.
Explanation:
Answer:
Here is an example of how you might do this using Photoshop:
Open the image in Photoshop.Go to the "File" menu and select "Save As."In the "Save As" window, choose the desired file format from the "Format" dropdown menu.Enter a name for the new file in the "File Name" field.Choose a location to save the file in the "Save In" field.Click the "Save" button to save the image in the new file format.windows cannot be installed to this disk. selected disk is gpt partition style.how to solve this problem?
why would you use the check accessibility feature.
The reason I use the check accessibility feature is because it checks my file against a set of guidelines that pinpoint potential problems for those with disabilities.
What is the main purpose of the accessibility checker?Accessibility features are made to make it easier for persons with disabilities to utilize technology. A speech-recognition feature, for instance, enables users with limited movement to control the computer with their voice. A text-to-speech tool, on the other hand, may read text aloud for persons with limited vision.
Therefore, one can say that your file is checked by the accessibility checker against a list of guidelines that pinpoint any potential problems for those with disabilities. The Accessibility Checker categorizes every issue as either an error, warning, or tip depending on how serious it is.
Learn more about accessibility feature from
https://brainly.com/question/14350549
#SPJ1
Which of the following is a difference between web pages and social Media?
A. Unlike web pages, social media prohibits users from generating their own content.
B. Unlike web pages social media enables people to connect online and have a conversation.
C. Unlike webpages, social media is not generally interactive.
D. Unlike webpages, social media requires authorization before posting.
Social media and websites vary in that social media allows users to interact online and converse with one another.
Social media profiles are free to create and may be created by anybody. This makes it simple to promote your small business, but it also makes customers sceptical of any accounts they come across. Social networking is a labyrinth of frauds and dodgy businesses that take your money and disappear. A well-designed website reassures visitors and allows businesses to demonstrate their history, competence, qualifications, and, ultimately, credibility.
People may assume that the rise of social enterprises has rendered company websites obsolete, but what is the difference between a website and social media? Is the importance of websites still relevant in 2020?
The simple answer is no, websites continue to be critical to having a good online presence in 2020. If you want the lengthy answer, go here.
Learn more about Websites here:
https://brainly.com/question/29330762
#SPJ4
Exp19_Access_Ch03_ML1 - Small Business Loans 1.0 Project Description: You are the manager of a regional business loan department for the US Small Business Administration office you have decided to evaluate whether Access could be used in place of the Excel worksheet you are currently using You will create table, add some sample customers, and import some recent data from an Excel spreadsheet. You will calculate the payments for the loans that are currently on the books by creating a query using the Pmt function. You will also summarize each loan by the type of loan (M-Mortgage. CCar, and OOther) Steps to Perform: Points Instructions Possible 1 Start Access Open the downloaded Access file named 0 Exp 19 Access Cho3 ML 1 Small Business Loans acob Grader has automatically added your last name to the beginning of the filename. Note this file is an empty database 2 In Design view, create a new table. Add the first field named Customer with AutoNumber 10 Data Type. Add Company as the second field name, and FirstName as the third field name Accept the default data types Save the Table with name as Customer Click Yes, when prompted for defining Primary key 3 Add the following fields to the Customers table in this order), accepting the default data type 10 of Short Text Step LastName City State Zip 10 5 10 6 10 IN 10 eg 5 Verify that Customer is the primary field Save the table and switch to Datasheet view. Add the following records to the table Company FirstName LastName City State Zip Jones and Co Robert Paterson Greensboro NC 27401 Elements, Inc. Merve Kana Paterson NJ 07505 Godshall Meats, LLC Francisco De La Cruz Beverly Hills CA 90210 Import the spreadsheet using the downloaded Excel file a03_h2_Loans.xlsx into a new table Choose LoanID as the primary key and accept all other defaults in the Import Wizard Open the Loans table in Design View Change the InterestRate field format to Percent. Change the field size for the Customer field to Long Integer Save and close the table Click Yes when prompted that some data may be lost Create a relationship between the Customerio fields in the Customers and Loans tables Enforce referential integrity Save and close the Relationships window Create a query using the two tables that will calculate the payment amount for each loan Add the following fields Company, Loani. Amount, InterestRate, Term, and LoanClass, in that order Sort the query by Loani in ascending order Save the query as Loan Payments Use the Expression Builder to add a calculated field named Payment in the first blank column to calculate the loan payment for each loan using the Pmt function. Insert the appropriate field names in place of the placeholder arguments. Assume the loans have monthly payments (12 payments per year. Ensure the payment displays as a positive number Run the query Switch to Design view and change the format for the Payment calculated field to Currency Run the query again to verify your change In Datasheet view, add a Totals row. Use it to calculate the sum of the Amount column the average InterestRate, and the average Term. Save and close the query Create a copy of Loan Payments. Save the new query as Loan Payments Summary Open the Loan Payments Summary query in Design view and rearrange the columns as follows LoanClass, Loani Amount. and InterestRate. Delete columns Company, Term and Payment 9 5 10 5 11 5 5 12 Created On: 07/12/2019 1Exp19 Acess_CHO_ML1 - Small Business Loan Grador - Instructions Access 2019 Project 13 5 14 Group the Loan Payments Summary query by the LoanClass field. Display the number of loans in the LoanID column, the sum in the Amount column, and the average in the InterestRate column Run the query Switch to Design view and display the Property Sheet. For the Loani field, change the caption to Loans. For the Amount field, change the caption to Total Amount and change the format to Currency For the InterestRate field, change the caption to Avg Interest Rate and change the format to Percent. Run the query Save and close the query Close all database objects. Close the database and then exit Access. Submit the database as directed 5 15 Total Points 100
To save the object or switch views, right-click the tab. The object can be closed by clicking the X on the tab. Right-click on a tab and choose Close All to close every object.
What query Save and close the query Close all database?The “Save” button in the Quick Access toolbar must be clicked in order to save your query in Access. Enter a name for your query in the dialog box that displays after that. Next, select “OK” from the menu. After that, you can exit the query without losing your query design efforts.
Therefore, The DB->close() method shuts any open cursors, releases any reserved resources, flushes any cached database data to disk, and closes any underlying files.
Learn more about database here:
https://brainly.com/question/24180759
#SPJ4