Mastering Microsoft Access

What are the key principles of database design?

• Normalization, data integrity, relationships, performance optimization.

• Data redundancy

• Static data storage

• Single-user access

How do you create a primary key in a table?

• Add a primary key column after table creation.

• Use the UNIQUE constraint in the table definition.

• Set the primary key in the database settings.

• Use the PRIMARY KEY constraint in the table definition.

What is the purpose of establishing relationships between tables?

• To reduce storage space

• To simplify data entry

• To organize data, ensure integrity, and enable complex queries.

• To eliminate redundancy

Explain the difference between INNER JOIN and LEFT JOIN in SQL.

• LEFT JOIN only returns rows from the right table with no NULLs.

• INNER JOIN returns all rows from both tables regardless of matches.

• INNER JOIN returns matched rows only; LEFT JOIN returns all rows from the left table with matched rows from the right table, filling with NULLs where there is no match.

• INNER JOIN includes all rows from the left table and fills unmatched with zeros.

What is normalization and why is it important in database design?

• Normalization complicates data management.

• Normalization is only necessary for large databases.

• Normalization is important in database design because it minimizes data redundancy, enhances data integrity, and simplifies data management.

• Normalization increases data redundancy.

How can you create a form in Microsoft Access?

• Use the 'Home' tab to create a new form.

• Open the database and go to 'File' then 'New'.

• Open the database, go to 'Create' tab, select 'Form Design' or 'Form Wizard'.

• Select 'Report Design' from the 'Create' tab.

What are the steps to generate a report in Access?

• Open Access, go to 'Home' tab, click 'Create Report' directly

• Open Access, select 'Data' tab, and click 'Generate Report'

• Open Access, go to 'Create' tab, use 'Report Wizard' or 'Blank Report', select data source, choose fields, layout, and save.

• Open Excel, go to 'File' tab, select 'New' and choose 'Report'

What is a foreign key and how is it used?

• A foreign key is a type of primary key.

• A foreign key is used to delete records from a table.

• A foreign key is a unique identifier for a single table.

• A foreign key is a field that links two tables by referencing the primary key of another table.

Describe a scenario where data validation is necessary.

• Data validation is unnecessary in a social media app.

• Data validation is necessary in a healthcare application to ensure accurate patient information.

• Data validation is irrelevant in a gaming application.

• Data validation is only needed for financial transactions.

What are the different data types available in Access?

• Boolean, Decimal, Text, File

• Integer, List, URL, Document

• String, Float, Image, Video

• Text, Memo, Number, Currency, Date/Time, Yes/No, OLE Object, Hyperlink, Attachment