Microsoft Access Database Basics
18 Questions
2 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is used to enter, edit, and delete records in a table in Microsoft Access?

  • Macros
  • Datasheet View (correct)
  • Reports
  • Design View

Which tool in Microsoft Access allows you to automate repetitive tasks and operations?

  • Forms
  • Macros (correct)
  • Tables
  • Queries

What is the purpose of Forms in Microsoft Access?

  • Formatting and presenting data professionally
  • Creating and modifying table structures
  • Automating repetitive tasks
  • Entering data and displaying data (correct)

Which view in Microsoft Access is used to create and modify the structure of a table?

<p>Design View (B)</p> Signup and view all the answers

In Microsoft Access, what is the hierarchy from smallest to largest?

<p>Field, Records, Table, Database (A)</p> Signup and view all the answers

Which tool in Microsoft Access is used for building reports and forms?

<p>Report Wizards (B)</p> Signup and view all the answers

What type of data is stored by the Hyperlink field?

<p>Website addresses, email addresses, and hyperlink data (D)</p> Signup and view all the answers

Which field type allows users to create a drop-down list of values for data entry?

<p>Lookup Wizard (C)</p> Signup and view all the answers

What does the Field Size property define?

<p>Maximum number of characters in a text field (A)</p> Signup and view all the answers

Which property sets how data is displayed in a table field?

<p>Format (C)</p> Signup and view all the answers

What does the Required property in Field Properties determine?

<p>Whether a value is required to be entered into a table field (D)</p> Signup and view all the answers

Which field type is used to display calculated results based on other fields in the table?

<p>Calculated (A)</p> Signup and view all the answers

What does GIGO stand for in the context of database management?

<p>Garbage In, Garbage Out (A)</p> Signup and view all the answers

Why should calculated data be avoided when designing database tables?

<p>Due to continuous updating (B)</p> Signup and view all the answers

Which field type stores dates and times in a database?

<p>Data/Time (D)</p> Signup and view all the answers

What is the purpose of a Primary Key in a database table?

<p>Ensure field uniqueness in records (A)</p> Signup and view all the answers

Which field type is suitable for storing up to 255 characters of text, numbers, and symbols?

<p>Short Text (A)</p> Signup and view all the answers

What does the Yes/No field type store in a database?

<p>Binary representation like Yes or No (B)</p> Signup and view all the answers

More Like This

Use Quizgecko on...
Browser
Browser