by Maryrose | Nov 2, 2022 | Access, Microsoft Office
Add a “wildcard” to your queries! You can use a wildcard in a query in place of one or several characters. Wildcard characters are helpful when you want to find criteria with a pattern (such as all last names beginning with M), or if you are not sure...
by fccadmin | Jul 26, 2013 | Access, Microsoft, SQL
Access gives you the easy to use query design grid interface for combining data from tables that share one or more related fields. It’s simple to use and generally effective. However, there are still some times when the query design grid isn’t enough to...
by fccadmin | Nov 13, 2012 | Access, Microsoft, Microsoft Office
This wizard will show duplicate records in a single Microsoft Access table, based upon the values of a field in the table. In an Access database, there may be times when you’d like to make sure that there are no duplicate records in a table. The Find Duplicates...
by fccadmin | Nov 13, 2012 | Access, Microsoft, Microsoft Office
Searching for a specific record in Microsoft Access You can search for a specific record in a table or form by using the Find tab in the Find and Replace dialog box. This is an effective choice for locating a specific record when the record that you want to locate...
by fccadmin | Nov 13, 2012 | Access, Microsoft, Microsoft Office
Using the Report Wizard to Group and Summarize Data The Report Wizard provides options for grouping and summarizing report data. You can organize your report by selecting the fields into which you want to group data. If you create more than one group, you can...
by fccadmin | Nov 13, 2012 | Access, Microsoft, Microsoft Office
Looking for another great time saver? Make the data entry job just a little bit easier! You can set a default value for a field — that value will automatically appear in the field for all new records. You can still modify the default field value as needed when...
Recent Comments