Edit Form Fields. Aside from creating form fields, you will also want to edit existing form fields. This is done pretty easily using the built-in tools in Acrobat. I will take you through editing field properties using the Fields area of the Forms task pane, duplicating fields, aligning, and more.
When maintaining an Access database, it's a good idea to regularly remove duplicate records. Duplicate records can pop up even with proficient data entry processes. For example, the same customer might be listed twice under two different account numbers. Or, two different customer records might have the same address in their Street Address fields, only one of which is correct. Thankfully, record removal doesn’t have to be a long and tedious process; you can find these discrepancies in seconds using the Find Duplicates Query wizard. Using the wizard To show how this technique works, we will use the Find Duplicates Query wizard to determine which customers in the Customers table, shown in Figure A, have the same address assigned to their Street Address fields. (Note that while the sample table used here has less than 20 records, the same technique can be applied to a database of any size.).
Figure G Deleting duplicates with Append Query In the above example, only two duplicate records were found. But what if the Customers database consisted of thousands of records, and after running the Find Duplicates Query wizard, the results showed hundreds of duplicate records? Manually deleting all those duplicates from the query results table would be highly impractical. Instead, you can use Append Query to have Access delete them automatically.
First, create a copy of the structure of the table that contains the duplicates. Click on the table name Customers in the Database Window, and then click the Copy button in the toolbar. Next, click the Paste button, which will display the Paste Table As dialog box shown in Figure H. Enter a name for the copy of the table structure, as shown. Under options, select Structure Only.
Click OK to create the blank Customers Without Duplicates table. Figure L The query results table will have only one record for each street address. When you are satisfied that the Customers Without Duplicates table is correct, you may delete the original table. When to use the wizard As shown in this article, the Find Duplicates Query wizard works well when it is used to check for duplicate entries in individual fields and when the changes are small enough to be handled manually; otherwise, it is more practical to use the Append Query when you need to delete large numbers of duplicate records. Nevertheless, to keep your data clean, it’s a good idea to run the Find Duplicates Query wizard periodically; if you do, you may never need to run an Append Query. Calling all Access masters If you consider yourself an Access 2000 master, it's time to ante up.
Duplicate And Remove Web Form Designs Using Touch Forms Pro For Mac Pro
And share your best Access tips and tricks. Related Topics.