Database tables are quite similar in appearance to spreadsheets because in both the applications, data is stored in rows and columns. As a result of this, it is usually very easy to import spreadsheets into database tables. The basic difference between storing your data in spreadsheets and storing data in a database lies in how the particular data is organized. To gain the maximum flexibility out of any database, the data needs to be organized into tables so as to avoid repetitions. For instance, if you’re storing information about a specific number of students, each student’s name only needs to be entered once in a table that is set up only for the purpose of holding the students’ data. The data about subjects would be stored in its own table, and data about the students’ marks would be stored in another table. That is what normalization is known as.
A record refers to each row in a table. These are where the individual pieces of information are stored. Each of these records consists of one or more than one fields. Corresponding to the fields are the columns in the table. For instance, there might be a table named ‘Students’ where each record or row contains information about a different student, and each field or column contains a different type of information, such as the first name and the last name, address, and so forth. Whether it is text, number, date, time, or some other type, the fields must be designated as a certain data type.
Changing the font in an MS Access table
MS Access, the famous database management system requires certain software tools to organize data in a specific manner. The fonts in an MS Access table can be changed to any size, type, colour or style. There are certain steps that can be followed in this regard.
Instructions for changing the font for one table
Step 1: Access the MS Access application by clicking on ‘start’ and then going to ‘MS Office’. Then your table needs to be opened in Datasheet view.
Step 2: After that, the Format menu needs to be opened. Then choose Fonts. This would open a new window.
Step 3: You can then select the font face, colour, style or size that you desire from the window that appears.
Step 4: Once the fonts, styles etc are chosen, click on ‘Save’.
Instructions for changing the Default for all tables in the Database
Step 1: Go to the Tools menu. Click on Options from the drop down menu.
Step 2: Select the Datasheet tab. From there, you can make your font selections and other styles.
Step 3: Click on Ok once that is done.
It needs to be noted that changing the format of a particular datasheet overrides the format of the default datasheet that is defined in the Datasheet tab that can be accessed from ‘Options’ under the ‘Tools’ menu.