MISY 5325 CORRECT EXAM QUESTIONS AND
ANSWERS SET A+
.
✔✔True or False
As a Primary Key no more that two records can have the same data for that field -
✔✔False
no more than one record can have the same data for that field
✔✔**True or False
A table can have more than one Primary Key - ✔✔False
It can only have one Primary Key
✔✔**True or False
One Primary Key can consist of two or more attributes or fields - ✔✔True
✔✔True or False
In Access you can auto fit the column and row - ✔✔False
you can only auto fit the column
✔✔The Design View is used to - ✔✔create fields for the table
✔✔The Data Sheet View is used to - ✔✔add data into the table
✔✔True or False
All of the data in the Data Sheet View will need to be manually saved - ✔✔False
the data will automatically be saved, but there is not harm in manually saving
, ✔✔True or False
If the format is changed in the Data Sheet View it will not be automatically saved -
✔✔True
✔✔True or False
Before you can make any changes to the table ig. to rename, or delete the table, you
must close it first. - ✔✔True
✔✔Pathway to import from Excel - ✔✔External Data - New Data Source - From File -
Excel
✔✔True or False
Always Enable Contents - ✔✔True
✔✔True or False
A One-To-Many Relationship example is
A book rep can have more than one customer but a customer can only be assigned to
one book rep - ✔✔True
✔✔True or False
Any changes made in the Design View need to be saved - ✔✔True
✔✔To create a One-to-many relationship you have to add a primary key one table to
another table. This field is referred to as - ✔✔Foreign Key
✔✔If you want the text to be upper case where and what do you type - ✔✔in Format
type > (greater than)
✔✔True or False
Before creating a Relationship you must make sure all the tables are open - ✔✔False
All table must be closed or Access will not let you proceed
✔✔A query will display only the fields that have been dropped into the - ✔✔Design Grid
✔✔True or False
When entering words into the Criteria Field in the Design Grid, the words are case
sensitive, and have to be in quotations marks if the data type is text - ✔✔False
the words are not case sensitive but they do have to be in quotation marks
✔✔What is the show box used for? - ✔✔when you want to use specific criteria but you
do not want it to show on the query results
ANSWERS SET A+
.
✔✔True or False
As a Primary Key no more that two records can have the same data for that field -
✔✔False
no more than one record can have the same data for that field
✔✔**True or False
A table can have more than one Primary Key - ✔✔False
It can only have one Primary Key
✔✔**True or False
One Primary Key can consist of two or more attributes or fields - ✔✔True
✔✔True or False
In Access you can auto fit the column and row - ✔✔False
you can only auto fit the column
✔✔The Design View is used to - ✔✔create fields for the table
✔✔The Data Sheet View is used to - ✔✔add data into the table
✔✔True or False
All of the data in the Data Sheet View will need to be manually saved - ✔✔False
the data will automatically be saved, but there is not harm in manually saving
, ✔✔True or False
If the format is changed in the Data Sheet View it will not be automatically saved -
✔✔True
✔✔True or False
Before you can make any changes to the table ig. to rename, or delete the table, you
must close it first. - ✔✔True
✔✔Pathway to import from Excel - ✔✔External Data - New Data Source - From File -
Excel
✔✔True or False
Always Enable Contents - ✔✔True
✔✔True or False
A One-To-Many Relationship example is
A book rep can have more than one customer but a customer can only be assigned to
one book rep - ✔✔True
✔✔True or False
Any changes made in the Design View need to be saved - ✔✔True
✔✔To create a One-to-many relationship you have to add a primary key one table to
another table. This field is referred to as - ✔✔Foreign Key
✔✔If you want the text to be upper case where and what do you type - ✔✔in Format
type > (greater than)
✔✔True or False
Before creating a Relationship you must make sure all the tables are open - ✔✔False
All table must be closed or Access will not let you proceed
✔✔A query will display only the fields that have been dropped into the - ✔✔Design Grid
✔✔True or False
When entering words into the Criteria Field in the Design Grid, the words are case
sensitive, and have to be in quotations marks if the data type is text - ✔✔False
the words are not case sensitive but they do have to be in quotation marks
✔✔What is the show box used for? - ✔✔when you want to use specific criteria but you
do not want it to show on the query results
