ECDL Module 5 Tables Quiz

A chart is not part of a database because a chart is a visual representation of data, typically used for analysis or presentation purposes. In a database, data is organized and stored in tables, which consist of records (rows) and fields (columns). A chart is a separate entity that can be created using the data from a database, but it is not an inherent component of the database structure itself.

Tables have two views: Datasheet view and Design view. In Datasheet view, the table is displayed as a grid with rows and columns, allowing users to enter and view data. Design view, on the other hand, provides a more detailed and structured view of the table's design. It allows users to define the table's structure, set field properties, and specify relationships with other tables. In Design view, users can add, modify, or delete fields, set primary keys, and define data types and validation rules.

Each item within a record is called a field.

Fields are the individual items that make up a record within your database. In the example of a student table, a field would be first name or surname or student number.

ppt(X) is Powerpoint
doc(x) is Word
accdb is Access database 2007
xls(x) is Excel spreadsheet

Within each table there are records. A record is a collection of information that stores all of the data about one person or one thing. For instance a record in student table would contain all of the data about one student i.e. their name, address, home phone number, d.o.b. medical history. Each student would have a record.

A primary key is a reference that uniquely identifies each record such as a membership number or a student number.

Drawing on your own experience and knowledge can you identify any instances where databases are used?

For example in a title field you could limit the entry to be Mr,Mrs,Miss,Ms or Dr

Be aware that if you do not set the field length to an appropriate size when you set the table up and then try to reduce the field length at a later date, you may lose some of the data you have entered. i.e. if you have entered an address that has 30 characters and then change the field size to 20, you would lose the last 10 characters in the address. It is better to get the text field sizes set up correctly right at the start.

Design view is for entering and formatting fields.
Datasheet view is for entering and editing records.

Every time you switch the table view if you have made any changes then you will be asked if you wish to save the table. If you have not made any changes then you will not be prompted to save the table.