UNIT 9 BYU
How can you select what to filter? Click on the arrow key on the field name button. Click on the Z to A button. Click on the A to Z button. Click on the Find button.
Click on the arrow key on the field name button.
To get in-program help with queries, use External Data, Collect Data. Create, Queries. Home, Sort & Filter. Database Tools, Move Data.
Create, Queries.
Why would you use a form? It is an easier way to create a database. It is an easier way to create a table. It is an easier way to enter data into fields. It is an easier way to create a report.
It is an easier way to enter data into fields.
When looking for specific information from all the records in a database, you should use Queries. Sort. Forms. Filter.
Queries.
Your supervisor wants names and phone numbers of everyone in your database living in Canada. What database tool(s) would you use? Query and Report. Query and Filter. Print and Forms. Filter and Print.
Query and Report.
Someone sorted the database from Z to A by first name. How do you get rid of this sort? Filter Again Copy and Paste Refresh All Remove Sort
Remove Sort
When in a form, how do you move forward or backward? Use the search window. Change the ID number. Use the Next Record or Previous Record button. Use the arrow keys on the keyboard.
Use the Next Record or Previous Record button.
What is a database table? a group of related information a table with a bunch of computer parts on it a single piece of information a group of unrelated information
a group of related information
What is a database table? a single piece of information a group of related information a table with a bunch of computer parts on it a group of unrelated information
a group of related information
What is a database? a software application program that organizes information an operating system software that controls hardware a utility software that searches for and kills viruses a software application that creates business letters and reports
a software application program that organizes information
What is a form? entering data into a row of the database an easier way to enter data into the database a harder way to enter data into the database creating a report
an easier way to enter data into the database
What is a form? entering data into a row of the database creating a report an easier way to enter data into the database a harder way to enter data into the database
an easier way to enter data into the database
What is a field? all the information in the table all the information in a row of the table the entire database is called a field information from a single cell
information from a single cell
What is a field? all the information in the table the entire database is called a field all the information in a row of the table information from a single cell
information from a single cell
What is a record in a database? one row of information in the table one cell in the table one table in the database one report from the database.
one row of information in the table
What is a record in a database? one row of information in the table one cell in the table one report from the database. one table in the database
one row of information in the table
What is the name for a row of related information? database record field table
record
What is a query? searching one record searching the database for all information searching the database for specific information from all records searching for reports
searching the database for specific information from all records
What is a report? printing of the entire database specific information from the database in a printable document printing of one record from the database printing information that is not in the database
specific information from the database in a printable document
Information can be called from several tables. database programs. application programs. utility programs.
tables.
When would you use a filter? to add information to the database to limit information to specific requirements to alphabetize the list of information to see all the information in the database
to limit information to specific requirements
When would you use a filter? to limit information to specific requirements to add information to the database to see all the information in the database to alphabetize the list of information
to limit information to specific requirements
Where can you find additional information about features and functions of databases? under the External Data tab under the File tab and then Help under the Create tab and Reports under the Home tab and Find
under the File tab and then Help