MS Access Forms and Reports Flashcards
What’s the difference between unbound and bound controls in a report?
Bound controls are tied to an underlying source (such as a table/query).
Unbound controls have no data source and instead display graphical content like titles, labels, lines, & rectangles.
What mechanism is used to import data into an MS Access database?
XML (Extensible Markup Language)
What method is used to transfer data from one Access database to another?
Right-click an empty spot in Access, click ‘import from database’, and then pick the database object you would like to import the data from.
How do you enforce referential integrity in Access between tables?
You select “Cascade Update Related Fields” and “Cascade Delete Related Fields”.
This makes it so that if you, for example, change the primary key of an entity, Access will also change all references to the primary key to match the change you just made.
