Access Practice Exam | 100% Correct
Answers | Verified | Latest 2024 Version
A ___ is an organized collection of data. - ✔✔Database
Database that are not related or linked to other data are called ___ databases. - ✔✔Flat
When designing a new database, the first question users should ask themselves is ___. - ✔✔What
questions should the database be able to answer?
When linking two tables in a relational database, a user will use a ___ to create the link. - ✔✔Common
field
Which of the following is NOT a way method to create a new database? - ✔✔Database wizard
When saving a new database in Acceds 2007-2016 databases, the file extension should be ___. -
✔✔.accdb
When creating a new table, Access creates the first field and names it ___ which Access assigns a unique
sequential number. - ✔✔ID
When considering to use the Currency data type, a user should understand that they can store data with
one to ___ decimal spaces. - ✔✔Four
There are two views for tables in Access: Datasheet view and ___ view. - ✔✔Design
To improve accuracy during user input, a designer can add context to the ___ from the properties screen
which will be displayed in the status bar to provide additional information to users who are entering
data. - ✔✔Description
Answers | Verified | Latest 2024 Version
A ___ is an organized collection of data. - ✔✔Database
Database that are not related or linked to other data are called ___ databases. - ✔✔Flat
When designing a new database, the first question users should ask themselves is ___. - ✔✔What
questions should the database be able to answer?
When linking two tables in a relational database, a user will use a ___ to create the link. - ✔✔Common
field
Which of the following is NOT a way method to create a new database? - ✔✔Database wizard
When saving a new database in Acceds 2007-2016 databases, the file extension should be ___. -
✔✔.accdb
When creating a new table, Access creates the first field and names it ___ which Access assigns a unique
sequential number. - ✔✔ID
When considering to use the Currency data type, a user should understand that they can store data with
one to ___ decimal spaces. - ✔✔Four
There are two views for tables in Access: Datasheet view and ___ view. - ✔✔Design
To improve accuracy during user input, a designer can add context to the ___ from the properties screen
which will be displayed in the status bar to provide additional information to users who are entering
data. - ✔✔Description
