NEW
Font size
WorksheetsDatabase Concepts and MS Access Operations
Total questions: 72
Worksheet time: 36mins
Through which command can the default size of the text field be set to 200 ?
Account
Options
The Delivery table must be in what type of relationship?
One-to-one
One-to-many
Many-to-many
No relationship
What must be true of the common field between two linked tables?
It must be of the same data type in both tables.
It must have different data types in each table.
It must be AutoNumber in both tables.
It must be numeric in one table and text in the other.
Exported data in text format can be opened in which application?
Word
Excel
PowerPoint
Access
Which tab allows you to create a new table?
Create
Home
External Data
Database Tools
Through which command can you get information about the database?
Account
Options
Information
Database Tools
Which query type is used to retrieve data directly as it is?
Selection query
Update query
Append query
Delete query
Which query type is used to retrieve data directly as it is?
Selection query
Crosstab query
Make-table query
Parameter query
Who is responsible for controlling all the permissions and uses of the database?
Database administrator
Application programmer
End user
Report designer
Whose responsibility is it to analyze the requirements of the entity that will use the system and then determine all the data?
Application programmer
Database administrator
End user
System operator
Who identifies user requirements and develops specifications to determine what is required from the databases?
System analyst
Database administrator
Network engineer
Report designer
From which place can the database be compressed and repaired?
File menu
Database Tools tab
External Data tab
Home tab
To compact and repair the database, which command is used?
Compact and Repair Database
Backup Database
Convert Database
Split Database
From which tab can the database be compressed and repaired?
DATABASE TOOLS
HOME
CREATE
EXTERNAL DATA
From which tab can the database be compressed and repaired according to the statement?
External Data
Home
Create
Database Tools
You can create a relationship between two tables from which area?
Database Tools tab (Relationships)
Home tab
Create tab (Forms)
External Data tab
Data processing produces other data by merging more than one field together into a new table. What does this describe?
Creating a new table by merging fields
Deleting records
Formatting reports
Changing data types
Database data can be exported to a text file from which tab?
External Data
Create
Home
Database Tools
Which view displays actual data?
Form View
Design View
Layout View
Report View
Which command is used to show information about the database such as the number of tables, queries, and forms it contains?
Information
Account
Options
Relationships
Through which command can we get information about the database from the number of tables, queries, and the cells it contains?
Information
Account
External Data
Create
Through which command can we get information about the database?
Information
Relationships
Options
Navigation Pane
How are tables linked to each other in a database according to the description?
Using a foreign field in one table and a corresponding field in another table that share the same value
Using identical table names
Using report templates
Using the navigation pane
To retrieve data as it is, which query type is used?
Selection query
Append query
Update query
Delete query
Which query is used to retrieve data from one or more tables?
Selection query
Make-table query
Append query
Delete query
Data can be added to be saved in the table through which query?
Append query
Update query
Delete query
Selection query
Which query calculates the sum or average of the collected data?
Totals query
Delete query
Append query
Update query
To delete one or more student records, which should be selected?
Delete query
Update query
Append query
Selection query
To remove records for graduating students from the students table, which action should be used?
Delete query
Update query
Append query
Make-table query
To calculate and reconstruct data for easier analysis, which query should be used?
Crosstab query
Append query
Delete query
Selection query
The student's relationship with academic subjects is a relationship of what type?
One-to-many
One-to-one
Many-to-many
No defined relationship
Can a form be created directly from a table without all of its fields appearing?
Yes
No
What should you use to create relationships between tables?
Relationships command
Report Wizard
Navigation Pane
Table Design
To create a ready-made database for a store, what should you choose?
Sample templates
Blank Database
Import External Data
Report Wizard
What is the default database provided by Access called?
Blank Database
Sample Database
Starter Database
Template Database
Can arithmetic or logical operations be performed on numerical values in data stored in databases?
Yes
No
After exporting reports in TXT format, can they be modified using a word processor program?
Yes
No
What is the requirement that data in the primary key field of the primary table must be present in the foreign key field of the secondary table called?
Referential integrity
Data redundancy
Normalization
Denormalization
What is the stated importance of the navigation pane?
Facilitating report printing and obtaining a copy of the database data
Creating relationships between tables
Designing queries
Editing table fields
When creating a relationship, what must match between the primary key field and the foreign field?
Data type and size
Field captions
Index names
Default values
What is the maximum required length for a field name according to the statement?
64 characters
67 characters
72 characters
255 characters
It is required that the length of the field name does not exceed …
32 characters
64 characters
128 characters
255 characters
Tables can be created by importing a table from another program, such as a word processor.
True
False
A command found in the File tab used to save the database with new name.
Save
Save As
Export
Compact & Repair
The report can be viewed after naming it.
True
False
The report can be viewed before naming it.
True
False
When the required property is set to YES, a value must be entered.
True
False
Normalization rules ensure the accuracy of repeated data.
True
False
Reports are created through the Design menu and then Create Report.
True
False
The layout of the report form can be specified detailed type.
True
False
It is possible to specify the report formatting layout as a detailed type.
True
False
Export steps cannot be saved.
True
False
The relationship of a student to academic results is a one-to-many relationship.
True
False
The main window of the database consists of … sections.
two
three
four
five
Form is a question about the data stored in a table.
True
False
The form is used to enter data and display all records at once.
True
False
The … tab contains an Analysis group.
Home
Create
Database Tools
External Data
Intermediate Table is used in … Relationship.
one-to-one
one-to-many
many-to-many
self-relationship
The result obtained from processing data …
data
information
field
record
A single table cannot exist without being connected to another table, otherwise we would not be able to describe this as a database.
True
False
The split form is used to create a form that includes data from several fields from several tables linked together in the same database.
True
False
The data in the table can be formatted using … tab
Home
Create
External Data
Database Tools
Reports are objects for displaying and printing data.
True
False
The data for the report is modified before it is printed if new data is added.
True
False
It is preferable that the key column fields be …
long text fields
AutoNumber
frequently edited values
duplicate-friendly values
To change the dimensions of the background so that it is suitable for the existing space, Click on the … Sheet, then from the Details list, choose Form.
Field List
Property Sheet
Navigation Pane
Report View
A primary key in a table (non-duplicate primary key) and it can be replaced with another alternative field.
True
False
Query is a question about the data stored in your tables or a request to perform an action on the data.
True
False
Use … as a databases program to store, update, and retrieve data.
Microsoft Word
Microsoft Access
Microsoft PowerPoint
Adobe Photoshop
To import data from another file, use …… tab.
Home
Create
External Data
Database Tools
TO add a background to the form, follow these Steps:
Open the form in Design View, open Property Sheet, set the Picture property
Install an add‑in from Office Store and apply a theme
Run Report Wizard and select a background style
Change the database theme only without editing the form
The field that distinguishes records from other records and consists of only one field.
Foreign key
Primary key
Composite key
Candidate key
