Agee Software's Textbook Inventory application, TBInv is a Microsoft Access database to account
for textbooks in the school district. There are two levels of user: Super and User.
At district, a Super user can do the following:
- Import course, class, student and schedule data from the district's other systems.
- Use TBInv forms to update tables (Book, Vendor, Subject, BookType, School, Course,
Class, Teacher, Student, User, Transfer, Budget, Setup and the tables that relate them).
- Add users to the system and grant them Super user privileges if necessary.
- Open reports to ensure consistency and data integrity.
- Adjust inventory.
- Enter final resolution of lost books.
- Append, Delete or Merge tables.
- Force users off system to compact or restore database.
- Perform all functions of a User for any school.
At each school, Users can do the following:
- Transfer books to or from their school manually or in batch.
- View Book, Class, Student and User forms for their school.
- Use Inventory form for quick inventory.
- Use Issue form to create transfers with barcode scanner.
- Track losses in their school on Loss form.
- View most forms read-only.
- Change their password and email address.
- View reports from all the tables. They can't see data integrity reports unless they can edit the data.
Most reports are filtered for the user's school.
- Export any report to Excel CSV or XLS, Wordpad RTF, DBF or text.
In order to optimize performance for the district Super user, the back end (data tables) database
is normally located on the Super user's PC. Each school user has a copy of the front end (queries,
forms and reports) database and an MDW (security) file that lets him or her connect to the shared
back end on the district Super user's PC.
The district Super user may also have an import database to import student and schedule
information from district.