Rename a Field in a Table in Access: Overview You can rename a field in a table in Access that you have already created. You should be extremely careful when you do this! This is because any changes you make to field names are not necessarily updated in all the previously created objects. This
Wildcard Characters in Access: Overview You can use wildcard characters in Access to add an additional level of flexibility to your query criteria. Wildcard characters within query criteria in Access represent unknown values. The asterisk “*” and the question mark “?” are the two main wildcard characters in Access
Create Input Masks in Access: Overview You can create input masks in Access to dictate a pattern used for data entry in selected fields. Access provides an easy step-by-step routine called the “Input Mask Wizard” to do this. The “Input Mask Wizard” helps you apply input masks to selected “text” and “date/time” fields.
The Format Property for Yes/No Fields in Access: Overview You can set the Format property for Yes/No fields in Access to change the way that they will display in forms and reports. The following formats are available for logical fields in Access. To set the Format property for Yes/No fields in Access, simply select
Access or Excel DAO in Crystal Reports 2013: Overview You can use Access or Excel DAO in Crystal Reports 2013 to connect an Access database or Excel workbook to a report. If you click the small plus sign next to the “Access/Excel (DAO)” folder in the “Create New Connection” section of the “Database Expert,”
Delete a Table Field in Access: Overview You can delete a table field that you do not use from a table in an Access database. Once again, as when changing a field name, make sure that there are not any queries, forms, reports or macros that refer to the field or use data contained
Make Table Queries Have you ever run a query and wished that you could save the result set of the query as a permanent table? In Access, that is exactly what the “Make Table” queries do. A “Make Table” query creates a new table as the output of a query, instead of simply displaying a