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

Answers

Answer 1

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


Related Questions

when dave locks his car keys in his office, he uses a knife as a substitute to release the lock's bolt. which statement best describes dave's problem solving?

Answers

When something is known to serve one purpose yet is actually capable of serving other purposes as well, it is said to be functionally fixed.

Is mental set functional fixedness?

The term "cognitive bias" refers to functional fixity. The ability to conceive of something in a novel or creative way is thus constrained because your brain is accustomed to thinking of it in a particular way.

Your brain is highly ingrained with functional fixedness; in fact, it may be seen by imaging.

People can quickly resolve reoccurring issues because to this mental shortcut. However, it also keeps people from recognizing other potential answers to issues. Functional fixedness is a cognitive bias that encourages people to use objects in conventional, predetermined ways.

People's limited ability to solve problems and stifled creativity are results of their blindness to alternative applications of goods. By abstracting issues, you can come up with novel solutions and get rid of functional fixedness.

Therefore, the answer is Dave has overcome functional fixedness.

To learn more about functional fixedness refer to:

https://brainly.com/question/14852720

#SPJ4

What's true about OOP in C++? o One class per .hl.cpp file combination:

a. "this" is a pointer in C++ and therefore we use -> to access from it
b. In C++ structs are fully OOP but it changes the base assumption of visibility from private to public
c. Generally follows a pattern of forward declaration in a .h file and definitions in a .cpp file
d. We can directly deference this to use the dot-operator similar to Java: *this.doStuff()

Answers

Modularity facilitates troubleshooting. When working with object-oriented programming languages, you know exactly where to search for problems.

The only difference is in syntax, not in concept. Instead of line-by-line keywords, Visibility Modifiers are categories. Object-Oriented Programming (OOPs) is a programming paradigm based on the concept of an object, which includes attributes and methods. It integrates a collection of linked features and behaviors into a single unit called a class, which improves program design structure and code readability. Object-oriented programming is supported by three fundamental pillars: encapsulation, inheritance, and polymorphism. Modularity facilitates troubleshooting. When working with object-oriented programming languages, you know exactly where to search for problems.

Learn more about programming here-

https://brainly.com/question/14368396

#SPJ4

What happens when I get a new router?

Answers

Answer:

When you get a new router, you will need to set it up and configure it to your network. This typically involves connecting the router to your modem, connecting it to your devices, and setting up the wireless network.

Explanation:

option 1: untangle a knot you see in the world. option 2: if you had a time machine and could go back in time or into the future for a day, where/when would you go, what would you do, and why?

Answers

Option 1: This could involve anything from a twisted shoelace or a complicated knot in a piece of rope.

Option 2: I would choose to go back in time to the year of the first moon landing.

How to entangle a knot?

The best way to untangle a knot is to start by gently pulling on one of the ends of the knot. This will allow you to see how the knot is structured and how it is tied. Once you have an idea of what the knot looks like, you can use your hands to gently pull apart the individual strands of the knot. Once you have separated the strands, you can carefully use a pair of scissors to cut the knot. Be sure to cut the knot carefully and evenly so that it does not create any new knots. After cutting the knot, you can then use your hands to gently separate the strands of the knot until it is completely untangled.

To learn more about time machine refer to:

https://brainly.com/question/27973693

#SPJ4

Which of the following directories must remain on the same partition?

a. /home
b. /lib
c. /bin
d. /etc
e. /usr

Answers

The file systems for servers' /, /boot, /usr, /var, /tmp, and /home should all be separate. This stops things like temporary and logging space under /var and /tmp from taking up the entire root disk, for instance.

Additionally, third-party programs must to be on distinct file systems, such /opt. The ability to select unique mount parameters that are only appropriate for specific areas of the file system hierarchy is another benefit of using different file systems. Unprivileged users can see the contents of many files since they are world-readable, especially those in the /etc directory. However, if you want to be extra cautious, you can remove the world-readable or group-readable bits for sensitive files. Normally, this is not an issue.

Learn more about program here-

https://brainly.com/question/14368396

#SPJ4

you have been asked to configure high availability for your dhcp service in your network by your chief technology officer. she has requested that you utilize an option that preserves lease information, even if one server fails, and efficiently utilizes all servers for lease assignment. what should you use?

Answers

