in comparison with a flat file system, _____ in a database.

Step 4: To create your own table, Click on the View tab and click on the Design view option from the View drop-down menu. Step 3: Now, you can see that Microsoft access will automatically create a new table (Table1) at the left corner of the document.

Click on the Create button, as shown in the screenshot below.Browse the location where you want to save the database.Type database name in the File Name text box.Click on the Blank database option in the Available Templates section.Step 2: Microsoft Access Home page will appear on the screen, in which do the following.

There are the following steps to create a flat-file database.

It increased Redundancy and inconsistency.įor small businesses, a flat-file database is the best way to manage the data.

It is poor database in terms of complex queries.

Flat file database is harder to update.

It requires less hardware and software components.Ī list of disadvantages of a flat-file database is given below.

It is an excellent option for small databases.

Easy to understand and configure using various standard office applications.

Advantages of Flat file databaseĪ list of advantages of a Flat file database is given below. The advantage of a flat-file database is that it is easy to understand and helps us to sort the results easily. These records are separated using delimiters, such as tabs and commas. In the Flat file database, each line of the plain text file holds only one record. Flat file databases were developed by IBM in the early 1970s. It is the most important type of database used to store data in a plain text file (MS Excel). A Flat file database is also known as the text database.

In comparison with a flat file system, _____ in a database.