In Access, what is the best relationship between Customers and Orders tables?Ī(n) _ query in Access displays a dialog box and accepts input from the user before proceeding If you double click on the table in Database Window it will be opened in: to automate a group of related procedures in Access
#HOW TO MODIFY FORM FIELDS IN WORD 2007 PROFESSIONAL#
to deliver a professional presentation or written report of the information stored in database to enter or edit the information in your tables and let you view one record at a time to filter data so that you retrieve selected records or fields from the database to automate tasks that you perform on a regular basis in a database What is the easiest way to create a form in Microsoft Access database: A field name, a field number, and a data type The _ defines the kind of information that you enter into a database fieldĮvery field in an Access table has which of the following? In Access, all fields for one customer or employee are considered to be Which view do you use to modify an existing form in Access? In Access table, what includes related information about one object, person, event or transaction? In Access a table is divided in rows and columns, which are called _, respectively What data type should you choose for a telephone-number field in a table? To store objects created in other programs such as a graphic or Microsoft Word document For long text entries of one or more sentences To add an electronic reminder to any record For short text entries of no more than 255 characters What is the Memo data type field in Access table used for? Which of the following is NOT a data type in Access table? Which of the following is NOT a type of Microsoft Access database object? Which of the following database objects asks a question of information in a database and then displays the results? In MS Access the column headings in the table are defined by: In MS Access what is used to store the unique natural numbers with automatic counter: What data type for fields does not exist in Microsoft Access: What extension do files of Microsoft Access have? In Access, which data type creates a field that enters a value that is incremented automatically with each new record added to a table? Tables, forms, queries, reports, macros, and modules
Which of the following are objects in an Access database?
What are the rows in a Microsoft Access table called? What are the columns in a Microsoft Access table called? Which database data type corresponds to text or combinations of text and numbers stored as text and used as an address to access the Web page on the Internet? Which database data type corresponds to an object (such as a Microsoft Excel spreadsheet, a Microsoft Word document, graphics, sounds, or other binary data) linked to or embedded in a table? Which database data type corresponds to data that contain only one of two values? Which database data type corresponds to a unique sequential number or random number assigned by database management system? Which database data type corresponds to values containing the information dealing with money? Which database data type corresponds to date and time values? Which database data type corresponds to numeric data used in mathematical calculations?
Which database data type corresponds to large portion of text or combinations of text and numbers? Which database data type corresponds to combinations of text and numbers, as well as numbers that don't require calculations, such as phone numbers?