There are numerous wildcards that you can use in your queries. Use the Access Help system to find out more about wildcards in Access.
Start Access. From the Help menu, click Microsoft Office Access Help. Click in the Search for box, type wildcards and then press . Scroll the displayed list as necessary, and then click About using wildcard characters or Access wildcard character reference. The list of topics depends on whether you are connected to the Internet. Review the information shown in this topic.
If you would like to keep a copy of this information, click the Print button. Click the Close button in the top right corner of the Help window to close the Help window and then close Access.
GO! with Microsoft Office 2003 Brief (2nd Edition)