The load-balancing mode of DHCP failover configuration is recommended. Overriding all other levels are the options specified for the reservation.

What transpires when DHCP options specified in a DHCP reservation conflict with those specified at the scope or server level? Overriding all other levels are the options specified for the reservation.In order to assure a response, the settings must be applied when a server is implementing DNSSEC.By using the Add-DhcpServerv4Scope cmdlet, you may add an IPv4 scope with the required parameters to the DHCP server service.Select Manage > IPAM/DHCP. Then select IPv4 Reservation under Create. Setting up IPv4 and IPv6 Reservation has further details.The load-balancing mode of DHCP failover configuration is recommended.        

To learn more about DHCP failover configuration refer to:

https://brainly.com/question/10097408

#SPJ4

How features are displayed on a map to emphasize their level of prominence describes?

Answers

Visual Hierarchy is the depiction of features on a map to indicate their level of significance.

By using manual or digital techniques, mapmaking entails collecting intricate geographic information and creating a multifaceted visual representation of it. Understanding how to put the map's components together into a logical whole and carry out the communication goal of the map is necessary for creating effective maps. The cartographer's tools for structuring the map and finishing map development are visual hierarchy and layout. The cartographer arranges the mapped geography in a picture into a visual hierarchy by vertically organizing the information and highlighting certain elements while underscoring others. A map's title, the main map, inset map, north arrow, scale, legend, toolbar, etc. are all placed in such a way by the mapper as to direct the reader's attention around the horizontal plane of the map. The order of the images

Learn more about Hierarchy here:

https://brainly.com/question/29103068

#SPJ4

How reliable and accurate is Wikipedia?

Answers

Eight of the nine entries were inaccurate, according to the study, and at least two of the nine Wikipedia articles had significant errors.

How accurate is the Wikipedia?Eight of the nine entries were inaccurate, according to the study, and at least two of the nine Wikipedia articles had significant errors.Wikipedia's overall accuracy percentage was 80%, whereas the other sources' accuracy rates ranged from 95% to 99%. The accuracy of the content is not guaranteed by the online encyclopedia. When scholars skip over the content to look at the references, citations, and sources given, it is regarded as a useful "beginning point." When evaluating the quality of papers, academics advise consulting trustworthy sources. It's also feasible that certain mistakes won't ever be corrected. An edit that corrects a mistake may potentially be later reversed. As a result, Wikipedia shouldn't be regarded as a sufficient source in and of itself.

To learn more about Wikipedia refer to:

https://brainly.com/question/28848406

#SPJ4

Application level protocols are used in a vpn?

Answers

True Application level protocols are used in a vpn,TCP/IP implements other higher-level protocols that are not official Internet protocols but are commonly used in the Internet

The many levels of the TCP/IP Suite of Protocols are depicted in this diagram. The application layer is comprised of the application from the top. UDP and TCP are included in the transport layer. The network (hardware) interface is located in the network layer. Finally, the physical network is included within the hardware layer.

When an application has to communicate data to another application on another host, the information is sent down to the transport level protocols to be prepared for transmission.

The following are the official Internet application-level protocols:

Exterior Gateway Protocol for Domain Names

Name of the File Transfer Protocol/Finger Protocol

The Telnet Protocol

Insignificant File Transfer Protocol

TCP/IP does not support any of these application-level protocols with APIs.

Learn more about Protocols here:

https://brainly.com/question/13327017

#SPJ4

Which of the following is NOT considered file metadata?

a. filename
b. file creation date
c. file contents
d. file attributes

Answers

The one that is not considered file metadata is the filename. The correct option is a.

What is metadata?

File metadata can be thought of as supplementary information about a file that is carried along with it and makes it easier to use and find. It's not the document or photo itself, but rather information about it, such as the file's name, thumbnail image, or creation date.

Metadata, also known as data that describes other data, is structured reference data that aid in the sorting and identification of attributes of the material it describes.

Therefore, the correct option is a. filename.

To learn more about metadata, refer to the link:

https://brainly.com/question/17286145

#SPJ1

in the wireless router lab, when you turned on access control in the router's settings, what mechanism was used to protect your wireless network?

Answers

When access control was enabled in the router's settings, the Enable SSID broadcast mechanism was employed in the wireless router lab to secure your wireless network.

What is wireless network?

