Jim,
I would work with a copy and use one of the Access find and replace tools. One of these could save you tons of time and frustrations. Search the web for "Access find and replace tools".
Regards,
Duane
Sent: Tuesday, January 30, 2018 9:26 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Access Database schema type question
Hello all,
Not sure if I have this correct but I am rebuilding a database that has about 50 objects, many related to 1 topic for Accruals for Employees. I was thinking of renaming the objects with a naming convention that will better identify the objects related to Accruals. Right now the objects seem to be all over the place. mostly because we moved many objects from another database that had Accruals also. we are trying to get all of the objects into a database with other related information.
My questions are is it worth it or is there are a naming convention that has worked for others? The Database also has Scheduling data, Timesheet data and employee reports.
I was thinking of for example of the following
qryAccruals_UpdateVACAccrual
qryAccruals_UpdateCOMPAccrual
tblAccruals_AccrualsForReport
qryAccruals_DeleteSupvListTempTable
qryAccruals_AppendtblSupervisorListTotblSupvTemptbl
rptAccruals_AccrualSummary
What are the thoughts of the group?
Thank You
Jim Wagner
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar