Lesson 10: Microsoft Access

It is the heart of any database. This is where the data resides.

• worksheet

• table

• spreadsheet

• chair

A table is similar to an Excel file with rows and columns which referred to as ________ and ________ in Access.

• data and information

• sort and filter

• right and wrong

• records and fields

"LastName" and "FirstName" are examples of ________________.

• Table Names

• Field Names

• Records

• Query

A field name can be __ characters long

• 20

• 108

• 64

• 12

To enter, modify and view records easily, use _________.

• Forms

• Table

• Prints

• Fields

You can use combinations of letters, numbers, and special characters in giving names to field EXCEPT the following: Choose three (3) answers.

• space ( )

• accent graves ( ' )

• period ( . )

• underscore (_)

• bracket ([ ])

FACT OR BLUFF: QUERY is a way of searching for and compiling data from one or more tables.

• Yeah! It's a FACT! 🤩

• Nuh uh, it's a BLUFF! 😏

FACT OR BLUFF: REPORTS will allow you to present your data in print.

• Yeah! Fact na Fact! 😎

• NO! Bluff na Bluff! 😭