Access Module 3 Flashcards

Flashcards for Access Module 3 vocabulary

Backstage View

It's like a secret room where you can do things like save, open, or print your files. It helps you take care of your work.

Keeping the database

Like cleaning up your toys, this means adding, changing, or taking away things in the computer so they are correct.

Change the database

This is like moving things around in your toy box. You can add new toys, change old ones, or get rid of toys you don't want anymore.

Split form

Imagine a paper that's split into two parts. The top part shows you one thing, and the bottom part shows you many things at once.

Searching

It's like looking for your favorite toy in your toy box. You look until you find the one you want.

Filter

This is like picking only your red toys to play with. You only see the things you want to see.

Common filters

These are like special tools that help you find things. They let you look for things that are the same or in a certain group.

Structure

Think of it like the bones of a body. It's how everything in the computer is set up and what it looks like.

Lookup field

It's like a list you can pick from. Instead of typing, you can choose what you want from the list.

Multivalued fields

These are like boxes that can hold more than one thing. You can put many things in the same box.

Calculated field

The computer does math for you with these. It uses numbers you already have to figure out a new number.

Computed field

Same as calculated field: The computer does math for you with these. It uses numbers you already have to figure out a new number.

Action query

This is like telling the computer to do something like add, take away, or change things in a list.

Update query

It's like fixing a mistake. This tells the computer to change something to make it right.

Delete query

This is like throwing away a toy you don't want. It tells the computer to get rid of things you don't need.

Append query

It's like adding more toys to your toy box. This tells the computer to put things onto a list.

Make-table query

This is like making a new toy box for your toys. The computer makes a new list for you.

Validation rules

These are like rules you have to follow. They help make sure you put the right things in the right places.

Validation text

This is like a message that tells you if you made a mistake. It helps you fix your mistake.

Required field

This is like a question you have to answer.