Database
Access is....
What is a database management system?
a database object which allows you to ask the database about the information it contains.
What is a query?
to back up a database is found where on the ribbon.
What is the file tab?
query type that can be used to remove entire records from a table.
What is a delete query?
a report within a report
What is a subreport?
A collection of information associated with a specific subject.
What is a database?
a database object you can use to enter, edit or display data from a table or query
What is a form?
the Query Wizard can be found on the ribbon.
What is the create tab?
placed around dates when using comparison operators
What are pound # signs?
Columns of the table are called
What are fields?
complete sets of data that are the rows of the table.
What is a record?
a collection of fields which store data
What is a table?
holds the commands for changing the font of the text in a table on this group on the home tab.
What is text formatting?
placed in the Criteria row of the design grid in a query, would return results of less than or equal to $100
What is >=100?
premade way to create a query
What is query wizard?
a single piece of information in a table
What is a field?
a formatted printout or screen display of the contents of one or more tables in a database
What is a report?
added to a table to summarize the values in a column
What is a total row button?
a query which asks for beginning and ending dates.
What is a parameter query?
The query design icon is located on this tab
What is the create tab?
something that must always have a value.
What is required?
a control which is linked to a field in a table or datasheet
What is a bound control?
rearranges the data and objects in a database to decrease its file size
What is compacting?
Questions asked about the data stored in a database.
What are queries?
A Wildcard is used for this.
What is represents unspecified characters?