Metadata is information about the file. Show The metadata usually has the name of the owner of the computer, the date that a file was created, the date the file was last modified, file size, number of pages, who modified the file, and other information.
Terms in this set (80)A ________ enables you to quickly link to any file on your computer or to any Web page on the Internet. hyperlink A(n) ________ is the location of a Web site or Web page on the Internet. URL Which of the following fields enables you to add multiple files of different types to a table? Attachment What differentiates a hyperlink from text? Blue underline What happens when you click a hyperlink field value while in Datasheet view? Access launches the program required to display the file or Web page In Access, what is a reference to an external file called? Attachment What type of files are compressed by Access when you attach them? Word and Excel files Which of the following file types increases the database size byte for byte when attached in Access? JPEG and other photo formats How is an attachment field identified in a table? Paperclip What is the default software application associated with a CSV file? Microsoft Excel What happens each time you open an attachment file in Access? Access creates a temporary file on your computer's hard drive. What do you do if you only want to export part of a table to Excel? Filter the table first What happens when you export a form with a subform to Excel? The form exports but the subform does not What is the main reason for exporting data to Excel instead of Word? You are not able to analyze the data as you can in Excel. What type of file does Access create when exporting to Word? RTF ________ is a useful format for basic formatted text documents such as instruction manuals, resumes, letters, and other documents. RTF ________ documents cannot be edited after being exported. PDF or XPS When you double-click on a document with a RTF file extension, which of the following programs does Windows open by default? Word The objects you select to export from Access to Word should have which of the following types of layout? Tabular How do you insert blank lines above a table after exporting it from Access into Word? Click immediately before the first value in the first cell of the table and press Enter to add an additional line. The ________ file format does not allow you to edit the exported documents. The ________ file format was created by Adobe Systems for document exchange independent of software application and operating system environment. The ________ file format is considered an alternative to PDF. XPS When exporting to a PDF, what should you check for when the objects are exported? The number of pages Which application allows you to view XPS documents if the XPS viewer has not been installed? Your browser Before exporting a table to another database, what must be done first? A database must be created. ________ allows you connect to a table without having to import the table data into your database. Linking What does Access do when you link a table to another Access database? Creates a new table called a linked table A(n) ________ appears next to a linked table name in the Navigation Pane. arrow What happens to the size of an Access database when a table is linked to an Excel spreadsheet? The size of the database remains the same. Before linking to a spreadsheet, you must first: make sure the data is organized. What is one reason to import an Excel worksheet into Access instead of linking it? You have more control over the imported data What can you do if a comparable table already exists when you import a spreadsheet? Append a copy of the Excel records to the table ________ are common methods of exchanging information between two computer systems. Text files ________ uses a comma to separate one column from the next, enabling the receiving software to distinguish one set of field values from the next. CSV text files ________ allocate a certain number of characters for each field. Fixed-length text files Which of the following allows you to manage attached files in forms and reports? Attachment control What happens when you double-click an attachment field in a table? A dialog box opens with options What is the purpose of a ScreenTip? It displays when you point your mouse over the hyperlink text Access is not able to ________ an attachment. analyze the data within A hyperlink field enables you to attach multiple files of different types. false Once a hyperlink has been added to a table, it cannot be edited. false When adding a file to an attachment field, the file is actually copied into the database itself. true Word and Excel files are compressed by Access when you attach them. true JPEG and other photo formats increase the database size byte for byte. true Once an attachment is added to a database table the file is saved as long as you have clicked the record below the current record. true Once an attachment is added, the only way to delete the attachment is to delete the record. false Access creates a temporary file on your computer each time you open an attachment file. true An attachment appears as a paperclip in a table. true In a report, click the next and previous arrows on the Attachment toolbar to advance from one attachment to the next. true Exporting data from Access to Excel is generally very complicated because the format of Access is different than Excel. false When you export a table to Excel, the field names become the column headings and the records become the rows in the Excel spreadsheet. true When you export a table from Access, the table must be closed for the export to complete. false When exporting a table to Excel, all records in the table are exported, even if they are not needed. true If you want to export specific records in a table to Excel, you can either filter the table or create a query for the needed records. true Saving the export steps is the last step in the export process. true Exporting tables and queries to Excel is usually predictable and consistent because of the similarity between an Access datasheet and an Excel spreadsheet. true When exporting from Access to Word, you are not able to analyze the data in Word. true When you export an object from Access to Word, Access creates a file in the PDF format. true Rich Text Format (RTF) is a format that enables documents created in one software application to be opened with a different software application. true The file extension for a Rich Text Format file is slx. false Columnar forms and reports do not export to Word properly. true After you export an Access table to an RTF file, the file cannot be edited in Word. false When you save an RTF file, you might want to change the file type to a Word document in order to make formatting and editing easier. true PDF or XPS documents can be opened by their respective document readers, which are free downloads. true PDF is a file format created by Microsoft. false XPS is a file format that displays a printed page onscreen identically on any computer platform. true Tables, queries, forms and reports can all be exported to a PDF or XPS document. true After exporting a file, if the document is too wide to display all the text, it will display on two pages. true PDF documents are the preferred format when exporting from Access. true When you export a table structure from one Access database to another, the new database has to be created. true Before exporting a table to another database, the new database has to be created. true An imported Excel spreadsheet displays in the Navigation Pane as a linked table. false A linked table is marked with an asterisk in the Navigation Pane. false Linking and importing produce the same result in Access. false For an import to be successful, column headings and data formats should be an exact match, and in the same order, to those in your database. true A linked file opens in Access even though the data resides in an external Excel file. true One of the main reasons for importing a spreadsheet into Access is that you have more control over the imported data. true Match the following terms with their meanings: (5 points) CSV text file Correct answer uses a comma to separate one column from another, enabling the receiving software to distinguish one set of field values from the next fixed-length text file Correct answer allocates a certain number of characters for each field hyperlink Correct answer data type that enables you to quickly link to any file on your computer or any Web page on the Internet importing Correct answer enables you to copy external data into your database without linking it to your source file ...
Match the following terms with their meanings: (5 points) portable document format (PDF) Correct answer a file format created by Adobe Systems for document exchange independent of software application and operating system environment Rich Text Format (RTF) Correct answer format that enables documents created in one software application to be opened with a different software application Text file Correct answer a common file format for exchanging data between two computer systems XML Paper Specification (XPS) Correct answer a file format developed by Microsoft and designed to display a printed page onscreen identically on any computer platform ... Students also viewedBIS245 CHAPTER 8 QUIZ21 terms mceliceo Access 8 Quiz62 terms mallory_fischer3 Practice Quiz #10 Access Chapter 210 terms smithjflute Access Module 1,2,3, and Test112 terms Liz-S Sets found in the same folderAccess Chapter 780 terms itoivone Access Chapter 677 terms itoivone Chapter 11 myitlab Isaac Toivonen75 terms itoivone Chapter 12 myitlab Isaac Toivonen75 terms itoivone Other sets by this creatorMGMT 458 Midterm Exam31 terms itoivone Geib's International Management34 terms itoivone Business or Money Words in Spanish78 terms itoivone delete9 terms itoivone Verified questionscomputer science True/False. Each node in a heap must have a value less than its siblings. Verified answer
computer science Which of the following pairs of variables are different from each other? a. Total and total, b. case and CASE, c. codeTwo and code2, d. oneMore and one_More, e. all of the above. Verified answer
computer science Write a program that takes an input from the user and asks to enter filename. It then opens the file for reading it. If the file is not found, catch the exception and give a suitable message. Verified answer
computer science Which of the following is not a dictionary method? a) get b) keys c) sort d) clear Verified answer Recommended textbook solutionsInformation Technology Project Management: Providing Measurable Organizational Value5th EditionJack T. Marchewka 346 solutions
Introduction to Algorithms3rd EditionCharles E. Leiserson, Clifford Stein, Ronald L. Rivest, Thomas H. Cormen 726 solutions
Service Management: Operations, Strategy, and Information Technology7th EditionJames Fitzsimmons, Mona Fitzsimmons 103 solutions
Fundamentals of Database Systems7th EditionRamez Elmasri, Shamkant B. Navathe 687 solutions Other Quizlet setsch. 9 assignment12 terms TimSchroeder1 OBGYN Test 2 Pony Up Cowgalz78 terms chase_walker6 Diabetes21 terms kzprellwitz NUTR 205 exam 1135 terms haley_maye_lynch Related questionsQUESTION True or False: An important feature associated with the traditional approach to data management is the ability to produce ad hoc reports. 2 answers QUESTION Structured Query Language (SQL)is the set-based, declarative language used to access data in an Oracle database. True or False 3 answers QUESTION A SAP HANA Live model is displayed as an invalid view in the list of models in the SAP HANA Live browser. What could be the reason? 2 answers QUESTION When a salesperson's "call reports" are used to track the sales behavior of a company's customers, this is an example of a(n): 7 answers What happens when you doubleFor example, if you insert worksheet cells into the document as an Excel object, Microsoft Office Word runs Excel when you double-click the cells, and you can use Excel commands to work with the worksheet content.
What happens when you click the sheet tab of a worksheet not included in a worksheet group?The worksheets will be ungrouped. You can also click any worksheet not included in the group to ungroup all worksheets.
When an Excel chart is embedded in a Word document quizlet?When an Excel chart is embedded in a Word document, changes made to the chart in Excel will not affect the embedded object in the Word document. the slide title. bring together two or more application files.
What will happen to the link to an external reference if you move the source workbook quizlet?What will happen to the link to an external reference if you move the source workbook? The link will not work.
|