Access Tables

What is each row in an Access table called?

• Record

• Field

• Cell

• Column

What unique identifier does each record have in a table?

• Email Address

• Name

• ID Number

• Phone Number

What is each column in an Access table referred to as?

• Field

• Data Point

• Cell

• Record

How can you save an edited record in a table?

• By printing the table

• By closing the database

• By emailing the database administrator

• By clicking Save on the Home tab

What happens when you click out of a cell after editing?

• The change is discarded

• The cell is highlighted

• The change is automatically saved

• A new record is created

How can you move between records when editing more than one?

• By dragging and dropping

• By using the arrow keys or the Record Navigation bar

• By using the tab key

• By using the scroll wheel

What should you generally avoid doing to records and why?

• Creating, because it uses up space

• Deleting, because it can negatively impact the database

• Saving, because it finalizes the data

• Editing, because it changes the data

What is the purpose of the Find and Replace option?

• To make a lot of changes at once

• To create new records

• To save changes automatically

• To locate and delete records

Why is it generally not recommended to use 'Replace All'?

• Because it creates duplicate records

• Because it deletes all records

• Because it logs you out of the database

• Because it can replace unwanted items

What is the best practice when practicing editing tables?

• To create new records to practice with

• To use the 'Replace All' function

• To delete records after editing

• To edit existing records