Chapter 1: Creating Your First Database

Question 1

What are the six different types of database objects?

Answer 1

Tables
Queries
Forms
Reports
Macros
Modules

Question 2

How do you change the default database save location?

Answer 2

Go to File -> Options; then General -> Default database folder

Question 3

What is a table?

Answer 3

A table is a group of records

Question 4

What is a record?

Answer 4

A record is a collection of information about a single thing

Question 5

What are fields?

Answer 5

Fields are subdivisions of records and each field stores a distinct piece of information.

Question 6

What are the two ways to customize a table in Access called?

Answer 6

The two ways to customize a table are Design view and Datasheet view

Question 7

What is the easiest way to delete a record?

Answer 7

To remove a record, right-click the margin immediately to the left of the record.

Question 8

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?

Answer 8

Press F2

The point of edit mode is to bring the cursor into the field entry, naturally the entire content is highlighted.

Question 9

What do Tab or Enter do in a table?

Answer 9

Moves the cursor one field to the right, or down once you reach the edge of a table. It also turns off edit mode.

Question 10

Move the cursor one field to the left (shortcut)

Answer 10

Shift + Tab

Question 11

Move the cursor to the first field in the current row (shortcut)

Answer 11

Home

Question 12

Move the cursor to the last field in the current row (shortcut)

Answer 12

End

Question 13

Move the cursor down one screenful (shortcut)

Answer 13

Page Down

Question 14

Move the cursor up one screenful (shortcut)

Answer 14

Page Up

Question 15

Move the cursor to the first field in the first row (shortcut)

Answer 15

Ctrl + Home

Question 16

Move the cursor to the last field in the last row (shortcut)

Answer 16

Ctrl + End

Question 17

Cancel any changes made in the current field, in Edit mode (shortcut)

Answer 17

Esc

Question 18

Copy the value from the field that’s immediately above the current field (shortcut)

Answer 18

Ctrl + “

Question 19

Insert today’s date into the current field (shortcut)

Answer 19

Ctrl + ;

Question 20

Replace whatever value you’ve entered with the field’s default value

Answer 20

Ctrl + Alt + Space

Question 21

What’s the best way to make a database backup on the fly?

Answer 21

File -> Save and Publish

Question 22

What’s with the .laccdb file?

Answer 22

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.

Question 23

How do you trim your database back to size? Where is this feature?

Answer 23

You can use a feature called compacting. Choose File-> Info, and click the big Compact & Repair Database button.

Question 24

How do you turn off automatic compacting on close?

Answer 24

File -> Options -> Current Database -> Application Options -> Compact on Close

Question 25

How many recent databases does Access ordinarily keep in the Recent list? How can that be changed?

Answer 25

17

File-> Options-> Client Settings-> Display -> Show this number of recent documents

Question 26

How do you change the number of “quick access” recent databases?

Answer 26

File-> Recent, and then go to the bottom of the screen

Question 27

How do you bring up more than one database at once?

Answer 27

Open more than one instance of Access. This is done automatically if you aren’t using File-> Open

Question 28

Collapse the ribbon (shortcut)

Answer 28

Ctrl + F1