Excel and Access 101
Excelling in Charts
Reporting the Data
Accessing the Tables
Miscellaneous
100
In the Design View of a Table, this function allows for a user to indicate what is used in relationship creating.
What is the Primary Key Tool?
100
These parts of a chart help to identify how much a bar on a bar graph indicates.
What are Data Labels?
100
This Button allows a user to choose which fields from a table is to be used in a given report.
What is the Report Wizard button?
100
This Data Type places a symbol indicating money before every number entry.
What is the Currency Data Type?
100
The Unheard of winner of the 1969 Pennant. The underdog of the century. The Miracle ____.
Who are the Mets?
200
In an Access query, this word is used to indicate there is more than one criterion
What is "And"?
200
This Chart helps to see the percentages that each part of the data makes up.
What is a Pie Chart?
200
In a Report, data can be ordered and arranged by doing this.
What is Sorting and Filtering?
200
Tables allow for an entry of this object that restrict data so that it only looks a certain way.
What is a Filter/Input Mask?
200
This Football team was a dominant powerhouse in the 1970s, winning both Super Bowl IX and X.
Who are the Pittsburgh Steelers?
300
Theft is bad, and theft of an Access Database is even worse. However, you can do this action, otherwise known as setting a password, to ensure data stays safe.
What is encrypting?
300
This convenient button allows for the addition of objects and areas of a chart, such as inserting X-Axis Labels and a legend. It is known by this name.
What is The Application Parts Button?
300
When creating a report, you can add in a small picture to the title bar, known as this.
What is a Logo?
300
--DAILY DOUBLE--
What is the Lookup Wizard?
300
Made popular down in Australia, this spread has gained a reputation for being one of the worst tasting "vegetables" there are.
What is Vegemite?
400
Open, Close, Save, all very useful commands located in the file tab. However, people don't attend to appreciate the File tab enough, as they fail to realize it is the only tab with a different what?
What is a different color?
400
This chart allows for a user to track changes of multiple sources of data over time
What is a Multiple Line Chart?
400
Need advanced options in your report? No worries, opening this sheet will give you all the options and settings for everything in your report, no questions asked.
What is the Property Sheet?
400
Tables allow you to count how many entries you have, even if you couldnt count that high in a year! This button, which looks like Sigma, allows you to do this.
What is the Totals button?
400
Colors on computers surely aren't attained by painting them on there. Luckily for everyone, these types of codes identify colors on a computer
What are Hex(Hexidecimal) codes?
500
The Number 101 could be classified as many data types, and could be added and subtracted in Access by using these types of fields.
What are Calculated Fields?
500
--DAILY DOUBLE--
What is a Radar Chart?
500
Reporting all this data is some tough work, but luckily there are 4 tabs that are gained when working on a report, which are names these names.
What are "Format" "Design" "Arrange" and "Page Setup"
500
In tables, you can select OLE Object as a data type, in which OLE stand for this.
What is Object Linking and Embedding
500
The record score for the Master's Golf Tournament is set by none other than Tiger Woods, who shot a 270, or this many under par in 1997.
What is 18 under par?
M
e
n
u