Finally, your table structure will look like what’s shown in Figure 3. Next, from the options at the bottom of the window, choose Auto increment, so that each record will have a unique number. First, in order to define this field as the primary key, right-click on the field and select Primary Key from the pop-up menu. The field named empidis meant to have a unique number that will uniquely identify the record, and so will require some modification. In this case, I have stored the image files (PNG and JPG files) in a directory named base. The path is not required if the photo is stored in the same directory as the database.
Therefore, the field named photo will store the path and file name of the photo image file. I want to have an employee photo, but not store the actual image in the database, since image fields consume too much memory, and tend to slow down the system. Since the address will contain more than one line, we use a memo-type field, LONGVARCHAR. Some fields require special explanation, such as address and photo. Here, VARCHAR are character-type fields with variable length, and INTEGER are numeric fields. Your table will consist of the following fields, as shown in Figure 2: Name This will open a new window in which you define the fields for the table. First select Tables and click Create Table in Design View. Here, as you can see, the window contains four icons, for Tables, Queries, Forms and Reports. After saving the database, a new screen will appear, as shown in Figure 1. Name the database (I named mine “personal”) and click Save. In the next screen, select Register my database and click Finish. Select Create new database and click Next. To create your first database, launch Base from your application menu. Forms are used to provide a user-friendly interface to data from tables or queries. Data is stored in tables, as records, and queries can be used to retrieve the records. Our first Base databaseĪ database can contain tables, queries, forms, reports and code. If you are on Windows (like I am right now while composing this article - XP is what we need to use at work) you can download the latest version from the project website. If it’s not, then look in your software package management program you should be able to install it from there. should come preinstalled on most “desktop” Linux distributions nowadays.
0 kommentar(er)
