Introduction to Access
Forms in Access
Queries
Easy Stuff
Extra Stuff
100
Is a database creation and management program.
Microsoft Access
100
Is are used for entering, modifying, and viewing records.
Forms
100
Is are a way of searching for and compiling data from one or more tables.
Queries
100
Offers you the ability to present your data in print.
Reports
100
Is You can edit multiple occurrences of the same word
Find and Replace
200
A Place where you enter data into
Cells
200
Is Just names and descriptions / no numbers.
Non-numerical data
200
Is sorts objects based on when they were created or last edited
Created Date or Modified Date
200
Is where you manage your files and the data about them — creating, saving, inspecting for hidden metadata or personal information, and setting options.
Backstage View
200
Is Where you type the word you want to find
Find What
300
Is where you will find custom commands to perform common tasks in Access quicker.
Quick Access Tool Bar
300
Is groups forms, queries, and reports with the tables they refer to.
Tables and Related Views
300
Is when you build a query in Access, to find exactly the data you want.
Defining Specific Search Condition
300
Is a way of organizing information by type.
Field
300
Is field type the word you would like to replace the original word.
Replace With
400
The Place where commands are organized.
Ribbon
400
Is groups objects by type. This is the default setting.
Object Type is groups objects by type. This is the default setting.
400
it's a unit of information
Record
400
Is rows and columns are referred to these.
Records and Fields
400
Is Identifies each record; for a record refers to every piece of information contained on that row.
ID Number
500
Is where all data are stored in here on Access.
Table
500
Is identifies each record; for a record refers to every piece of information contained on that row.
ID Number
500
Is a database that is able to understand how different sets of data relate to one another.
Relational Database
500
Is allows you to create a custom group for sorting objects. After applying the sort, simply drag the desired objects to the new group.
Custom
500
Is Sometimes when you enter information into a record, a window will pop up to tell you that the information you've entered is invalid.
Validation Rule