A method of extracting specific data from a table.
What is A Query?
100
File,new,blank database, then create
how do you create a table?
100
By Freezing it
how do you keep an area of a visible while you scroll to another area, ?
100
Smart Tags can also be used to schedule meetings, add contacts to instant messaging, and enable a slew of other conveniences all from within an Access database
What can Smart tags be used for ?
100
present data in an easy-to-read, professional looking format
What does Reports allow a user to do ?
200
A database is a tool used to organize, store, retrieve, and communicate groups of related information
What is a Database?
200
up to 64 Characters long
how long can the Guidelines for Field Names be ?
200
The default size of the cells, columns, and rows in a table can be modified.
What is the Default size
200
tables to share data
What does Creating a relationship between tables allow?
200
a page break in the report.
What does The dotted lines on the report indicate ?
300
-Start button/Programs
- Double click the Access icon on your desktop (if you have one)
How to start Access 2010?
300
A database template(s) allows the user to accomplish various tasks!
What does Database Templates allow you to do ?
300
to enhance the appearance of the table
Why Would You Add cell special effects ?
300
it will Prevent inaccurate values from being entered into a table
What does Referential integrity prevent ?
300
in Print Preview.
where would The finished report be displayed ?
400
-phone book
-online library card catalog
-payroll data including employee names, social security numbers, pay rates, exemptions, etc
What is Examples of databases
400
Individual tables can be printed without printing the entire database
What is printing tables?
400
Click the “launcher” under the Text Formatting group
how do you Change the table background & gridline colors?
400
A form is a database object that you can use to create a user interface that allows users to enter and edit your data.
What is Forms?
400
at the top of the first page of the report
Where does the report header print?
500
Databases are more powerful allowing for information to be retrieved based upon criteria, calculations, etc.
why is A Database better than a Spreadsheet ?
500
Deleting a row will permanently remove an entire record of data from the table
What does Deleting a row in Datasheet View do?
500
it will allow for the table data to be viewed without being altered
What does Exporting a table as a Web page (HTML) or Adobe Acrobat (PDF) allow you to do?
500
Direct input of data in the appropriate date fields of a database, through the use of a human data-input devices such as keyboard, mouse, stylus, or touch screen, or through speech recognition software
What is Data Entry?
500
A theme may be applied to a report using the Themes command on the Report Layout Tools Design Ribbon