Chapter 1: Creating Your First Database Flashcards
What are the six different types of database objects?
Tables Queries Forms Reports Macros Modules
How do you change the default database save location?
Go to File -> Options; then General -> Default database folder
What is a table?
A table is a group of records
What is a record?
A record is a collection of information about a single thing
What are fields?
Fields are subdivisions of records and each field stores a distinct piece of information.
What are the two ways to customize a table in Access called?
The two ways to customize a table are Design view and Datasheet view
What is the easiest way to delete a record?
To remove a record, right-click the margin immediately to the left of the record.
When using the arrow keys to move from field to field, what do you press to enter edit mode? What is the point of edit mode?
Press F2
The point of edit mode is to bring the cursor into the field entry, naturally the entire content is highlighted.
What do Tab or Enter do in a table?
Moves the cursor one field to the right, or down once you reach the edge of a table. It also turns off edit mode.
Move the cursor one field to the left (shortcut)
Shift + Tab
Move the cursor to the first field in the current row (shortcut)
Home
Move the cursor to the last field in the current row (shortcut)
End
Move the cursor down one screenful (shortcut)
Page Down
Move the cursor up one screenful (shortcut)
Page Up
Move the cursor to the first field in the first row (shortcut)
Ctrl + Home
Move the cursor to the last field in the last row (shortcut)
Ctrl + End
Cancel any changes made in the current field, in Edit mode (shortcut)
Esc
Copy the value from the field that’s immediately above the current field (shortcut)
Ctrl + “
Insert today’s date into the current field (shortcut)
Ctrl + ;
Replace whatever value you’ve entered with the field’s default value
Ctrl + Alt + Space
What’s the best way to make a database backup on the fly?
File -> Save and Publish
What’s with the .laccdb file?
Access creates a .laccdb file when you open a database file, and removes it when you close the database. So, you’ll see it only while you or someone else is browsing the database. The purpose for this is to make sure nobody else is changing the same record at the same time. The “l” stands for lock.
How do you trim your database back to size? Where is this feature?
You can use a feature called compacting. Choose File-> Info, and click the big Compact & Repair Database button.
How do you turn off automatic compacting on close?
File -> Options -> Current Database -> Application Options -> Compact on Close
How many recent databases does Access ordinarily keep in the Recent list? How can that be changed?
17
File-> Options-> Client Settings-> Display -> Show this number of recent documents
How do you change the number of “quick access” recent databases?
File-> Recent, and then go to the bottom of the screen
How do you bring up more than one database at once?
Open more than one instance of Access. This is done automatically if you aren’t using File-> Open
Collapse the ribbon (shortcut)
Ctrl + F1