Tag - Access

26
Jul

Why use SQL when you have Access?

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 get the job done. Consider the situation where you have two …

13
Nov

Access 2010/2007 Find Duplicates Query Wizard

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 Query Wizardwill quickly find the duplicate records …

13
Nov

Find and Replace in Microsoft Access

Searching for a specific record 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 satisfies specific criteria, such as search terms, and …

13
Nov

Grouping & Summarizing Data in Microsoft Access Reports

The Report Wizardprovides 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 prioritize the groups into levels.In addition to grouping data by a field, you can add grouping intervals. Grouping intervals vary, …

13
Nov

Setting Default Values for Fields in Microsoft Access

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 entering a new record. For example, …

13
Nov

Making Microsoft Access Form & Report Controls Grow

Did you ever notice that when you print an Access report, some of the text is missing from variable-length fields (e.g., a text or memo field)? If there is too much text to display in the text box, the text is truncated (cut off).   Instead of resizing the control to be a set length, …

13
Nov

Using the Microsoft Access Calendar for Date Picking

Open your Form in Design View. Press F4 to open the Property Sheet. Select the desired date field from the Selection Type dropdown list at the top of the Property Sheet. Select the Format tab on the Property Sheet. In the Show Date Picker field, select For dates. Select Save, then close form. Note when …

13
Nov

Microsoft Access – Align Your Text with a Stroke of the Keyboard

Here are a few keyboard formatting tips when viewing a form or report in Design View or Layout view: To align the text in a selected control to the left, press CTRL+L. To align the text in the selected control to the right, press CTRL+R. To center the text in the selected control, press CTRL+E. …