What is Table Builder?

Before we start with the Jet Table Builder, let's review the definition of an Excel table. A table in Excel is similar to a mini database in Excel. Each row contains one and only one record, and all rows and columns are related to each other and work as one. Using a range of data in a single group (or grid), the data is easier to manage and use in other Excel features such as PivotTables. Jet Express for Excel provides us with the ability to create table directly from our GP data.

Tip

GP usually stores open, work, and history data in different tables. This is another great reason to use views. A view can be created to access all these tables so that you can have all corresponding data on the same report without having to link the tables together yourself. If you create an incorrect link, your data will not be correct.

Create a general ledger trial balance

Now, let's do what we came to do here: write a report in Excel. In the next chapter, we'll build some financials statements...