Computers and Technology, 03.04.2021 05:30 61497

Microsoft access: 1. Open the Customer Loans Parameter query in Design view. Add criteria for the Amount field. The user should be prompted to Enter Minimum Loan Amount (no period). The query should display all records that have a loan Amount that is greater than or equal to the value entered as the parameter. Run the query. Enter 400000 when prompted to Enter Minimum Loan Amount. You should have two results. Save and close the query.
2. Open the Missing Addresses query in Design view. Add a new column to determine if a customer does not have an address on file. If the customerâ€™s Address is null, it should display Missing. If not, it should display nothing. Name the column AddressPresent. Add criteria of Missing to the column you just created, so only the customers missing an address display. Move the AddressPresent field so it appears between PhoneNumber and Address. Run the query. Ensure only customers with null Address fields display. Save and close the query. (What is this formula?)

Answers: 3

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 25.06.2019 05:50, jonmorton159

Acolor class has three public, integer-returning accessor methods: getred, getgreen, and getblue, and three protected, void-returning mutator methods: setred, setgreen, setblue, each of which accepts an integer parameter and assigns it to the corresponding color component. the class, alphachannelcolor-- a subclass of color-- has an integer instance variable, alpha, containing the alpha channel value, representing the degree of transparency of the color. alphachannelcolor also has a method named dissolve (void-returning, and no parameters), that causes the color to fade a bit. it does this by incrementing (by 1) all three color components (using the above accessor and mutator methods) as well as the alpha component value. write the dissolve method.

Answers: 2

continue

Computers and Technology, 25.06.2019 17:00, 22iungj

Match each word to its correct meaning. 1. quick launch an area that displays icons representing open applications 2. shortcut an icon used to represent an application, a file, or a folder 3. start menu an area on the taskbar where icons representing programs that are always running are displayed 4. system tray a list of programs that can be opened by clicking on their names or icons 5. taskbar an area on the taskbar from which frequently used programs can be opened pls. will get brainlist

Answers: 1

continue

Computers and Technology, 25.06.2019 21:10, guccim5971

Steps for turning off two step verification on ,for example, iphones.

Answers: 1

continue

Computers and Technology, 26.06.2019 07:00, 1991987

Bryan has e-mailed his boss, shauna, asking if he can leave work early next friday. which choice best describes bryan in this communication scenario? 1. the sender of the message 2. the receiver of the message 3. a barrier to the message 4. a source of the message

Answers: 1

continue

You know the right answer?

Microsoft access: 1. Open the Customer Loans Parameter query in Design view. Add criteria for the A...