1 / 27

Access Basics

Access Basics. More Access. Access Again. Access Leftovers. Access Continued. An Access file that could contain customer mailing addresses, phone numbers, as well as customer purchases and details of the purchase, is also known as a: table. database. field. record. Database. 1000.

roger
Télécharger la présentation

Access Basics

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Access Basics More Access Access Again Access Leftovers Access Continued Nasca 2007

  2. An Access file that could contain customer mailing addresses, phone numbers, as well as customer purchases and details of the purchase, is also known as a: table. database. field. record. Database 1000

  3. A customer name, address, city, state, and zip code make up a set of data called a: field. table. data. record. record 2000

  4. In the following image how many objects are open? 9 3000

  5. A grid used to display data in rows and columns is called the __________ View. Table Datasheet Report Design Datasheet 4000

  6. A field that requires unique data is called a: pencil. row indicator. primary key. plus sign. Primary key 5000

  7. Which application file type requires saving a file before working with it? Document Database Slideshow Worksheet Database 1000

  8. Creating a copy of a database in case the file becomes damaged or data is accidentally deleted can be accomplished by: repairing. compacting. defragmenting the disk. backing up. Backing up 2000

  9. Which statement best describes a situation in which you should use Excel instead of Access?There is a need to link to large external databases. The file contains a financial table that requires tracking numeric values and performing calculations. There are multiple tables that may require linking. Multiple users need to access and update data in the same database. The file contains a financial table that requires tracking numeric values and performing calculations. 3000

  10. Arranging a field of salaries from the highest to the lowest can be accomplished by performing a(n): ascending sort. descending sort. filter by selection. filter by form. Descending sort 4000

  11. The best object to use to narrow down records to those meeting set criteria, such as all the people that live in a specific city, is a: query. macro. table. form. query 5000

  12. A well-designed database requires that you: begin typing the data. visualize the output first. count the number of fields needed. type the fields and set the properties. visualize the output first 1000

  13. Which of the following guidelines to design a database is NOT correct? Design for the next 100 yearsInclude all the necessary dataEnsure compliance with Sarbanes OxleyUse calculated fields Use calculated fields 2000

  14. Which of the following would be used to take a database into some other application? Export data Offline SharePoint Lists Collect and Update Get External Data Export data 3000

  15. Clicking the Run button, which is a large red exclamation point located in the Results group will: perform or update calculations within the query. update all data and calculations throughout the file that is open. update field names in the query. update both field names and data in both the query and table(s). perform or update calculations within the query 4000

  16. In the following example, if Balance has a value of 10,000, what will be the correct outcome?IIF(Balance >= 10000, .035, .0275) 10,000 False .0275 .035 .035 5000

  17. In the following example, which part of the expression indicates a different table?=[SalePr]/[Homes]![Bathrooms][Homes][Bathrooms][SalePr] [Homes]![Bathrooms] [Homes] 1000

  18. A view that allows you to see the final report before printing is called: Report View. Print Preview View. Design View. WYSIWYG. Print Preview View 2000

  19. An expression would be used in (an):bound controlunbound controlpage footercalculated control Calculated control 3000

  20. A tool that provides options from a series of dialog boxes to create a report is known as a:Report ToolReport WizardDesign ViewLabel Wizard Report Wizard 4000

  21. An expression would be used in anunbound controlbound controlcalculated controlpage footer calculated control 5000

  22. After which step should the run button be used?Open query in DesignSelect design tabClick Builder buttonClick equal signSelect fields and functionsExit Builder BoxExamine and verify the results After Exit Builder Box 1000

  23. Expressions may contain all of the following except:queriesconstants and valuesfunctionsoperators queries 2000

  24. Why is a query a good data source for a mail merge?You can create new fields different from the data source fileAll fields are used for the mail merge from the data source fileOnly pertinent data is used for the mail mergeAll of these answers are correct Only pertinent data is used for the mail merge 3000

  25. A form may be used to ______. Create queriesmodify database structureupdate or review records Update or review records 4000

  26. Based on the following formula, what would be the correct sequence of values? Pmt(<<rate>>, <<nper>>, <<pv>>, <<fv>>, <<due>>) 0.085/12, 25*12, 90000, 0 25*12, 0.085/12, 90000, 0 90000, 0.085/12, 25*12, 0 0.085/12, 25*12, 0, 90000 0.085/12, 25*12, 90000, 0 5000

  27. Nasca 2007

More Related