Populating a Table
What view in Microsoft Access allows you to enter data directly into a table, similar to an Excel spreadsheet?
Datasheet View
What is the keyboard shortcut to add a new record in Datasheet View?
Ctrl + Plus (+)
What view is used to define table structure, including field names and data types?
Design View
What is a Primary Key in a Microsoft Access table?
A field that uniquely identifies each record in the table.
What tab in the Ribbon contains commands for sorting and filtering data in a table?
The Home tab
What is the term for each row of data entered into an Access table?
A record
How do you delete a record from a table in Datasheet View?
Select the row and press Delete, or right-click and choose Delete Record.
What field property allows you to specify a default value that appears automatically when adding new records?
Default Value
How do you set a Primary Key in Design View?
Select the field and click the Primary Key button in the toolbar.
What is the purpose of Forms in Microsoft Access?
To create a user-friendly way to enter and view records.
When entering data into a field that has a Lookup Wizard, what happens?
A drop-down list appears, allowing you to select a predefined value.
What happens when you delete a record in a table that has referential integrity enforced with another table?
Access prevents deletion unless Cascade Delete is enabled.
How do you rename a field in an existing table without losing data?
Open Design View, change the field name, and save the table.
Can a table have more than one Primary Key? If so, how?
Yes, by creating a Composite Primary Key using two or more fields.
How can you quickly find a specific record in a large table?
Use the Find and Replace feature or Filter by Selection.
If a field is set as Required in Table Design View, what happens if you leave it blank when entering a record?
Access displays an error and does not allow the record to be saved.
What query type in Access allows you to delete multiple records at once based on a condition?
Delete Query
What does the AutoNumber data type do in a table?
It automatically generates a unique number for each new record.
What property should be used to prevent duplicate values in a field?
Indexed (No Duplicates)
What is the function of the Relationships window in Access?
It allows you to define connections between tables using Primary and Foreign Keys.
What data type should be used for a field storing phone numbers, and why?
Short Text, because phone numbers are not used for calculations.
What happens if you accidentally delete a record from a table?
The deletion cannot be undone unless a backup exists.
What is the difference between Short Text and Long Text data types?
Short Text allows up to 255 characters, while Long Text can store larger amounts of text (up to 64,000 characters).
What is the difference between Required and Validation Rule properties?
Required ensures a field is not left blank, while Validation Rule specifies conditions for valid data entry.
How do you create a drop-down list for a field in an Access table?
Use the Lookup Wizard in Design View.