ReadMe - GaryHostt/Training_repository GitHub Wiki

Training database How to change backup location

  1. Click File, options, trust center, trust center settings, trusted locations, add new location. Here add the new directory

  2. Open the developer tab by pressing visual basic (on the right) on the create tab, select module 1

  3. Replace the highlighted text with the directory where you would like the backups to be saved

How to restore a backup set of tables

  1. If the database becomes corrupted, or information is deleted, the front end of the database can be relinked with one of the daily automatic backups. a. First, delete or move the backend file so the front end isn’t looking for it there
  2. When opening the database you'll see this
  3. This means the database can’t find the tables, go to the external data tab on the ribbon and press linked table manager
  4. On the popup, press select all then ok. On the new popup, select the most recent backup and the database will work again.

How to change a users’ level, password, login name: On the left under administrative controls, press the user revision/deletion button. Here change the username and userlogin to how the user would like it to be displayed upon logging in (note: must be the same). Password, change as desired User type: 5 is access to the normal database w/ auditor, trainer, and training version access. 4 is full DBA access Levels 1 – 3 are all basic access. How to input an entire new training: Press New type of X Training on the left of the DBA Main screen and enter the information as needed New Line/user/employee: Click the respective button under administrative controls and enter the information as requested How to edit training: Note: seriously try not to need to do this Click training revision under administrative controls, and then the department for which the entry is in Look for the training that contains the employee and the training you need to edit, you can sort what is displayed by clicking the small arrow next to “multiple training” and “multiple employees” Click the drop down menu in the incorrect record and uncheck as necessary How to edit/add trainers/auditors and employee activity status: Note: only available to level 4 and 5 users Click the main menu button on the left and then click the update trainers, auditors, and activity button Change the textboxes for employees as necessary, you can sort with the small arrows facing downwards next to the column headings

How this database was uploaded to GitHub