ISTM 210 EXAM 3 ACCESS| WITH WELL-
STRUCTURED QUESTIONS AND
ANSWERS| FREQUENTLY TESTED|
RATED 100%| GUARANTEED PASS!!!
Access Menu Ribbon - ANSWER ✔✔ At the top of the window
Provides access to all of the features
Access Object Navigation Pane - ANSWER ✔✔ At the side of the window
Provided to help users interact with the various objects in database files
Compact and Repair tool - ANSWER ✔✔ In the Database Tools Menu Tab
Analyzes the database and reduces the size of the database file
(Compact on Close)
Four types of objects in Access - ANSWER ✔✔ 1. Tables
2. Queries
3. Forms
4. Reports
Tables - ANSWER ✔✔ Used to store the data in Access
Consists of columns, which store data fields, and rows, which store database records
Queries - ANSWER ✔✔ Used to find the specific data you need from the database
Can be constructed to locate related data across more than one table
Can be used to perform some basic calculations on numeric data
Forms - ANSWER ✔✔ Used to present the data in a table in a separate window one record at a
time
Used to help with entering new data into a table and to navigate through the records of a table in
user-friendly way
Reports - ANSWER ✔✔ Used to organize and present the data in your database
Used to present the data in a meaningful way to aid in managerial decision making
Can be generated from tables or queries
Different Views - ANSWER ✔✔ 1. Object view
2. Design View
3. Layout View
Object View - ANSWER ✔✔ Displays the finished object
(Maybe a finished table)
, Design View - ANSWER ✔✔ Used to edit the object
Allows you to add and configure the field in a table
Allows you to add elements to the form or report and change the appearance of those elements
Layout View - ANSWER ✔✔ Like the design view, but provides fewer options for manipulating
the object
Often easier to use than the design view
Not always an option to use
Relation - ANSWER ✔✔ Technical term for a table
Is the basis of the term "Relational Database"
Relationship - ANSWER ✔✔ When a table contains data associated with data from another table
within the database
Entity - ANSWER ✔✔ Something you are collecting data on
Attribute - ANSWER ✔✔ Data stored for each database record
Record - ANSWER ✔✔ Row in the table
All the information you have about specific instances of an entity
Field - ANSWER ✔✔ Column in the table
All information you have of an attribute
Prometheus approach to creating tables - ANSWER ✔✔ Table Design
Naming fields - ANSWER ✔✔ 1. Should be meaningful and descriptive
2. Allows you to use spaces, but not recommended
3. Use only letters and numbers, no symbols or special letters
Data types for fields - ANSWER ✔✔ 1. Short Text (up to 255 characters)
2. Long Text (up to 65,536 characters)
3. Number (positive or negative)
4. Date/Time
5. Currency (number data type starting with $)
6. AutoNumber (Access automatically generates a number when a new record is added to the
table)
7. Yes/No
8. OLE Object (stores files, recommended to use attachment instead)
9. Hyperlink (links to websites or folders/files on computer)
10. Attachment (stores files for a database record, could be virtually any format)
11. Calculated (creates a field generated by a formula, often refers to values in other fields)
STRUCTURED QUESTIONS AND
ANSWERS| FREQUENTLY TESTED|
RATED 100%| GUARANTEED PASS!!!
Access Menu Ribbon - ANSWER ✔✔ At the top of the window
Provides access to all of the features
Access Object Navigation Pane - ANSWER ✔✔ At the side of the window
Provided to help users interact with the various objects in database files
Compact and Repair tool - ANSWER ✔✔ In the Database Tools Menu Tab
Analyzes the database and reduces the size of the database file
(Compact on Close)
Four types of objects in Access - ANSWER ✔✔ 1. Tables
2. Queries
3. Forms
4. Reports
Tables - ANSWER ✔✔ Used to store the data in Access
Consists of columns, which store data fields, and rows, which store database records
Queries - ANSWER ✔✔ Used to find the specific data you need from the database
Can be constructed to locate related data across more than one table
Can be used to perform some basic calculations on numeric data
Forms - ANSWER ✔✔ Used to present the data in a table in a separate window one record at a
time
Used to help with entering new data into a table and to navigate through the records of a table in
user-friendly way
Reports - ANSWER ✔✔ Used to organize and present the data in your database
Used to present the data in a meaningful way to aid in managerial decision making
Can be generated from tables or queries
Different Views - ANSWER ✔✔ 1. Object view
2. Design View
3. Layout View
Object View - ANSWER ✔✔ Displays the finished object
(Maybe a finished table)
, Design View - ANSWER ✔✔ Used to edit the object
Allows you to add and configure the field in a table
Allows you to add elements to the form or report and change the appearance of those elements
Layout View - ANSWER ✔✔ Like the design view, but provides fewer options for manipulating
the object
Often easier to use than the design view
Not always an option to use
Relation - ANSWER ✔✔ Technical term for a table
Is the basis of the term "Relational Database"
Relationship - ANSWER ✔✔ When a table contains data associated with data from another table
within the database
Entity - ANSWER ✔✔ Something you are collecting data on
Attribute - ANSWER ✔✔ Data stored for each database record
Record - ANSWER ✔✔ Row in the table
All the information you have about specific instances of an entity
Field - ANSWER ✔✔ Column in the table
All information you have of an attribute
Prometheus approach to creating tables - ANSWER ✔✔ Table Design
Naming fields - ANSWER ✔✔ 1. Should be meaningful and descriptive
2. Allows you to use spaces, but not recommended
3. Use only letters and numbers, no symbols or special letters
Data types for fields - ANSWER ✔✔ 1. Short Text (up to 255 characters)
2. Long Text (up to 65,536 characters)
3. Number (positive or negative)
4. Date/Time
5. Currency (number data type starting with $)
6. AutoNumber (Access automatically generates a number when a new record is added to the
table)
7. Yes/No
8. OLE Object (stores files, recommended to use attachment instead)
9. Hyperlink (links to websites or folders/files on computer)
10. Attachment (stores files for a database record, could be virtually any format)
11. Calculated (creates a field generated by a formula, often refers to values in other fields)
