DATABASE

25 July 2022
4.7 (114 reviews)
322 test answers

Unlock all answers in this set

Unlock answers (318)
question
You cannot edit or enter data into either Form design view or layout view
answer
a
question
Forms display data one field at a time.
answer
b
question
3. A form is a database object used to enter, edit, or view the data for an individual record.
answer
a
question
4. A Property Sheet allows you to enter data into a table.
answer
b
question
5. The field property that contains and displays the fields and data in a form is called the Property Source.
answer
b
question
6. When you create a simple form or report, Access includes all fields contained in the table on which the form or report is based.
answer
a
question
7. Before you enter data into a form, you must display the form in Form Design View.
answer
b
question
8. Forms are used to view data for an individual record.
answer
a
question
9. Because each bound control contains two parts, removing labels and controls depends on the part of the control selected.
answer
a
question
10. You can apply a different theme to different database objects.
answer
b
question
11. Which view in Access provides the Property Sheet? a. Layout View b. Form View c. Design View
answer
c
question
12. Which of the following is NOT a way to create a form? a. Form Wizard b. Design View c. Report View d. Layout View
answer
c
question
13. What benefit do forms provide? a. They allow you to focus on multiple records simultaneously. b. They allow you to focus on one record at a time. c. They make it easier to edit data. d. All of the above
answer
b
question
14. If a Security Warning appears when opening an Access database from a trusted source, click _____. a. Close b. Enable Content c. Save d. Ignore
answer
b
question
15. Which of the following is NOT an Access control that you can add to forms? a. Section control b. Bound control c. Unbound control d. Calculated control
answer
a
question
16. Which of the following is NOT a basic form element? a. Header b. Footer c. Section d. Title
answer
d
question
17. Additional form properties include all of the following EXCEPT_____: a. Status bar b. record selector bar c. scroll bars d. navigation buttons
answer
a
question
18. Which of the following is NOT a property that can be set in the property sheet? a. Width b. Name c. Height d. Number
answer
d
question
19. Which of the following is an option when printing forms? a. Print Preview b. Print individual forms c. Print all records d. All of the above
answer
d
question
1. You do NOT affect the table when you edit data in a query results datasheet.
answer
b
question
2. Queries are created for single use and, generally, are not saved.
answer
b
question
3. Queries can be used to create forms and reports.
answer
a
question
4. ">06/22/55" locates records containing the specific date.
answer
b
question
5. Sorting data as you run a query ensures consistency in data organization and makes locating data in the query results datasheet more efficient.
answer
a
question
6. A field can be included in a query and not be shown in the query results.
answer
a
question
7. Queries are the only database objects in which you can create calculated fields.
answer
a
question
8. Which of the following statements about queries is true? a. Queries provide an alternative way to locate data efficiently. b. The Query Design grid enables you to place fields in the order in which you want them to appear in the results datasheet. c. Results cannot be sorted in a query. d. Both a and b
answer
d
question
9. What is the benefit of using the Query Design View versus using a simple query? a. Criteria cannot be set for the data in Query Design View. b. Query Design View makes selecting fields from multiple tables more efficient. c. You cannot use a select query to group records and calculate totals. d. Totals can be calculated in a simple query.
answer
b
question
10. Which of the following statements is NOT true about queries? a. Queries are like questions that users ask the database. b. Table data is moved to the query results datasheet when you run a query. c. Queries are dynamic. d. Forms and reports can be created using queries.
answer
b
question
11. Which of the following functions can be used in an Access query? a. Sum b. Count c. Min d. All of the above
answer
d
question
12. Which of the following statements about setting criteria is true? a. Setting criteria for two different fields on the Criteria row creates an AND condition. b. Access uses two basic criteria conditions that apply to setting multiple criteria: AND, OR. c. You can set OR criteria to locate customers from two different states. d. All of the above
answer
d
question
13. What is the purpose of a crosstab query? a. It substitutes for a simple query. b. It presents data by rearranging the layout of fields in the query results datasheet and grouping the data to summarize it. c. It locates records containing duplicate field values in a single table or query. d. Both a and b
answer
d
question
14. Which of the following statements about unmatched and duplicates queries is NOT true? a. The goal of each query generated is to identify no records. b. Creating and running these types of queries helps maintain database integrity. c. The query results datasheet should show all records. d. None of the above
answer
c
question
1. Both Print Preview and Report View show an Access report as it will be printed. a. True b. False
answer
a
question
2. Unbound controls for form building are different for the unbound controls used for report building. a. True b. False
answer
a
question
3. Report controls can be added directly from a Field List. a. True b. False
answer
a
question
4. Sorting and Grouping levels are essentially the same. a. True b. False
answer
b
question
5. The Layout View is similar to the Design View, only with sample data. a. True b. False
answer
a
question
6. Print options in Access may vary slightly with different database objects. a. True b. False
answer
a
question
7. Page Breaks are recommended instead of Group Controls in Access. a. True b. False
answer
b
question
8. A "group" is a collection of records with all data elements in common. a. True b. False
answer
b
question
9. The Group bar in the Group Footer section is the only way to add calculated fields to a report. a. True b. False
answer
b
question
10. Report objects have property sheets just as form objects do. a. True b. False
answer
a
question
11. The _____ shows sample data and controls positioned as they will appear in the printed report. a. Design View b. Report Header c. Layout View d. Detail Section
answer
c
question
12. Specific details of a report control can be viewed and set in the _____. a. Sort Level b. Property Sheet c. Group Header d. Print Layout
answer
b
question
13. Totals and averages are examples of _____ functions. a. control b. sort c. format d. aggregate
answer
d
question
14. To avoid having a single "orphan" record on a printed Access report, the best option is to use _____ to control the layout. a. page breaks b. group controls c. Print Preview d. Design View
answer
c
question
15. The best view for viewing summarized data is _____. a. Report View b. Layout View c. Design View d. Datasheet View
answer
b
question
1. To change column width in a table, either drag the column border or double-click a column heading border. a. True b. False
answer
a
question
2. Moving and arranging field columns in a datasheet also changes the order of fields in the underlying structure of the table. a. True b. False
answer
b
question
3. Validation text contains instructions or valid data values to help guide the person entering data. a. True b. False
answer
a
question
4. Whenever you create a lookup field, Access automatically enables the multiple values capability. a. True b. False
answer
b
question
5. In a one-to-many relationship, each record in Table A can have multiple matching records in Table B, and each record in Table B can have multiple matching records in Table A. a. True b. False
answer
b
question
6. Relationships should be routinely reviewed and updated, especially when adding or removing fields. a. True b. False
answer
a
question
7. Access provides tools for creating custom text and memo fields. a. True b. False
answer
a
question
8. Lookup fields are only used for a very limited subset of data. a. True b. False
answer
a
question
9. Telephone numbers would be a good data set to utilize input masks. a. True b. False
answer
a
question
10. Validation rules are useful for helping to enforce accurate data entry. a. True b. False
answer
a
question
11. When you hide a column in a datasheet, the data in those columns _____. a. remains in the table b. is sent to an object c. is saved in another file d. is deleted from the table
answer
a
question
12. Each time you change the layout of a table, Access prompts you to _____ the table. a. close b. confirm c. save d. copy
answer
c
question
13. Identify the feature that would NOT be a benefit of setting up a lookup field. a. Reduces the time required to enter the data repeatedly b. Restricts data to valid entries c. Allows fields to be skipped d. All of the above
answer
c
question
14. The _____ steps you through creating a lookup field. a. source b. wizard c. field size d. Help files
answer
b
question
15. Which of the following is a benefit of a lookup table? a. Reduces the time required to enter data b. Reduces errors associated with data entry c. Restricts data to valid entries d. Allows you to specify a list of values for the field e. All of the above
answer
e
question
16. All of these options help maintain the integrity of data and relationships EXCEPT _____. a. Cascade Delete Related Records b. Cascade Update Related Fields c. Enforce Referential Integrity d. Maintain Existing Relationships e. Both c and d
answer
d
question
17. The following Table Layout adjustments are allowed EXCEPT _____. a. moving the columns b. selecting multiple fields c. resizing a column d. displaying table marquee
answer
d
question
1. Access refers to the main form as the child and the subform as the parent. a. True b. False
answer
b
question
2. Both the Form Wizard and Subform Control can be used to add a subform to an existing form. a. True b. False
answer
b
question
3. The Expression Builder is the only way to add calculations to forms. a. True b. False
answer
b
question
4. Locking is another term for disabling a form field. a. True b. False
answer
b
question
5. You cannot enter formulas in text boxes in a form. a. True b. False
answer
b
question
6. Text can be shown in a ScreenTip, which can be set to open as a pop-up window that stays on top of other open database objects. a. True b. False
answer
b
question
7. It's possible to access other database objects when a modal pop up is being displayed. a. True b. False
answer
b
question
8. Form elements such as text boxes can be locked using _____. a. a pop-up form b. ScreenTips c. the Subform Wizard d. the form Property Sheet
answer
d
question
9. When a form field can be clicked on but cannot be edited, it is _____. a. disabled b. frozen c. locked d. linked
answer
c
question
10. To create calculated controls in a subform you can _____. a. use the report wizard b. use the Expression Builder c. enter formulas directly into text box control source properties d. Both b and a
answer
c
question
11. A(n) _____ pop-up form does NOT allow the user to access other database objects while it's open. a. aggregate b. modal c. linked d. unbound
answer
b
question
12. When a form field appears on a form but cannot be clicked in or edited, it is _____. a. disabled b. locked c. calculated d. bound
answer
a
question
13. Which of the following are form sections? a. Detail Section b. Control Label c. Form Header d. Both a and c e. All of the above
answer
d
question
14. A subform is referred to as a _____. a. parent form b. historical form c. child form d. archival form
answer
c
question
15. To create tips to assist in data entry you would use _____. a. subforms b. text box controls with formulas in the control source c. the Expression Builder d. ScreenTips e. All of the above
answer
d
question
1. Select queries are designed to display data from specific fields contained in one or more database tables in a single datasheet. a. True b. False
answer
a
question
2. For Access to recognize text in the query Criteria row as a prompt to display onscreen, the criteria expression must be enclosed in square brackets. a. True b. False
answer
a
question
3. Action queries require that content within a database be disabled. a. True b. False
answer
b
question
4. If you rerun a make table query, Access will overwrite the existing table with a new table containing the records that meet the query criteria. a. True b. False
answer
a
question
5. A delete query removes the table from a database. a. True b. False
answer
b
question
6. In most cases, the parameter field appears in the query results datasheet. a. True b. False
answer
a
question
7. Access gives you the ability to create complex parameter queries. a. True b. False
answer
a
question
8. An update query is an action query that makes global changes to a group of records in one or more tables. a. True b. False
answer
a
question
9. When using a make table query, Access allows you to save your data in the existing database only. a. True b. False
answer
b
question
10. Which of the following is NOT an Access query type? a. Select b. Matched c. SQL d. Parameter
answer
b
question
11. Why would you want to avoid having a Cartesian product list resulting when you run a query? a. A Cartesian product list will cause the query to take a long time to run. b. A Cartesian product list will provide meaningless results. c. A Cartesian product list will result in deleting records. d. Both a and b
answer
d
question
12. What is the benefit of using a parameter query? a. It enables you to enter criteria to limit results without accessing Query Design view. b. Only those familiar with query design can use it. c. The parameter field must appear in the query results datasheet. d. Both a and c
answer
a
question
13. Which task is a good example of when it might be beneficial to create and run a select query? a. Creating calculated fields using values contained in other fields to summarize data b. Selecting records based on criteria c. Using a maximum function d. All of the above
answer
d
question
14. If you want to add records to another table, you create and run a(n) _____ query. a. append b. make table c. parameter d. select
answer
a
question
15. For an action that makes global changes to a group of records, create and run a(n) _____ query. a. append b. update c. make table d. delete
answer
b
question
16. Which statement about a make table query is true? a. A make table action query simply copies all fields and data from one table and creates a new table. b. You can only use a make table query to create a new table based on data from one table in a database. c. Using a make table query is a great way to get data from a calculated field in a query into a table.
answer
c
question
17. What can Cartesian products return? a. Duplicate data values b. Meaningless results c. All possible combinations from the query d. All of the above
answer
d
question
18. A(n) _____ query locates records in one table that have no match in another. a. duplicates b. unmatched c. unique d. no-match
answer
b
question
19. Content must be enabled for all the following queries EXCEPT _____. a. make table query b. append action query c. update query d. All of the above e. None of the above
answer
e
question
1. To save a report as a new database object, you must first make a copy of the subreport and then rename it. a. True b. False
answer
a
question
2. When you create a quick form from the Create tab and then resize a text box in the Detail section, all the other text boxes stay the same size. a. True b. False
answer
b
question
3. The Running Sum property controls how Access numbers items in a report. a. True b. False
answer
a
question
4. The Can Grow property sets up a subreport to expand so that all records are displayed. a. True b. False
answer
a
question
5. Adding a page break control to a report tells Access to break the report at that point, regardless of how many records appear on the page. a. True b. False
answer
a
question
6. SmartTags present options for correcting errors for report controls. a. True b. False
answer
a
question
7. Calculated controls can appear in a group footer or a page footer, but NOT in a report footer. a. True b. False
answer
b
question
8. To number records in a report, you must first set a control on the report and specify the first number. a. True b. False
answer
b
question
9. After analyzing report performance, you can instruct the analyzer to make corrections for you. a. True b. False
answer
a
question
10. Access does NOT permit numbering items in a subreport control on the main report. a. True b. False
answer
a
question
11. In a subreport, where do you position a calculated control that calculates totals for the entire report? a. In the main Report Footer section b. In the main Page Footer section c. In the subreport Report Footer section d. In the subreport Detail section
answer
c
question
12. If you add a subreport to a report and receive a warning that the specified table, query, or form does not exist in the database, which action can you try to correct the problem? a. Modify the Record Source property b. Import the missing object c. Correct the typo d. All of the above
answer
d
question
13. How do you determine whether a database is running at its most efficient? a. Run the Performance Analyzer. b. Compress it. c. Run the Documenter. d. Remove the extraneous objects.
answer
a
question
14. On what database object can a subreport be based? a. Tables and queries only b. Tables, queries, and forms only c. Tables, queries, forms, and reports d. Tables, forms, and reports
answer
c
question
15. What property contains the formula for a calculated control? a. Calculated Control property b. Control Source property c. Size Mode property d. Format property
answer
b
question
16. Which control must be added to a report to automatically number items in a report? a. Subform control b. Subreport control c. Text box control d. Label control
answer
c
question
17. What section of a report contains the appropriate control to automatically number items? a. Page Header b. Report Footer c. Page Footer d. Detail
answer
d
question
18. Which property allows the subreport control to dynamically resize itself based on the amount of data in the subreport? a. Orientation b. Can Grow c. Can Shrink d. Both b and c a
answer
d
question
1. Database properties are similar to object properties, but they define features of the database as a whole. a. True b. False
answer
a
question
2. Most users interact with the back end of a split database. a. True b. False
answer
b
question
3. Navigation Forms must be created with the Switchboard Manager; they cannot be created manually. a. True b. False
answer
b
question
4. The database splitter converts a database into two files. a. True b. False
answer
a
question
5. Once set, it's impossible to override the startup options as you open the database. a. True b. False
answer
b
question
6. Navigation forms cannot link to both forms and reports. a. True b. False
answer
b
question
7. Controlling the color of datasheets, setting default fonts, and setting the default startup form are all features of Access options. a. True b. False
answer
a
question
8. The Navigation Pane allows you to display different objects in different views. a. True b. False
answer
a
question
9. The .lockdb file controls record locking. a. True b. False
answer
b
question
10. The database splitter converts the database into two filesβ€”one that contains the tables holding the data and one that contains other database objects like reports, queries, and forms. a. True b. False
answer
a
question
11. Navigation Forms use _____ to group common commands by category. a. tabs b. links c. queries d. switchboards
answer
a
question
12. Before creating a main switchboard, it's necessary to _____. a. create a navigation form b. set a startup form for the database c. open the database exclusively d. add the Switchboard Manager button to the Ribbon
answer
d
question
13. Before splitting a database, it's a good idea to _____. a. divide the database into a front end and back end b. create a backup c. secure the database with a password d. open the database as Read-Only
answer
b
question
14. You can select database objects, identify objects associated with each object type, and switch among database objects using the _____. a. Database Splitter b. Access Options dialog box c. Database Properties window d. Navigation Pane
answer
d
question
15. When splitting a database, the _____ refer(s) to the underlying tables of the database. a. front end b. back end c. key components d. protected parts
answer
b
question
16. All of the following are object types that can appear on the Navigation Pane EXCEPT _____. a. tables b. queries c. nodes d. reports e. modules
answer
c
question
17. Database properties include the following: a. Title b. Subject c. Author d. All of the above e. None of the above
answer
d
question
18. To override the database start-up options, you should _____. a. press [Esc] multiple times b. Hold [Ctrl]+[Alt] c. Hold [Shift] d. Nothing; you cannot override startup options
answer
c
question
1. Access 2013 cannot open Access 2003 files. a. True b. False
answer
b
question
2. Access displays the version of the file in the title bar. a. True b. False
answer
a
question
3. A linked file allows source data to be placed into a destination file that is automatically updated when the source data is changed. a. True b. False
answer
a
question
4. Data cannot be copied and pasted from Access to other applications. a. True b. False
answer
b
question
5. Access objects exported as HTML are updated automatically. a. True b. False
answer
b
question
6. Hyperlinks can launch another application and open a specific file. a. True b. False
answer
a
question
7. Hyperlinks are typically underlined and formatted a light blue color. a. True b. False
answer
a
question
8. Access data can be integrated with Excel. a. True b. False
answer
a
question
9. The Linked Table Manager enables you to break a link between an Excel spreadsheet and an Access table. a. True b. False
answer
b
question
10. You can use drag and drop techniques to copy Access data into Word. a. True b. False
answer
a
question
11. What format does Access use to format documents posted on the web? a. XMX b. XSD c. HTML d. XSL
answer
c
question
12. Between database objects and what other types of objects can you create a hyperlink? a. Other database objects b. Web pages c. Files stored in a folder d. Both a and c e. All of the above
answer
e
question
13. Which of the following is true about attachment limitations in Access? a. A maximum of 2 GB of data can be attached to a database. b. You can only create one attachment per database. c. The file size for individual attachments is limited to 256 MB. d. Both b and c e. Both a and c
answer
e
question
14. When you merge a table with a Word document, which of the following options is NOT presented? a. Link to an Existing Word Document b. Publish Database Objects c. Create a New Word Document d. Preview Results
answer
b
question
15. Which of the following is a valid way to share data with Word? a. A mail merge b. Copy and paste c. A linked file d. All of the above
answer
d
question
16. The process of sending data to other files or applications is known as _____. a. exporting b. importing c. formatting d. saving
answer
a
question
17. What can be used to fix broken links in an Access database? a. Import Wizard b. Export Wizard c. Linked Table Manager d. The Export Tools menu
answer
c
question
18. Which of the following formats is recognized by Access 2013? a. 2010 b. 2013 c. 2007 d. 2003 e. All of the above
answer
e
question
1. Command buttons can be used for record navigation and report operations, among other things. a. True b. False
answer
a
question
2. Macros improve efficiency by automating and grouping multiple steps into one action. a. True b. False
answer
a
question
3. Macros must be kicked off manually and cannot be run through command buttons. a. True b. False
answer
b
question
4. Backing up a database does not need to be done frequently. a. True b. False
answer
b
question
5. Documenting a database can help you determine whether your database is meeting your business needs. a. True b. False
answer
a
question
6. Database Documenter can help examine the database and report potential trouble spots that may affect database functions. a. True b. False
answer
a
question
7. It is recommended that a strong password should be used when encrypting a database. a. True b. False
answer
a
question
8. Passwords cannot start with a space. a. True b. False
answer
a
question
9. The default setting for a database is a shared file. a. True b. False
answer
a
question
10. A database must be opened exclusively when setting security. a. True b. False
answer
a
question
11. Cloud storage is on-premise storage on the network that allows you to store and back up files somewhere other than your local computer. a. True b. False
answer
b
question
12. Strong passwords should contain _____. a. upper- and lowercase characters b. symbols and numbers c. at least eight characters d. All of the above
answer
d
question
13. Which of the following providers does NOT offer cloud storage? a. Microsoft b. Cloud USA c. Google d. Carbonite
answer
d
question
14. Command buttons allow for the following actions: a. Print Report b. Open Report c. Find Record d. Go to Next Record e. All of the above
answer
e
question
15. Which of the following functions are part of database object management? a. Deleting unneeded or duplicate objects b. Renaming database objects c. Saving the database to the cloud d. Both a and b e. All of the above
answer
d
question
16. Performance Analyzer does NOT _____. a. review database objects b. delete unnecessary data c. analyze relationships that exist d. identify problems that affect performance
answer
b
question
17. Which of the following is a function of the Database Documenter? a. Identifies potential issues in relationships b. Documents suspected unneeded data c. Builds an Object Definition document d. Suggests more efficient data types for objects hat affect performance
answer
c
question
18. When setting database security, you should open the database in _____ mode. a. Open Exclusive b. Open c. Open Read Only d. Open Exclusive Read-Only
answer
a
question
Table
answer
A file or collection of related records. Contains data used in all other database objects. Allows you to view many or all of the records in a file at the same time
question
Form
answer
A database screen used to enter, edit, or view the data for a individual record in a layout that is more convenienet and attractive than a table layout Typically only displays one record at a time- safer to enter data
question
Query
answer
a database object or module used to request, search, select, and sort data contained in tables based on specific criteria and conditions
question
report
answer
a database page that presents processed and summarized data from table sand queries as meaningful information in a format that is easy to read and designed to be printed
question
foreign key
answer
a field in a secondary table that corresponds and links to the primary key in the main table- where the specific information for a particular item is stored must me same type of data as a primary key
question
primary key
answer
a field with a unique id that will not be the same for any two database records
question
autonumber
answer
values start at 1 and are increased by 1 for each subsequent record
question
normalization
answer
organizing tables and fields into their smallest distinct parts and the efficiently linking the data together through relationship key fields
question
reverse words
answer
special meanings and cannot be used as field names ex- name and date
question
relational database
answer
contains two or more tables linked (related) to each other by unique identifying key fields ie- productid or invoice numebr
question
database
answer
organized collection of related data files or tables
question
data
answer
pieces of information such as numbers, names, dates, etc
question
database managment software
answer
allows users to store, manipulate, and retrieve databse information
question
structured query language (SQL)
answer
command line driven database management- a managment programing language
question
work area
answer
largest part of the screen- where you work on your main database objects
question
navigation pane aka objects panel
answer
lists existing database objects, specifically tables, queries, forms and reports
question
object
answer
a structure used to either sort or reference data such as a table, query, form or report
question
design view
answer
can create a form, assign formatting to data fields, and edit the layout and content on the form
question
layout view
answer
combines the editing ability of design view with the layout look of form view so you can better visualize and modify the forms appearence but you cannot add, change, or delete records
question
form view
answer
prodides a user friendly way to add, edit and delete table records but you cannot modify the layout
question
relationships
answer
one to one one to many many to many
question
one to one
answer
table a can only match with table b
question
one to many
answer
table a can match to multiple records in table b
question
many to many
answer
when two tables each have many matching records in the other table but they do not share key fields so they use a third junction table to tie other tables and complete the relationship
question
entry relationship data diagram- ERD
answer
helps to model and display relationships between entries- specifcially between tables and fields as establishign key frields
question
data type
answer
sets the characteristics of a particular field, identifying the types of values of a particular field, identifiying the values the field should hold, such as text, numbers, dates or hyperlinks
question
short tex
answer
default data type that contains up to 255 characters- numbers arent included in calculation
question
long text
answer
contains between 1- 63,999 characters
question
number
answer
numberic data used in calculations
question
date and time
answer
date and time
question
currency
answer
numeric values representing dollars
question
autonumber
answer
a field for which access automatically assigns a unique identifying number to records as they area dded to a table, cannot me modified, reused, if deleted there will be gaps
question
yes/no
answer
single character entires
question
ole object
answer
embedded or linked objects (excel spreadsheets, documents etc) storage limit of 1 gb
question
typerlink
answer
links to webpages when clicked
question
attachment
answer
data type that identifies a file ie- document or dimage that will be included as a attachment
question
calculated
answer
field created doing math on values in other windows within the table
question
lookup wizard
answer
field that displays a dropdown list of values from another table or from a list of values you type a common lookup field is a dropdown list of state abbreviations
question
sort
answer
access sorts records according to the primary key field identified when a table is created and fields are setup
question
sort ascending-
answer
arranges data in alphabetical order A-Z or from lowest to highest numbers
question
sort descending
answer
Z-A or highest to lowest
question
primary sort field
answer
the last name can be this
question
secondary sort field-
answer
only considered when multiple records contain the same data in the primary sort field
question
filter by selection
answer
selects reports based on the value contained in the archived field in the table
question
filter by form
answer
selects records based on values or conditions (critera) you type into form fields- access searches only the fields you specify
question
=
answer
equal- records must have a field that equals this value
question
<
answer
less than
question
>
answer
greater than
question
<>
answer
unequal values must be different than than the value entered
question
<=
answer
less than or equal to
question
>=
answer
greater than or equal to
question
*
answer
can represent multiple characters- a wild card
question
?
answer
each question mark represents a single character-
question
find what
answer
enter text to locate
question
replace with
answer
finds a value and replaces it with what you specify
question
look in
answer
searches only in teh active field or the entire document
question
match
answer
search for only data matching the whole field, any part of the field, or at the start of the field
question
search
answer
search up and down from the active curser or the whole table
question
search fields and formatted
answer
search data as it is displayed in the datasheet rather than as you type it
question
match case
answer
matches the exact capitalization pattern you like
question
sections
answer
main parts of a form, such as form header, form footer, detail, page header, and page footer, section bars seperacte form sections
question
page header
answer
contains text that will appear on the top of every printed page
question
page footer
answer
will be printed on teh bottom of all printed pages- not typically used in database records
question
detail section
answer
main section of a form that contains the text boxes that display data from database tables. Content values vary from record to record
question
controls
answer
items that display data, text, checkboxes, lines images and buttons
question
label
answer
part of a control that contains a caption identifying the data displayed in a text box of checkbox- ex last name. cannot be edited in form view
question
text box
answer
control that displays actual data from a table. record soruce for a text box is a corresponding field in an underlying table. can only be entered into a text box in form view
question
boudn control
answer
a control that ties, or binds form data to table data so the data appears on the form. normally appear in teh detail section
question
unbound control
answer
item that is independent of any table data. Can be text, shapes, and images and may appear in the form section
question
calculated control
answer
control tied to a calculated field or expression built in a query. ie total=price*quantity
question
record source
answer
field property that contains and displays the field and data in a form
question
wizard
answer
walks you through the process of selecting the table in a query that contains the specific fields and data you want to include in a from
question
anchored controls
answer
tie them to a section or to other controls so that moving or sizing a section adjusts the sizes as well
question
tab order
answer
enables you to view data on the form and access each field in the order it appears onscreen
question
select query
answer
allows you to select records based upon certain criteria that you set- ie- what are the customers addresses?
question
query design grid
answer
contains elements that enable you to set specific search criteria or sort the data
question
open close brackets
answer
matches text or individual characters placed within the brackets individually ie- ca[rt]- will find cat and car but not cab or cad
question
exclamation point
answer
matches any character within the brackets except those characters that follow the ! ie- ca[!rt]- will find cab, cad, cam but not cat or car
question
hyphen
answer
matches characters at the wildcard postiion that fall within a range of ascending values ie- ca[a-r] finds cab, but not cat
question
number sign
answer
locates any number digit at the potion of the #
question
return feature
answer
enables you to set the number of records to be displayed, or returned int eh query results- default setting is return feature all
question
calculated field name
answer
unique name you assign to field followed by a : to seperate the field name from expression
question
field names from exisiting tables
answer
will add []
question
concatenation
answer
combining fileds and expressions by using ampersand & to join text values from multiple fields
question
=date()
answer
current date
question
=now
answer
currentdt
question
aggregate functions
answer
finding minimum, maximum, average values, etc (what are in excel)
question
group by
answer
allows you to calculate among other things the running total, max, min etc
question
stdev
answer
calculates standard deviation of the values
question
var
answer
calculates the variance
question
first
answer
locates first record in group
question
last
answer
locates last record in group
question
crosstab queries
answer
allow you to easily analize data- lists the fields to be grouped on the leftside of the datasheet
question
find unmatched query
answer
locates records in one table that have no related records in another table
question
find duplicates query
answer
locates records containing duplicate field values in a single tab or query
question
referential integrity
answer
most important relationship protocol- a set of rules used to maintain the validity of the related data in a databse
question
cascade update
answer
updates value in teh key field of a related table if you change the primary key value in teh primary table
question
cascade delete
answer
delets records in a related table anytime you delete records in the primary table
question
format
answer
creates a predefinied display layout for fields ie currency or dependent
question
input mask
answer
identifies the format of values entered- with hyphens or without, abc or numeric, upper or lowercase
question
caption
answer
sets a column heading title to describe data better than a field name. can use spaces
question
default value
answer
adds default value for a specific field in each record ie fl
question
validation rules
answer
controls actual values entered into a field ie such as less than 100
question
validation text
answer
provides a tip that identifiesw all valid data such as all dates but be after
question
required
answer
sets the field as required to ensure a value is entered in teh field
question
field size
answer
sets a field length for the number of characters a field can hold
question
database index
answer
a structure whose main function is to speed up database operations
question
allow zero lenth
answer
ie- peoples phone numbers- have cell put in number () if they dont have a home phone
question
rich text
answer
can be formatted with different fonts, font sizes and colors
question
append only
answer
adds a series of date stamped comments to a single long text field- can createa history log- stored in a different table
question
smart tags
answer
allow you to apply format changes you make to a field in to table to the same field anywhere else it occurs
question
subform
answer
a secondary or child form placed in teh main- or parent form. work well with one to many allowing the user to view and enter complete data entries for multiple tables using one form
question
expression builder
answer
allows you to create formulas using expressions by selecting desired fields and operands in the expression builder dialog box
question
modal pop up
answer
displays a custom dialog box that prevents you from accessing other database objects until the dialog box is closed or required actions are taken
question
modeless pop up
answer
creates popup widow that sits on top of other open windows so you can continue to work as it is open
question
parameter query
answer
prompts user to enter data that access uses to fileter records and return only a subset of records that match value entered
question
crosstab query
answer
displays row headings on left side of datasheet and column headins on the top to sum- count, or average each column to the row rield
question
action query
answer
performs one of four actions on a group of records: deletes, updates, appends, or creates a new table
question
sql query
answer
uses sql to create a query. very few developers program in this.
question
unmatched query
answer
locates records in one table taht have no match in another
question
duplicates query
answer
locates records containuing duplicate field values in a single table or query
question
cartesians product list
answer
displays all possible combinations from a database query which uses fields form two unrelated tables
question
between [] and [[
answer
prompts user to enter the starting date and the end date
question
answer
displays prompt shown within brackets after the user enteres a value acess displays all records for values less than the one entered
question
make table query
answer
creates a new table from the selected data in one or more tables
question
append query
answer
adds a group of records from one or more sources to the end of one or more tables
question
update query
answer
makes a global change to a group of records in one or more tables
question
delete query
answer
deletes a group of records from one or more tables
question
subreports
answer
display subsets of data in reports and are derived from related database tables similar to subforms on forms
question
record locking
answer
access creates a small temp file by the same name with .laccdb the l stands for locked whcih means whenever one user updates or edits a record it is locked and no one else can change it until the first user moves to another record helps maintain consistent data and protects integrity
question
data splitter
answer
converts database into two files. one that holds tables data .
question
front end
answer
up front position of a split databse with which users interact
question
back end
answer
refers to underlying database tables that support the front end
question
switch board
answer
easy to use interface that contains menus and buttons for operating data base objects and performing common tasks such as adding records or printing reports
question
navigation form
answer
a special interface that allows you to quickly access forms and reports in your database
question
command buttons
answer
will perform buttons using design view
question
linked file
answer
allows source data to be placed in a desgination file that is automatically updated when changes are made to the source file
question
mail merge
answer
allows a business to merge selected datafield with a word document ie produces custom headings
question
text file
answer
alphanumeric text without formatting
question
rich text file
answer
contains minimal formatting such as color or bold
question
linked table manager
answer
aids in locating and redirecting database to correct file so you can view the data
question
hypertext mark up language
answer
html- code or language in which webpages are written
question
macro
answer
object that combines a series of steps into a single step so a more detailed task can be automated
question
performance analyzer
answer
analyzes the performance of database located and idenfiying potential trouble spots that affect how the database functions
question
database documenter
answer
documents objects in the database so that you can track cahnges to the design and relationships in the database- builds na object definition
question
fragmented-
answer
part of your database file becomes separated be incidental data that has been added to the disk you are using
question
compacting
answer
or compressing your databse to removed wasted and unused space
question
cloud storage
answer
online storage
question
webserver
answer
a combination of hardware and software used tot deliver webcontent that can be accessed online
question
skydrive
answer
provides cloud storage to anyone with a microsoft account
question
file synchronization syncin
answer
reliabily updating files stored at different locations on different devices