Dumb Access Test thing

What is the main reason for having a subform inside of a main form?

To show both tables in a one to many relationship i think?

Which export format exports the data in a tag-like structure, similar to that of a webpage?

XML

What will prevent a report from being able to have its width adjusted?

a control at the right edge of the report

A data source can be modified in which two ways?

adding existing fields changing the record source proerty

When concatenating fields, which symbol is used to perform the concatenation?

ampersand

which form creation option allows for forms to be created from templates, but does not include a record source

application parts

WHich two options for creating forms present a blank form window with no controls present?

blank form form design

Which type of field behaves as a table field after it has been added to a query

calculated

What can be added to a data firld to change its title without changing the actual field name?

caption

A user is prompted to save changes to a table upon closing the table. What specific changes need to be saved?

changes to the layout

Which is one way to delete rows in Access 2016?

click the design view button, select a row, and click delete rows

Which size mode on an image renders the image at its original size?

clip

What needs to be done with an open table before records can be appended to it?

close the table

When renaming a query field, which punctuation mark separates the query name from the actual field name?

colon

When setting a report to use multiple columns, what should also be set in order to ensure the columns fit within the prescribed page width?

column width column spacing

forms are mostly used for what purpose

data entry

Which ribbon tab is used to either create or modift table relationships?

database tools

On which ribbon tab is the option to apply a set of colors and fonts to a form?

design

On which ribbon tab will a user find the option to add page numbers to a report?

design

Which two views are available for viewing table information

design view datasheet view

Why is it a better option to add controls in design view than in layout view?

design view had indicators that show which section a sure is working in

Which methods can be used to add fields to a query? (bro idk i put every single answer and it's always wrong:()

double-click a field from table drag field from a table to the query design click the drop down arrow on an empty field and click a field

A suer wants to ensure a displayed field cannot have a value changed on a form. Which property should be changed on that field?

enabled

When adding a table to a field name in a formula, what symbol seperates the table from the field?

exclamation point

A user wants to restore two queries from a backup copy of a database. Whch ribbon tab should the user start with?

external data probably

Queries are not commonly used to build reports

false

Which filtering tool allows one to specify criteria across multiple fields?

filter by form

Which three items constitute an overall theme for a report?

fonts colors theme

A key field in a many table in a one-to-many relationship is a ______ key

foreign

On which ribbon tab will one find the option for specifying alternate row colors in a repoty?

format

On which ribbon tab will one find the option to delete a record?

home

on which ribbon tab would one find the option to turn on the total rows

home

How must a database be opened in order for it to be encrypted?

in exclusive mode????

When a data field is added to a form, what else is added?

label

Which control is best suited for adding static text to a report?

label

In which view does adjusting report column widths instantly show how data fits in a column?

layout

Which form view will allow the user to see changes to the look of the data as a control is being changed?

layout

A user has hidden objects, but now does not know how to unhide them. Where is the option for showing hidden options found?

no clue but im putting navigation options

Which keyword or key phrase represents the opposite of a criteria specification?

not

When sorting a field using the field heading, what needs to be selected first?

nothing

When dragging available fields into the report design view, space for a label should be left where on the report?

on the left side of the field

Which form property controls the order in which records sort when a form opens?

order by

Which type of join will show all records from one table in a query, even if those records have no matching records in the joined table?

outer

Which icon appears to the left of a record while a record is being added?

pencil

Which option, when enabled, ensures that renaming a table will also change references to that table from other Access objects?

perform name AutoCorrect

When one wants to use a user-defined template to build a database, where should one click on the New Database screen in order to find the user-defined templates?

personal

Which symbol is used for a wildcard in query criteria?

pound symbol

In a criteria statement, which symbols surround dates?

pound symbols

In which report view will a suer find ribbon options to control the margins, orientaion, and oerall page setip on the report?

print view

Which two methods are available for building a query?

query design query wizard

When setting a field to an AutoNumber format, which values are available for determining how fields auto-increment?

random increment

A form designer wants to change the field list to include only specific fields from a table. What should be changed on the form to enable this?

record source

A form designer wants to resize an individual control on a form. The control is currently part of a stack. What should the designer do first?

remove the control from the stacked layout

When the title button is used to add a title to a report, in which section does the title appear?

report header

Which report building tool offers an opportunity to define the report source, fields, and grouping, all while creating the report?

report wizard

A user wants to save the tables, queries, forms, and reports from a datbase to be able to reuse them, but not the data from those objects. What should the user do?

save the database as a template

Which is a proper method of deleting a column from a query

select the column and press the delete key

which propert allows for controlling how an image fits into a box on a form?

size mode

When building a calculated field in a query, what needs to be around field names when entered into a formula?

square brackets

Which size mode property forces an entire image to fit into a box on a form, regardless of dimensions?

stretch

Which table creation option allows one to specify fields, data types, and properties for a table?

table design

What should be selected on a form before a background is applied that will show behind from fields?

the correct form section

When backing up a database, what is added to the file name?

the current date

The expression builder does not display every field from a query. What is the main cause of this problem?

the query was not saved

When building a report from the report design feature, what needs to be defined in order to display fields in a field list?

the record source property(unsure)

A blue arrow is next to a table in the navigation pane. What does the blue arrow represent?

the table is linked

One drawback of using the split form is that when editing one field, the user risks editing the wrong record

true

A user wants to make sure a date field does not have a date in the future entered. What should be added to that field?

validation rule

What should be set on a field to explain a rule which controls the data that can be entered into a field?

validation text