module-2

It allows for efficient organization and retrieval of data using tables and relationships.

It is primarily used for graphical data representation.

It is only suitable for small datasets.

It eliminates the need for data security measures.

A collection of tables, each storing a different entity

A single table storing all information

A collection of unrelated data files

A set of spreadsheets with no defined relationships

Each row is distinct

The order of columns is important

Each entry in the table can have multiple values

All values in a column must match the column name

ClientID

ClientName

Street

Zip

ClientName, because it is unique for each client

Street, because it is always different

ClientID, because it uniquely identifies each row

Zip, because it is a number

All tables have their primary keys underlined, which signifies the unique identifier for each table.

Only the Employees and Clients tables have underlined keys, which signifies the most important columns.

No tables have underlined keys; it is just for formatting.

Only the Projects table has an underlined key, which signifies a foreign key.

It displays the results of the query.

It is used to specify which fields to include in the query results, sort order, criteria, and other instructions.

It lists all available tables in the database.

It shows the relationships between tables.

It creates a copy of the data

It modifies the original data

It does not create a copy of the data

It deletes the original data

Datasheet View and Design View

Form View and Report View

Table View and SQL View

PivotTable View and Layout View

=

>

<

>=

Field names must always be enclosed in square brackets, even if they do not contain spaces.

Field names with spaces require square brackets, but it is a good habit to use them for all field names.

You should never use square brackets in Access expressions.

Square brackets are only used for numeric fields.

Avg

Max

Min

Sum

Date criteria is surrounded by # symbols.

Text criteria is surrounded by quotation marks.

You cannot add criteria to the query grid for grouping queries.

Access does not automatically add # symbols around date criteria.

Because it allows queries to automatically join related tables, saving time during query creation.

Because it ensures that each query can only use a single table at once.

Because it permanently locks the structure of the database, preventing further changes.

Because it automatically removes redundant data across all queries.

It permanently deletes all records that meet certain criteria.

It makes a specified change to all records that satisfy the query criteria.

It allows you to undo changes made during a batch update process.

It only retrieves data from multiple tables without making changes.

Only the first record in the table is deleted.

The query returns an error and does not run.

All records in the table are permanently deleted.

The database creates a backup before deleting records.

To permanently delete records that meet specific criteria.

To update multiple records at once in a batch process.

To create a new table as a copy of the data selected by the query.

To automatically back up the entire database.

Describe the relational database model

Explain Query-By-Example (QBE)

Create a new programming language

Apply relational algebra