tbinv.com

Frequently Asked Questions

Overview:

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 web version lets school users transfer books and view reports with their internet browser. They don't have to be connected to the district LAN and they don't need Microsoft Access. The Access version provides a more robust user interface than the web version and should be used whenever possible.

This involves running a simple web server using Microsoft Internet Information Server(IIS) and Active Server Pages (ASP) on an NT 2000 Pro or XP Pro workstation on the district Super user's PC. It requires a fixed IP address and security becomes much more important. The savings can be significant even with the greater administration expense.

The district Super user may also have an import database to import student and schedule information from district.

Sitemap