Explore BrainMass
Share

Access Wildcards

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Here's what Access says about searching for wildcards:

When using wildcard characters to search for other wildcard characters such as an asterisk (*), question mark (?), number sign (#), opening bracket ([), or hyphen (-), you must enclose the item you're searching for in brackets. If you're searching for an exclamation point (!)or a closing bracket (]), you don't need to enclose it in brackets. For example, to search for a question mark, type [?] in the Find dialog box. If you're searching for a hyphen and other characters simultaneously, place the hyphen before or after all the other characters inside the brackets. (However, if you have an exclamation point (!) after the opening bracket, place the hyphen after the exclamation point.)

You can't search for the opening and closing brackets ([ ]) together because Microsoft Access interprets this combination as a zero-length string. You must enclose the opening and closing brackets in brackets ([[ ]]).

So, if I had a table named X with column TEXT_FIELD with values:

a b c d e f
ab*cd*ef
a_b_c_d_e_f

and wanted to search for a row that actually had asterisks in it, what would I put in the blank?

SELECT x.TEXT_FIELD
FROM x
WHERE x.TEXT_FIELD Like _______;

© BrainMass Inc. brainmass.com October 16, 2018, 7:56 pm ad1c9bdddf
https://brainmass.com/computer-science/searching/access-wildcards-132324

Attachments

Solution Summary

Searching for wildcards is demonstrated.

$2.19
Similar Posting

Access DATABASE

Professional Litigation User Services (PLUS) creates all types of visual aids for judicial proceedings. Raj Jawahir is working with the Payments database to track and analyze the payment history of PLUS clients. He again needs your help. He would like you to enhance the Payments database by completing the following:

WHEN DOING THIS ASSIGNMENT PLEASE REFER TO THE GUIDELINES ATTACHED BELLOW

1. Start Access, and then open the Payments database located in the 'le3 folder' zip file (bellow).

2. Define a one-to-many relationship between the primary Firm table and the related Payment table. Use the Payments table (bellow). Select the referential integrity option and both cascade options for the relationship.

3. Use the Form Wizard to create a form containing a main form and a subform. Select the Firm# and FirmName fields from the Firm table for the main form, and select all fields except Firm# from the Payment table for the subform. Use the Datasheet layout and the Industrial style. Specify the title, 'Firm Payments', for the main form and the title, 'Payment Subform', for the subform. Resize all columns in the subform to their best fit. Take a screen shot of the first main record and its displayed subform records.

4. For the form you just created, change the AutoFormat to Sandstone, save the changed form, and then take a screen shot of the first main form record and its displayed subform records.

5. Navigate to the second record in the subform for the first main record, and then change the AmtPaid field value to 1,800.00.
6. Use the Find command to move to the record with the Firm# 1142 and delete the record. Answer Yes to any warning messages about deleting the record.

7. Use the appropriate wildcard character to find all records with the abbreviation "DA" (for District Attorney) anywhere in the firm name. (Hint: You must enter the wildcard character before and after the text you are searching for.) How many records did you find?
Close the Firm Payments form.

8. Use the Report Wizard to create a report based on the primary Firm table and the related Payment table. Select all fields from the Firm table except Extension, and select all fields from the Payment table except Firm#. In the third Report Wizard dialog box, specify the PLUSAcctRep field as an additional grouping level. Sort the detail records by AmtPaid in descending order. Choose the Block layout, Landscape orientation, and the Bold style for the report. Specify the title, 'Payments By Firms' for the report.

9. Insert the PLUS picture, which is located in the
href="/courses/ITD340/u2/LEFiles.zip">'LEFiles' zip file in the le3 folder, in the Report Header section of the Payments By Firms report. Leave the picture in its original position at the left edge of the report header.

10. Use the Office Assistant to ask the following
question: "How do I move an object behind another?" Click the topic, "Move a text box or other control in front of or behind other controls." Read the information and then close the Help window. Make sure the PLUS picture is still selected, and then move it behind the Payments By Firms title.

11. Use the Office Assistant to ask the following question: "How do I change the background color of an object?" Click the topic, "Change the background color of a control or section." Read the information and then close the Help window and hid the Office Assistant. Select the Payments By Firms title object, and then change its background color to Transparent.

12. Display the report in Print Preview.

? Submit your screen shots and a copy of your Access file. Remember to include the answer to question #7 in your Word document.

View Full Posting Details