DATABASE
Form
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
Table
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
sort descending
Z-A or highest to lowest
1. Both Print Preview and Report View show an Access report as it will be printed. a. True b. False
a
1. Command buttons can be used for record navigation and report operations, among other things. a. True b. False
a
1. Database properties are similar to object properties, but they define features of the database as a whole. a. True b. False
a
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
a
1. To change column width in a table, either drag the column border or double-click a column heading border. a. True b. False
a
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
a
10. A database must be opened exclusively when setting security. a. True b. False
a
10. Access does NOT permit numbering items in a subreport control on the main report. a. True b. False
a
10. Report objects have property sheets just as form objects do. a. True b. False
a
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
a
10. Validation rules are useful for helping to enforce accurate data entry. a. True b. False
a
10. You can use drag and drop techniques to copy Access data into Word. a. True b. False
a
11. Navigation Forms use _____ to group common commands by category. a. tabs b. links c. queries d. switchboards
a
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
a
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
a
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
a
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.
a
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
a
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
a
16. The process of sending data to other files or applications is known as _____. a. exporting b. importing c. formatting d. saving
a
17. Additional form properties include all of the following EXCEPT_____: a. Status bar b. record selector bar c. scroll bars d. navigation buttons
a
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
a
2. Access displays the version of the file in the title bar. a. True b. False
a
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
a
2. Macros improve efficiency by automating and grouping multiple steps into one action. a. True b. False
a
2. Unbound controls for form building are different for the unbound controls used for report building. a. True b. False
a
3. A form is a database object used to enter, edit, or view the data for an individual record.
a
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
a
3. Queries can be used to create forms and reports.
a
3. Report controls can be added directly from a Field List. a. True b. False
a
3. The Running Sum property controls how Access numbers items in a report. a. True b. False
a
3. Validation text contains instructions or valid data values to help guide the person entering data. a. True b. False
a
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
a
4. The Can Grow property sets up a subreport to expand so that all records are displayed. a. True b. False
a
4. The database splitter converts a database into two files. a. True b. False
a
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
a
5. Documenting a database can help you determine whether your database is meeting your business needs. a. True b. False
a
5. Sorting data as you run a query ensures consistency in data organization and makes locating data in the query results datasheet more efficient.
a
5. The Layout View is similar to the Design View, only with sample data. a. True b. False
a
6. A field can be included in a query and not be shown in the query results.
a
6. Database Documenter can help examine the database and report potential trouble spots that may affect database functions. a. True b. False
a
6. Hyperlinks can launch another application and open a specific file. a. True b. False
a
6. In most cases, the parameter field appears in the query results datasheet. a. True b. False
a
6. Print options in Access may vary slightly with different database objects. a. True b. False
a
6. Relationships should be routinely reviewed and updated, especially when adding or removing fields. a. True b. False
a
6. SmartTags present options for correcting errors for report controls. a. True b. False
a
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.
a
7. Access gives you the ability to create complex parameter queries. a. True b. False
a
7. Access provides tools for creating custom text and memo fields. a. True b. False
a
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
a
7. Hyperlinks are typically underlined and formatted a light blue color. a. True b. False
a
7. It is recommended that a strong password should be used when encrypting a database. a. True b. False
a
7. Queries are the only database objects in which you can create calculated fields.
a
8. Access data can be integrated with Excel. a. True b. False
a
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
a
8. Forms are used to view data for an individual record.
a
8. Lookup fields are only used for a very limited subset of data. a. True b. False
a
8. Passwords cannot start with a space. a. True b. False
a
8. The Navigation Pane allows you to display different objects in different views. a. True b. False
a
9. After analyzing report performance, you can instruct the analyzer to make corrections for you. a. True b. False
a
9. Because each bound control contains two parts, removing labels and controls depends on the part of the control selected.
a
9. Telephone numbers would be a good data set to utilize input masks. a. True b. False
a
9. The default setting for a database is a shared file. a. True b. False
a
You cannot edit or enter data into either Form design view or layout view
a
webserver
a combination of hardware and software used tot deliver webcontent that can be accessed online
boudn control
a control that ties, or binds form data to table data so the data appears on the form. normally appear in teh detail section
Query
a database object or module used to request, search, select, and sort data contained in tables based on specific criteria and conditions
report
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
autonumber
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
foreign key
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
primary key
a field with a unique id that will not be the same for any two database records
subform
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
navigation form
a special interface that allows you to quickly access forms and reports in your database
object
a structure used to either sort or reference data such as a table, query, form or report
database index
a structure whose main function is to speed up database operations
record locking
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
sort
access sorts records according to the primary key field identified when a table is created and fields are setup
append query
adds a group of records from one or more sources to the end of one or more tables
append only
adds a series of date stamped comments to a single long text field- can createa history log- stored in a different table
default value
adds default value for a specific field in each record ie fl
linked table manager
aids in locating and redirecting database to correct file so you can view the data
smart tags
allow you to apply format changes you make to a field in to table to the same field anywhere else it occurs
crosstab queries
allow you to easily analize data- lists the fields to be grouped on the leftside of the datasheet
mail merge
allows a business to merge selected datafield with a word document ie produces custom headings
linked file
allows source data to be placed in a desgination file that is automatically updated when changes are made to the source file
database managment software
allows users to store, manipulate, and retrieve databse information
group by
allows you to calculate among other things the running total, max, min etc
expression builder
allows you to create formulas using expressions by selecting desired fields and operands in the expression builder dialog box
select query
allows you to select records based upon certain criteria that you set- ie- what are the customers addresses?
text file
alphanumeric text without formatting
performance analyzer
analyzes the performance of database located and idenfiying potential trouble spots that affect how the database functions
sort ascending-
arranges data in alphabetical order A-Z or from lowest to highest numbers
1. Access 2013 cannot open Access 2003 files. a. True b. False
b
1. Access refers to the main form as the child and the subform as the parent. a. True b. False
b
1. You do NOT affect the table when you edit data in a query results datasheet.
b
10. Which of the following is NOT an Access query type? a. Select b. Matched c. SQL d. Parameter
b
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.
b
10. You can apply a different theme to different database objects.
b
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
b
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
b
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
b
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
b
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
b
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
b
14. The _____ steps you through creating a lookup field. a. source b. wizard c. field size d. Help files
b
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
b
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
b
15. The best view for viewing summarized data is _____. a. Report View b. Layout View c. Design View d. Datasheet View
b
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
b
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
b
16. Performance Analyzer does NOT _____. a. review database objects b. delete unnecessary data c. analyze relationships that exist d. identify problems that affect performance
b
18. A(n) _____ query locates records in one table that have no match in another. a. duplicates b. unmatched c. unique d. no-match
b
2. Both the Form Wizard and Subform Control can be used to add a subform to an existing form. a. True b. False
b
2. Most users interact with the back end of a split database. a. True b. False
b
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
b
2. Queries are created for single use and, generally, are not saved.
b
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
b
3. Action queries require that content within a database be disabled. a. True b. False
b
3. Macros must be kicked off manually and cannot be run through command buttons. a. True b. False
b
3. Navigation Forms must be created with the Switchboard Manager; they cannot be created manually. a. True b. False
b
3. The Expression Builder is the only way to add calculations to forms. a. True b. False
b
4. ">06/22/55" locates records containing the specific date.
b
4. A Property Sheet allows you to enter data into a table.
b
4. Backing up a database does not need to be done frequently. a. True b. False
b
4. Data cannot be copied and pasted from Access to other applications. a. True b. False
b
4. Locking is another term for disabling a form field. a. True b. False
b
4. Sorting and Grouping levels are essentially the same. a. True b. False
b
4. Whenever you create a lookup field, Access automatically enables the multiple values capability. a. True b. False
b
5. A delete query removes the table from a database. a. True b. False
b
5. Access objects exported as HTML are updated automatically. a. True b. False
b
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
b
5. Once set, it's impossible to override the startup options as you open the database. a. True b. False
b
5. The field property that contains and displays the fields and data in a form is called the Property Source.
b
5. You cannot enter formulas in text boxes in a form. a. True b. False
b
6. Navigation forms cannot link to both forms and reports. a. True b. False
b
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
b
7. Before you enter data into a form, you must display the form in Form Design View.
b
7. Calculated controls can appear in a group footer or a page footer, but NOT in a report footer. a. True b. False
b
7. It's possible to access other database objects when a modal pop up is being displayed. a. True b. False
b
7. Page Breaks are recommended instead of Group Controls in Access. a. True b. False
b
8. A "group" is a collection of records with all data elements in common. a. True b. False
b
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
b
9. The .lockdb file controls record locking. a. True b. False
b
9. The Group bar in the Group Footer section is the only way to add calculated fields to a report. a. True b. False
b
9. The Linked Table Manager enables you to break a link between an Excel spreadsheet and an Access table. a. True b. False
b
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.
b
9. When using a make table query, Access allows you to save your data in the existing database only. a. True b. False
b
Forms display data one field at a time.
b
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
c
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
c
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
c
11. What format does Access use to format documents posted on the web? a. XMX b. XSD c. HTML d. XSL
c
11. Which view in Access provides the Property Sheet? a. Layout View b. Form View c. Design View
c
12. Each time you change the layout of a table, Access prompts you to _____ the table. a. close b. confirm c. save d. copy
c
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
c
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
c
14. A subform is referred to as a _____. a. parent form b. historical form c. child form d. archival form
c
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
c
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
c
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
c
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
c
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
c
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.
c
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
c
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
c
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
c
9. When a form field can be clicked on but cannot be edited, it is _____. a. disabled b. frozen c. locked d. linked
c
stdev
calculates standard deviation of the values
var
calculates the variance
rich text
can be formatted with different fonts, font sizes and colors
design view
can create a form, assign formatting to data fields, and edit the layout and content on the form
*
can represent multiple characters- a wild card
layout view
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
concatenation
combining fileds and expressions by using ampersand & to join text values from multiple fields
structured query language (SQL)
command line driven database management- a managment programing language
long text
contains between 1- 63,999 characters
query design grid
contains elements that enable you to set specific search criteria or sort the data
rich text file
contains minimal formatting such as color or bold
page header
contains text that will appear on the top of every printed page
relational database
contains two or more tables linked (related) to each other by unique identifying key fields ie- productid or invoice numebr
text box
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
calculated control
control tied to a calculated field or expression built in a query. ie total=price*quantity
validation rules
controls actual values entered into a field ie such as less than 100
data splitter
converts database into two files. one that holds tables data .
make table query
creates a new table from the selected data in one or more tables
format
creates a predefinied display layout for fields ie currency or dependent
modeless pop up
creates popup widow that sits on top of other open windows so you can continue to work as it is open
=date()
current date
=now
currentdt
11. Which of the following functions can be used in an Access query? a. Sum b. Count c. Min d. All of the above
d
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
d
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
d
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
d
12. Strong passwords should contain _____. a. upper- and lowercase characters b. symbols and numbers c. at least eight characters d. All of the above
d
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
d
13. Totals and averages are examples of _____ functions. a. control b. sort c. format d. aggregate
d
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
d
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
d
13. Which of the following providers does NOT offer cloud storage? a. Microsoft b. Cloud USA c. Google d. Carbonite
d
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
d
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
d
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
d
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
d
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
d
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
d
16. Which of the following is NOT a basic form element? a. Header b. Footer c. Section d. Title
d
17. Database properties include the following: a. Title b. Subject c. Author d. All of the above e. None of the above
d
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
d
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
d
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
d
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
d
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
d
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
d
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
d
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
d
attachment
data type that identifies a file ie- document or dimage that will be included as a attachment
date and time
date and time
short tex
default data type that contains up to 255 characters- numbers arent included in calculation
delete query
deletes a group of records from one or more tables
cascade delete
delets records in a related table anytime you delete records in the primary table
subreports
display subsets of data in reports and are derived from related database tables similar to subforms on forms
modal pop up
displays a custom dialog box that prevents you from accessing other database objects until the dialog box is closed or required actions are taken
cartesians product list
displays all possible combinations from a database query which uses fields form two unrelated tables
<what is the highest price you will pay>
displays prompt shown within brackets after the user enteres a value acess displays all records for values less than the one entered
crosstab query
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
database documenter
documents objects in the database so that you can track cahnges to the design and relationships in the database- builds na object definition
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
e
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
e
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
e
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
e
18. Which of the following formats is recognized by Access 2013? a. 2010 b. 2013 c. 2007 d. 2003 e. All of the above
e
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
e
?
each question mark represents a single character-
switch board
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
ole object
embedded or linked objects (excel spreadsheets, documents etc) storage limit of 1 gb
return feature
enables you to set the number of records to be displayed, or returned int eh query results- default setting is return feature all
tab order
enables you to view data on the form and access each field in the order it appears onscreen
find what
enter text to locate
=
equal- records must have a field that equals this value
calculated
field created doing math on values in other windows within the table
record source
field property that contains and displays the field and data in a form
lookup wizard
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
aggregate functions
finding minimum, maximum, average values, etc (what are in excel)
replace with
finds a value and replaces it with what you specify
>
greater than
>=
greater than or equal to
entry relationship data diagram- ERD
helps to model and display relationships between entries- specifcially between tables and fields as establishign key frields
hypertext mark up language
html- code or language in which webpages are written
input mask
identifies the format of values entered- with hyphens or without, abc or numeric, upper or lowercase
allow zero lenth
ie- peoples phone numbers- have cell put in number () if they dont have a home phone
unbound control
item that is independent of any table data. Can be text, shapes, and images and may appear in the form section
controls
items that display data, text, checkboxes, lines images and buttons
work area
largest part of the screen- where you work on your main database objects
<
less than
<=
less than or equal to
typerlink
links to webpages when clicked
navigation pane aka objects panel
lists existing database objects, specifically tables, queries, forms and reports
number sign
locates any number digit at the potion of the #
first
locates first record in group
last
locates last record in group
find duplicates query
locates records containing duplicate field values in a single tab or query
duplicates query
locates records containuing duplicate field values in a single table or query
unmatched query
locates records in one table taht have no match in another
find unmatched query
locates records in one table that have no related records in another table
sections
main parts of a form, such as form header, form footer, detail, page header, and page footer, section bars seperacte form sections
detail section
main section of a form that contains the text boxes that display data from database tables. Content values vary from record to record
update query
makes a global change to a group of records in one or more tables
exclamation point
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
hyphen
matches characters at the wildcard postiion that fall within a range of ascending values ie- ca[a-r] finds cab, but not cat
open close brackets
matches text or individual characters placed within the brackets individually ie- ca[rt]- will find cat and car but not cab or cad
match case
matches the exact capitalization pattern you like
referential integrity
most important relationship protocol- a set of rules used to maintain the validity of the related data in a databse
number
numberic data used in calculations
currency
numeric values representing dollars
macro
object that combines a series of steps into a single step so a more detailed task can be automated
relationships
one to one one to many many to many
cloud storage
online storage
secondary sort field-
only considered when multiple records contain the same data in the primary sort field
compacting
or compressing your databse to removed wasted and unused space
database
organized collection of related data files or tables
normalization
organizing tables and fields into their smallest distinct parts and the efficiently linking the data together through relationship key fields
label
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
fragmented-
part of your database file becomes separated be incidental data that has been added to the disk you are using
action query
performs one of four actions on a group of records: deletes, updates, appends, or creates a new table
data
pieces of information such as numbers, names, dates, etc
form view
prodides a user friendly way to add, edit and delete table records but you cannot modify the layout
parameter query
prompts user to enter data that access uses to fileter records and return only a subset of records that match value entered
between [] and [[
prompts user to enter the starting date and the end date
validation text
provides a tip that identifiesw all valid data such as all dates but be after
skydrive
provides cloud storage to anyone with a microsoft account
back end
refers to underlying database tables that support the front end
file synchronization syncin
reliabily updating files stored at different locations on different devices
search fields and formatted
search data as it is displayed in the datasheet rather than as you type it
match
search for only data matching the whole field, any part of the field, or at the start of the field
search
search up and down from the active curser or the whole table
look in
searches only in teh active field or the entire document
filter by form
selects records based on values or conditions (critera) you type into form fields- access searches only the fields you specify
filter by selection
selects reports based on the value contained in the archived field in the table
caption
sets a column heading title to describe data better than a field name. can use spaces
field size
sets a field length for the number of characters a field can hold
data type
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
required
sets the field as required to ensure a value is entered in teh field
yes/no
single character entires
reverse words
special meanings and cannot be used as field names ex- name and date
one to many
table a can match to multiple records in table b
one to one
table a can only match with table b
primary sort field
the last name can be this
anchored controls
tie them to a section or to other controls so that moving or sizing a section adjusts the sizes as well
<>
unequal values must be different than than the value entered
calculated field name
unique name you assign to field followed by a : to seperate the field name from expression
front end
up front position of a split databse with which users interact
cascade update
updates value in teh key field of a related table if you change the primary key value in teh primary table
sql query
uses sql to create a query. very few developers program in this.
autonumber
values start at 1 and are increased by 1 for each subsequent record
wizard
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
many to many
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
field names from exisiting tables
will add []
page footer
will be printed on teh bottom of all printed pages- not typically used in database records
command buttons
will perform buttons using design view