Protecting your devices from hackers and online criminals depends on your ability to secure home WiFi networks. By listening to your internet traffic, someone who has access to your local network can readily access your personal information. protocols that safeguard wireless transmissions via encryption. when visiting a website that employs HTTPS. To establish the legitimacy of the website to browsers like Chrome, the website's server utilises a certificate.

A certificate pretending to be any website can be made by anyone. Having many computers or other devices in your home is necessary if you wish to access the internet there.

To learn more about encryption from given link

brainly.com/question/17017885

#SPJ4

4. the owner of csm tech publishing is always thinking about how he can use technology to improve the operation of his business. he read an article about cloud computing and has asked you to explain what cloud computing is and whether he needs it now or in the future for more efficient operations. write a memo explaining what cloud computing is and whether you recommend using any form of it now or in the future.

Answers

People typically have negative perceptions of disturbance when they hear it. Our access to electricity is disrupted by downed power lines, obnoxious neighbors, sunspots, and trains derailing, and sleep is disturbed by noisy neighbors.

What is Digital Disruption?The term "digital disruption" refers to a shift in expectations and behaviors brought on by or manifested through digital capabilities, channels, or assets that fundamentally transforms culture, market, industry, or process.Digital disruption is the term used to describe the change that occurs when new digital technologies, services, capabilities, and business models influence and alter the value of the sector's current services and products. These new factors alter or disturb the status quo, requiring companies to reevaluate the current market for goods and services and maybe make adjustments.The advancement of technology has frequently overthrown the status quo throughout history. Electric lights overtook candles and oil lamps, mobile phones eliminated the dominance of landlines, and radio stars were slain by video as the automobile supplanted the horse-and-buggy.In the end, disruption brought on by digital technology means change, which may be both good and negative. Although it is a distinct species, digital disruption is. Let's take a closer look at the components of digital disruption to better understand what makes it distinctive.

To Learn more About disturbance refer to:

https://brainly.com/question/1385379

#SPJ4

Is it better to buy on credit or cash?

Answers

You could have to pay interest if you finance a purchase, and this might mount up.When you pay with cash or a debit card, you will only be required to pay the purchase price.

Which is preferable, paying with cash or a credit card? You might pay interest if you finance a purchase, and interest charges might mount up.When you pay with cash or a debit card, the whole cost of the purchase is all you'll pay.You can prevent interest costs on new purchases by making cash payments.Additionally, if you have activated a penalty APR on your credit card, it could be a good idea to pay with cash since additional charges could result in interest charges of nearly 30%. There are certain drawbacks to using credit as well.Credit almost always carries a cost.You must assess if the item is worthwhile considering the additional cost of interest paid, the rate of interest, and any fees that may apply.

To learn more about credit card refer

https://brainly.com/question/28800758

#SPJ4

