Database Manager
CheckMark 1095 stores employer data in a database. When initially opening CheckMark 1095, a database named CheckMark_1095_ Database_[year] is created.
If you complete 1095 forms for only one employer, this is probably the only database you will need.
However, if you process forms for more than one employer, you will need to choose one of the following options to manage your companies correctly. You can either store all of your employer files in the same database, or you can create separate databases and store individual companies in them.
Storing Multiple Employer Files in the Same Database
Each database can contain multiple companies. The advantage of storing all of your different employer files in one database is that when you Backup Database, Restore DataBase, Close Database, or advance to a new year, all companies stored in that database will be backed up, restored, closed or advanced to a new year at the same time, saving you time.
Storing Employer Files in Separate Databases
The advantage of storing each of your employer files in separate databases is that you have more control over where your database is stored on your computer, as well as when you want to Backup Database, Restore Database, Close Database, or advance companies to a New Year.
Using the Database Manager
Choose Database Manager from the File menu.
Create New Database
This option allows you to create and save a new database in any location you wish. Keep in mind that each database can store multiple companies.
- Click Create New Database.
- Enter a Database Name and Payroll Year. Click the Browse button to select a new location to save the database.
- Click Create Database to save the new database.
Add Database to List
This button allows you to add an already-existing database to the list. For example, if you copied a database from another computer and the Database Manager does not list this database, you can choose Add Database to List and browse to that location to update the Database Manager’s list.
- Click Add Database.
An Open dialog box appears
- Browse to the location where the database is saved.
- Select the database and click Open.
The database is added to the list in the Database Manager.
Rename Database
This option allows you to rename the database. It is recommended that you use only alpha-numeric characters.
- Click Rename Database. The following alert appears:
- Click Yes. Otherwise, if you don’t want to rename at this time, click no
- Enter the new name and click Rename Database to save.
The Rename Database window appears:
Remove From List
This option allows you to remove a database from the list.
Note: This only removes the listing in the Database Manager. It does not delete the database file from the saved location. To delete a database, you will need to manually delete the database (.db) file from your hard drive or saved location.
- Click Remove From List.
A Warning message appears
- Click Yes to remove the database from the Database Manager list.
You can add the database again at anytime by using the Add Database command as long as you don’t delete the database from the computer.
Open Database
This option allows you to choose a different database and open it up to view all saved companies in that particular database.
- Select the database you want to open and click Open Database.
The new database is now open and all companies stored in this database are now available.
Close Database Manager
This option closes the Database Manager window.
Update Employer
This commands allows you to update the currently selected employer’s information. Once the program is launched, open the database that contains the employer you want to update. Highlight the employer Employer and click the Update Employer command. Enter the information you want to change, then click Update Employer to save the changes.
New Employer
This Command allows you to add a new employer to the database that is currently open. Once the program is launched open the database you wish save the employer in. Click New Employer then enter the information for this employer. Click Add Employer to save the employer to the database.
Delete Employer
This command allows you to delete an employer from a currently opened database. Once the program is launched open the database that contains the employer you want to remove. Click Delete Employer and a screen will appear to make sure you want to delete the employer. Click Confirm Delete to complete the deletion process.
Exiting CheckMark 1095
To exit or quit CheckMark 1095:
- Choose Exit from the File menu (Windows)
- Choose Quit from the CheckMark 1095 menu (Mac)