WorksheetsDatabase MMD access
Total questions: 96
Worksheet time: 1hrs 4mins
In a database table, rows are called __________
Fields
Records
Primary Keys
Foreign Keys
Forms, queries, and reports are created based on the data in the _________
Forms
Tables
Reports
Spreadsheets
All data for a particular entry, such as a client in your client card file
report
form
field
record
Each item of information within a record.
form
field
record
report
View that shows the “background” or working of a table
design view
datasheet view
form view
layout view
View that is similar to a spreadsheet, place to enter data
form
datasheet
design
detail
What is a suitable data type for usage?
Text
Number
Currency
Yes/No
Which data type would be most suitable for the 'Age' field?
Currency
Date & Time
Number
Memo
Data organized and formatted for printing.
form
table
report
query
What is a filter?
It removes certain items.
It protects goldfish from yucky things.
It is a piece of alien hardware.
A unique type of microwave.
The command for "not equal to" is...
<>
<=
>=
><
A relational database contains ..
(choose the most accurate answer)
multiple related tables
more than one table
one very large table
Relational databases are more efficient than flat file databases because .. (check all that apply)
less data is required to be stored inside the database
they are faster in retrieving data
there is more than one table
we can use both Excel and Access to create them
We can enter data in an Access database, either directly in the table or using a ...
form
table
query
report
We can retrieve data from a database to be printed using a ..
form
table
query
report
In a database table, rows are called ..
records
sets
items
objects
The table in this picture, is shown in
design view
datasheet view
access view
The table in this picture, is shown in
design view
datasheet view
access view
When creating a database in Access, the format with the extension ...
DOTX
ACCDB
SQLX
DBACC
It is one of the properties of the data types, short text and long text, which allows setting the length of the field and comes by default with a space of ...
50 characters
255 characters
155 characters
10 characters
In the following figure, identify what type of relationship it is:
Many to many
One to one
one to many
None of the above
Type of relationship that is the most common in a database, a table or a record found in it, it can be linked to many other records in another table or tables.
One to many
One to one
Many to many
None of the above
It is a relationship that occurs when many records in a table are linked to several records in another or other tables.
One to one
One to many
Many to many
None of the above
These are some of the activities that we can perform in a table in the datasheet view
Search - Sort - Filter
Sort - Filter - Format
Search - Clear - Filter
Add - Clear - Format
What types of ordering can we do to the records within the datasheet view?
Ascending and Selection
Ascending and Descending
Selection and Advanced
Descending and Advanced
What are the options for filtering within tables in MS-Access?
Selection, Text Filter, Form and Advanced
Selection, Filter, Report and Advanced
Selection, Filter, Form and Advanced
Selection, Report, Form and Advanced
What objects can we import into MS-Access?
Tables, fields, records, and forms
Tables, queries, reports, and forms
Fields, queries, texts and forms
Parameters, Queries, Reports, and Records
Steps to import a text file into MS-Access are:
External - Link - From File - Text File - Import Wizard
External Data - Import and Link - From File - Text File - Import Wizard
External Data - Import and Export - From File - Text File - Export Wizard
External Data - Import - From File - HTML File - Import Wizard
It is that table that is in a different database but acts as if it were in our database.
Related table
Indexed table
Linked table
File table
We can lose communication with the linked table when changing the location of the database to which we are referring.
True
False
It is the sending of the information from our database to another database or to a file of another type.
Import
Link
Export
None of the above
It is a database object that allows you to retrieve data from a table, modify it and even store the result in another table.
Entity
Reports
Forms
Queries
Types of queries with which we can extract and display data when certain criteria are met.
Action
Selection
Upgrade
Elimination
What are the two ways Access provides for me to design a query?
Query Layout and Datasheet View
Query wizard and query design
Datasheet Design and Query Wizard
Data Design and Design Wizard
In the following image, how this window is called in which we can design the queries.
Grid grid
Query design
Datasheet Grid
None of the above
Inside the grid, it is used to specify a search, it is a condition that the records that will appear in the result must meet.
Criteria
Order
Show
Field
Element that works similar to a table field, but the value it stores is entered by the user when the query is run.
Criteria
Parameters
Totaled
Search
When creating a query with parameters, when placing the name of the parameter it is important to place it in:
Parenthesis
Quotation marks
Brackets
Apostrophes
It is an expression that Access compares with query field values to determine whether to include the record that contains each value.
Parameter
Criterion
Indexed
Search
Types of operators that can be used within criteria queries.
Arithmetic operators
Comparison operators
Logical operators
None of the above
Types of queries that we can perform through mathematical functions.
Totaled
Parameters
Criteria
Search
In the image, we can see the different types of forms that Access has in the navigation option. Which of the following options is in the navigation panel?
Data sheet
Justified
In columns
Horizontal tabs
It is one of the elements that are part of the form in MS-Access in Design View.
Report detail
Form footer
Page Header
Module body
Object that serves to represent the data of a table or query generally to be printed.
Picture
Forms
Reports
None of the above
What is the validation rule for a presence check?
Between 1 and 4
Is Not Null
Like *?*@?*.??*"
LL00LL
What is the validation rule to check that no number below 2 and no numbers above 5 can be entered into a field?
Is Not Null
Like "?*@?*.??*"
Betwee 1 AND 6
Between 2 AND 5
What validation rule could be used to check an email address has at least 1 character, but more are possible followed by an @ sign, then at least another character, but more are possible followed by a full stop and finally that at least 2 more characters must be entered, but more are possble?
Like "?@?.?"
Like ?*@?*.??*
Like "?*@?*.??*"
Like "???????"
What is a value lookup?
Finding a value by searching a databse
Creating a field with multiple vlaues to choose from
Creating a link to a primary key
Checking if an entered value is in another table
How would you set a value lookup on a field?
Input multipe values in a cell
Input multiple values in a form
Use the lookup wizard to set the values
Use the lookup wizard to set the table lookup values
What is a primary key?
A field that links to another table
A filed that has values from multiple tables
A field that holds unique values
A filed that has repeating values
What is a foreign key?
A filed that holds unique values in the host table
A field that is used to link to unique values in another table
A way to unlock data about other countires
A physical key to open a door or cabinet
On what fields are database relationships created, primary or foreign keys?
Foreign keys
Primary keys
Normalisation is:
Removing all necessary data from a database
Organising a database to remove repeated entries and increase the accuracy of the data
Putting fields from different tables into one big database
Which of the following statements fully describes data in 2NF:
When any repeating fields have been removed and the table is given a primary key
When all repeating entries of data are removed and the fields in each table are directly related to the primary key and no fields are present that are not related to each other
When all the fields in each table are directly related to the primary key
An advantage of normalisation is:
The storage space needed for a normalised database is likely to be smaller
The process of normalising a database is very easy and doesn’t require any skill
It is possible to see previous details that have been changed, such as a customer’s address, as we can look back at an older entry
A disadvantage of normalisation is:
The data loses its integrity as some of it is removed in the normalisation process
The process of searching the database may be slower due to a higher demand on the central processing unit (CPU)
Removing redundant data means that links cannot be created between tables
What is an atomic field?
A field that contains multiple items of data
A field that is repeated
A field that contains only one item of data
What is a foreign key?
A unique identifier in a database
A primary key of one table that appears in another table
A field that should not be in a table and needs removing
A relation is in 1NF if it doesn't contain any ____________?
Determinants
Repeating groups
Null values in primary key fields
Functional dependencies
A table is in 2NF if the table is in 1NF and what other condition is met?
There are no functional dependencies.
There are no null values in primary key fields.
There are no repeating groups.
There are no attributes that are not functionally dependent on the relation's primary key.
When designing a database you should ____.
make sure entities are in normal form before table structures are created
create table structures then normalize the database
only normalize the database when performance problems occur
consider more important issues such as performance before normalizing
The normalization process involves assigning ____ to tables based on the concept of determination.
data
files
attributes
relations
A ____ key is an artificial PK introduced by the designer with the purpose of simplifying the assignment of primary keys to tables.
surrogate
composite
candidate
foreign
The ____ model views the data as part of a table or collection of tables in which all key values must be identified.
relational
object-oriented
conceptual
external
Tables in ____ will perform suitably in business transactional databases.
0NF
1NF
2NF
3NF
A 2NF table can exhibit ____ dependency.
partial
complete
transitive
indirect
The conflicts between design efficiency, information requirements, and processing speed are often resolved through ____.
conversion from 1NF to 2NF
conversion from 2NF to 3NF
compromises that may include denormalization
conversion from 3NF to 4NF
A table in ____ contains no transitive dependencies.
1NF
2NF
3NF
none of the above
A table where all attributes are dependent on the primary key and are independent of each other, and no row contains two or more multivalued facts about an entity, is said to be in ____.
1NF
2NF
3NF
4NF
Identification of the ____ will let you know where you are in the normalization process.
normal form
primary key
attributes
repeating groups
When is a table is said to be 3NF
Normalization improves performance by reducing redundancy.
If and only if it is in 2NF and every non key attribute is Non-transitively dependent on the primary key
It involves introduction of redundancy in data
None of the above