Identify computerized learning tools typically used in staff training Describe how you determine which tools to use (rationale Describe how each tool is used within the training process -ie part of training process on-going support reference, etc

Answers

Computerized learning tools was the based on the Spreadsheets, Databases, CAD modelling, and the other tool was the based on the training process.

What is learning?

Learning is the process of gaining new knowledge, understanding, behaviors, skills, values, perspectives, and preferences. Humans, animals, and some robots all have the potential to learn; there is also evidence that certain plants can learn.

There are the common tools on the computerized learning as the digital adoption platforms, Video Training Software, CAD modelling, Spreadsheets and the other tools as the based.

Learn more about on learning, here:

https://brainly.com/question/1503472

#SPJ4

Project: Design a store database Create your own store! Your store should sell one type of things, like clothing or bikes, whatever you want your store to specialize in. You should have a table for all the items in your store, and at least 5 columns for the kind of data you think you'd need to store. You should sell at least 15 items, and use select statements to order your items by price and show at least one statistic about the items.

Answers

For all system and app interactions, Shopify depends on a well-maintained database. The question of how to directly access Shopify databases is frequently asked.

What store database Create your own store?

A shopping cart database will have all the necessary data on goods, orders, and clients and will enable users to make real-time modifications that will be reflected in their shopping sessions. To keep all the order details, the database may include immutable structures or a distinct table.

Therefore, You can better choose who to promote your goods to by using the information they can store. Data, for instance, can give you precise information on the demographics of customers for specific goods, such as their age, gender, ethnicity, etc.

Learn more about database here:

https://brainly.com/question/19697205

#SPJ4

Alex, a system administrator, wants to grant NTFS permissions to a user so they can view and change files but not change permissions. Which of the following permissions should be used?
answer choices
Modify
Full Control
Read & Execute
Read

Answers

The NTFS permission should be used by system administrator to allow user view and change files is Modify.

What is Modify permission?

Modify permission is one of type in NTFS permissions. This permission will allow the user to have a all control including read, write, and delete a folder, subfolder, and file. But this doesn't allow the user to change the permission.

Full control is same as Modify but it change permissions. Thus, Alex wants to grants the user permission to view and change files but not change permissions, the correct permission should be used is Modify.

Learn more about NTFS permissions here:

brainly.com/question/14178838

#SPJ4

calling a function with name _ is done with free_func()​

Answers

In regards to calling a function with name _ is done with free_func()​, It is generally not a good idea to name a function with an underscore as the first character. In many programming languages, including Python, names that begin with an underscore are considered private or "special" and are typically used to indicate internal implementation details of a class or module.

These names are not intended to be accessed directly by users of the class or module and are subject to change without notice.

What is the calling function about?

It is possible to call a function with an underscore in its name, but it is generally better to use a more descriptive and meaningful name for your functions. This can help to make your code more readable and maintainable, and can also help to avoid potential conflicts with reserved words or other special names in the language.

So, For example, instead of using a name like _func, you might consider using a name like process_data or calculate_result, depending on the purpose of the function.

Learn more about function from

https://brainly.com/question/2328150

#SPJ1

what is the essence of recursive programming? group of answer choices a function calling the call stack to compute the next iteration. a function calling itself until it reaches a base case. an iterative function called a factorial number of times. applying euclid's algorithm to an iterative function.

Answers

A recursive function is a piece of code that executes by referencing itself. Simple or complex recursive functions are both possible.

What Does Recursive Function Mean?A recursive function is a programming construct that executes by referencing itself. Recursive procedures can be straightforward or complex. They provide more effective code development, for example, when listing or assembling collections of integers, texts, or other variables using a single repeated procedure.In programming, recursive operations frequently rely on the construction of loops, where the initial variable is called repeatedly while being changed by the loop. The factorial function is a straightforward illustration of a recursive function because it multiplies a number by itself while lowering it sequentially. Recursive functions can relate to a variety of additional self-referential looping functions, such as those where n = n + 1 is given an operational range.Programmers and others have created far more complex functions that also use the recursion concepts in addition to the more straightforward recursive functions. While some, like the Fibonacci sequence, are used in banking and other fields, others are more esoteric and mostly restricted to the IT industry.

To Learn more About recursive function refer to:

https://brainly.com/question/14268231

#SPJ4

Describe and give examples of the four types of effects that are categorized in the cumulative effects of media theory.

(Don't use plagiarism only in your words)make
it short

Answers

The social media theory focuses on the potential impacts of exposure to information shared through social media, which is now so common and significant to the general public.

What is meant by social media theory ?

The social media theory focuses on the potential impacts of exposure to information shared through social media, which is now so common and significant to the general public.

According to the potential impact they can have on society, these effects have been divided into four major branches. The following are the four categories:

1. The Force Theory: In order to accomplish certain objectives and create certain laws, a small group of individuals may take over a location by force.

2. The theory of evolution asserts that the state merely developed from close family ties.

3. The Divine Right Theory: According to this idea, God established the state and grants some particular subjects the "divine right to rule."

4. The Social Contract Theory, which expresses the notion of the state as a free people's voluntary behaviour.

To learn more about Social media theory refer to :

https://brainly.com/question/13909780

#SPJ1

you're planning to install linux on a system that you've built out of spare parts. several components in the system aren't listed on your distribution's hcl. this system will be used by your team's administrative assistant to manage employee schedules, send and receive e-mail, and track employee hours. what should you do?

Answers

Each system has three components: input, process, and output. Each system contains three components in its most basic form.

What's a hardware store mean?

The physical elements or delivery mechanisms of the computer are referred to as hardware. They are what the software uses to store and execute the written instructions. The device's intangible component—its software—allows the user to communicate with its hardware and give it instructions on how to carry out particular activities.

A computer system is made up of five major hardware parts: input, processing, storage, output, and communication devices.

According to our statistics, hardware shops typically sell for between 0.37 and 0.74 times their income. Add the revenue or sales a firm generates to the valuation multiple to get the value of the company.

Each system has three components: input, process, and output. Each system contains three components in its most basic form. Input, Process, Output is what I'll refer to as this as.

Therefore, the answer is Replace the incompatible parts with supported hardware.

To learn more about hardware refer to:

https://brainly.com/question/28558426

#SPJ4

Other Questions
Consider the following business activities and classify each of the items by type of business activity: operating, investing, or financing 1. Cash receipts from customers paying for daily ski passes Type of Activity Operating 2. Payments made to purchase additional snow-making equipment Investing 3. Payments made to repair the grooming machines Operating 4. Receipt of funds from the bank to finance the purchase of the additional snow-making equipment Financing < 5. Issue of shares to raise funds for a planned expansion Financing 6. Repayment of a portion of the loan from the bank Financing > 7. Payment of interest on the bank loan Operating 8. Payment of salaries to the employees who operate the ski lifts Operating 9. Receipt of a grant from the government for training a group of disabled skiers Operating 10. Payment of dividend to shareholders Financing In ___________ administration, you are administering medication to yourself or your partner.Select one:A. patient-assistedB. peer-assistedC. EMT-administeredD. paramedic-administered Miguel earns extra money working two weekends with his dad. He is saving to buy a new bike that costs $140. Heather says that Miguel needs to earn more than $6 for each hour that he works to have enough money to buy the bike. Her work is shown below. Write an inequality to explain why she is incorrect Which source would be most reliable for researching the most effective types? Freight forwarders arrange transportation only by ocean shipping True False A heavy stone and a light stone are released from rest in such a way that they both have the same amount of gravitational potential energy just as they are released. Air resistance is negligibly small. Which of the following statements about these stones are correct? (There could be more than one correct choice)a) The stones must have been released from the same height.b) The stones both have the same kinetic energy just as they reach the ground.c) The stones both have the same speed just as they reach the ground.d) Just as it reaches the ground, the light stone is travelling faster than the heavy stone.e) The initial height of the light stone is greater than the initial height of the heavy stone. What is 3 oxygen called? How does Nick describe himself at the beginning of the book chapter 1 The Great Gatsby? an electric utility operates in a state with right-to-work laws. about three-quarters of its line workers have elected to join the union that represents them. james, one of the line workers, believes that his supervisor is unfairly passing him over when selecting employees to earn extra pay by working overtime. james wants to file a grievance according to the process in the labor agreement, but he is not a member of the union. what must the union do in this situation? Briefly embellish the virtues of structured Programming approach. REMPLACER Rcrivez ce texte au prsent.Quand vint la pleine lune, Hansel prit sa petiteseur par la main et ils suivirent les petits caillouxblancs, tincelants comme des sous neufs, qui leurmontraient le chemin. Ils marchrent ainsi toutela nuit et n'arrivrent chez eux qu'aux premiresheures de l'aube. Ils frapprent alors la porte.Quand la mchante femme ouvrit et les reconnut,elle se fcha. A student was attempting to write an inequality that she could use to find how many more hours she had to work at her job to buy a bicycle. The student had alreadysaved $55 and earns $9 per hour at their job. The student will need at least $199 to buy the bicycle.Look at the student's inequality below. Find and explain the student's error in writing her inequality.h = the amount of hours worked55+9h 199 What percent of MgO is Mg? The ""video commissioner"" is employed by what segment of the music industry? Find the point of intersection between a line that is tangent to the function () = x^2 + 4 at = 1 , and the function () = x^2 4 P(x)= 1/2x^2+3x-4x^3x+6x^4-1 write in standard form, is it polynomial, what degree, type, and leading coefficient is it? The height of a triangle is 8 centimeters greater than three times its base. The area of the triangle is 128 square centimeters. What is the base of the triangle?(Hint: area of triangle=12baseheight)40 cm8 cm5 1/3 cm16 cm The members of NATO agree to: A. defend other member countries if they are attacked.B. remove all barriers to free trade. C. limit the spread of democracy globally. D. provide loans to undeveloped nations. Q30: Work out the surface of the following prism The second concept of Confucianism that relates to how people should treat one another is..A. Humanity B. Karma C. Dao D. Tao