DATABASE

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

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


संबंधित स्टडी सेट्स

Anthropology Chapter One Test Quiz Questions

View Set

Chapter 23: The Agency Relationship- Creation, Duties, and Termination

View Set

The Picture of Dorian Gray - Das Bildnis des Dorian Gray (Oscar Wilde)

View Set

Unit 2 Objectives: Scientific Method

View Set