Question: 1) To remove gridelines from your report, you will need to set the border style to transparent using the tab order database tools property sheet
1)
To remove gridelines from your report, you will need to set the border style to transparent using
the tab order
database tools
property sheet
2)
Which of the following is not a legitimate section for form objects?
form detail
group header
form header
3)
By default the field size for short and long text in the table object is
O 15
250
O 255
4)
A many-to-many relationship in a database defines that each record in Table A may have many linked records in Table B. however, each record in Table B may have only one corresponding record in Table A.
O True
O False
5)
In Datasheet view, the star symbol that appears in the record selector area always identifies the current record in the database
True
False
Q6)
A relational database is the collection of information that organizes data points with defined relationships for easy access:
True
O False
7)
What does Access call a form that doesn't have a connection to a data source?
navigation
O unbound
subform
8)
Forms, like reports, have an ARRANGE tab that you can use to modify the form's layout. However, the Align function is not available for forms
True
False
9)
In your database financial report, you want to highlight all values less than $250 in specific color for easy access. Which of the following function would you
apply?
Query function
Conditional formatting
Filter funtion
10)
If you need a calculation in an unbound control, you can create a custom
string
syntax
expression
11)
view is most useful when the changes you need to make are not complex
O Design
Layout
12)
The sum function could be used to calculate values in any of these views expect?
Design view
Layout view
Report view
13)
Your manager has asked you to create a link between service reps and their clients. You will first need to assign clients ID to service reps table and then create a relationship between the service reps and clients table
True
False
14)
The report design and report wizard serves the same purpose, however, the report wizard is more complicated.
True
O False
15)
For the ____ data type, Access automatically assigns either a sequential or random numbering field
O auto number
currency
O number
16)
To create a relationship between tables you need to use the
Design
Create
Database tools
17)
The Input Mask wizard does NOT include the ability to do which of the following?
force all uppercase
O define placeholder
O store symbols with data
18)
The contents of the ____ section appear once at the beginning of the report
O page setup
O foot header
O report header
19)
What is a text box that gets its value from an expression?
O combo box
bound control
calculated control
20)
In Layout view of the report, you can specify both grouping and sorting by using the Group & Sort button on the
Design
Layout
can you please help me verifying is answers are correct or not also explain
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help