Tip:
Highlight text to annotate it
X
this video shows you how to find lost an incomplete records in a really
ari automatically time and date stamps each record
as its added to the system
anysuch changed
the fields are restricted by the system so that users can modify the manually
you can sort your tables and query them by those fields
which makes it easy to get records that no one is modified in a long time
first open the table you want to update all open contacts
next click to sort drop-down combo box at the top of the window
click sort
clear the selected window by clicking the double back a row
in the list of fields scroll down to date modified
and double click it
that should put the field in the selected window
you can select any other fields you want after it but the important one is date
modified
if you think you use the sort a lot
you can click the save button to save it in the list of sorts
click save
given a name
and click ok
then click okay to such a short order
to go to the first record
click the go-to beginning arrow
since your database is sorted by date modified
the first record will be the one you have not modified in a long time
and the last record will be something that was modified just recently
you can start updating the records and as you make a change to the record and
save the changes
aria will automatically update the date modified field for you
and showed at the bottom of the window along with your idea so everyone knows
when
and who left dot if i did record
you can use the same method define records that were created in the system
by changing the field to date created
could also query bible police fields
click the query drop-down combo
and choose query
set the field to date created or date modified
select your operator
and type in the dates you want
then click okay
that will return the records that were created or modified in that date range
mixing the query insert functions together
you can really hone in on specific records to update in your system
another query i like to use is the empty query
for example we like to have the email address for every client
so i right-click in the field i want to query in this case it's email address
and choose query
for the operator i choose is empty
and then click ok
that returns all the records in my database to don't have an email address
and i can start updating them
the is empty query works for every field in your database
so you might try a query for email phone cell facts an address for all empty
mean you have no way to contact the client
and then get rid of those records
you could export them although excel first if you want to just archive them
basically using the is empty query along with date modified didn't get rid of a
lot of waste in your database that's just sitting around collecting dust
and make it difficult to get the money generated records in your system
this concludes the video on finding lost an incomplete records an r_e_i_t_
for more information please watch the videos join the live webinars and read
the help file an aria manual all located under the help menu no really