Using the Form Wizard Using Design View Using Multiple Items Using Split Form
A query prompts a user for a date and then displays only records that contain the specified date. Which type of query is this?A parameter query+ A(n) _________ query in Access displays a dialog box and accepts input from the user before proceeding Parameter+ AntivirusscannerdoesthefollowingDetects and deletes the viruses of all types in the indicated folders, boot sectors and RAM+ Assume you have two tables: one is containing the names of athletes in a sports league and another is containing the names of the teams in a sports league. Which type of relationship should you create to link the tables in Access? One-to-many+ Computervirusesare the programs able to create their own copies, put them into different objects/resources of the computer systems and networks without the prior consent of the user+ Every field in an Access table has which of the following?A field name and a data type+ How are all the tracks of the same number from all the metal disks that make up the hard diskcalled?cylinder+ How is a circular ring on one side of the diskcalled?track+ How is a relationship between tables indicated in a query window in Access?Related fields are connected by a line How is a set of track sectorscalled?cluster+ How is a wedge-shape piece of the diskcalled?disk sector+ How is an area of intersection of a track and a sectorcalled?track sector+ How many files can one cluster belong to?1+ How would you delete a relationship between tables in Access in the Relationships window?Click the join line, then press the Delete key+ If you double click on the table in Database Window it will be opened in:Datasheet View In Access a table is divided in rows and columns, which are called _____________, respectivelyrecords and fields+ In Access table, what includes related information about one object, person, event or transaction?Record+ In Access, a Form generally displays _______________one record at a time+ In Access, all fields for one customer or employee are considered to be B.a record+ In Access, Reports are primarily used to ____________print data present data summarize data In Access, what is the best relationship between Customers and Orders tables? One-to-many In Access, which data type creates a field that enters a value that is incremented automatically with each new record added to a table?AutoNumber In Access, which of the following encloses a parameter in criteria? [ ] In Access, which of the following will display records that contain a date before January 1, 1995?<1/1/95+ In Access, you want to create a field that lets you add a customer's name by picking it from a drop-down list. Which of the following fields would let you do this?A lookup field+ In database Forms are used:to enter or edit the information in your tables and let you view one record at a time In database Macros are used:to automate tasks that you perform on a regular basis in a database In database Modules are used:to automate a group of related procedures in Access In database Pages are used:to create Web-pages from a database In database Queries are used:to filter data so that you retrieve selected records or fields from the database In database Reports are used:to deliver a professional presentation or written report of the information stored in database In database Tables are used:to store database information+ In defining relationships in your database, if the primary table’s primary key is an AutoNumber data type, the related foreign key must be which data type?Number+ In MS Access the column headings in the table are defined by:Field name;+ In MS Access what is used to store the unique natural numbers with automatic counter:AutoNumber;+ In WinRAR, in order to compress the files you need toSelect one or several file and click the button "Add"+ In WinRAR, in order to decompress the files you need toSelect file and click the button "Extract"+ Linking more than one table together is a feature of a __________ databaseRelational Look at the following Access diagram. What kind of relationship exists between Movies and Characters? Each movie must have one or more characters. Look at the following Access diagram. What kind of relationship exists between Actors and Characters?One-to-many+ Look at the following Access diagram. What kind of relationship exists between Actors and Movies?Many-to-many Look at the following diagram. What is the most probable data type for Customer Id field in Customers table?AutoNumber Look at the following diagram. What is the most probable data type for Customer Id field in Orders table?Number Look at the following diagram. What is the most probable data type for Book Id field in Book Inventory table?AutoNumber Look at the following diagram. What is the most probable data type for Book Id field in Orders table?Number Look at the following diagram. What is the most probable data type for Price field in Book Inventory table?Currency Look at the following diagram. What is the most probable data type for State field in Customers table?Text Look at the following diagram. What kind of relationship exists between Customers and Orders?One-to-many Look at the following diagram. What kind of relationship exists between Orders and Book Inventory?One-to-many+ Look at the following diagram. What kind of relationship exists between Customers and Book Inventory?Many-to-many Look at the following diagram. What kind of relationship exists between the tables?Many-to-many Look at the following diagram. Which field is a primary key field in the tables?Cust ID+ Maintaining a database table can include B. adding records+ MS Access 2010. What is the name of the area on the left side of the window in which the database objects are displayed?Navigation area+ MS Access. What is the command called?query design+ MS Access.What is the command called?macros+ MS Access.What is the command called?advanced filter+ MS Access.What is the command called?Form+ MS Access.What is the command called?run MS Access.What is the command called?Totals+ Query can look up the information in:one or several tables and queries+ ScanDiskallowstocheck the hard drive for logical and physical defects+ The _______ defines the kind of information that you enter into a database fieldData type+ The ____________ is a unique identifier for each record in Access table Primary key The archive created in WinRAR can have an extensionRar+ The archive created in WinRAR can have an extensionRar+ zip+ sfx+ The archive created in WinRAR can have an extensionzip+ The easiest way to create a query in MS Access is:using Query Wizard The process of finding and putting in order the disrupted parts of files is calledDefragmentation+
|
|
|
|
|
|
Using the Form Wizard Using Design View Using Multiple Items Using Split Form
|
|
|
What are common table structure changes in Access?Deleting field specifications Adding field specificationsChanging field specifications
What are the columns in a Microsoft Access table called?Fields+
What are the rows in a Microsoft Access table called?Records+
What can be displayed in MS Access form?The data from several tablesThe data either from one
What data type for fields does not exist in Microsoft Access:Percentage+;
What data type of fields exists in Microsoft Access?Text+Number+Memo+Currency+
What data type should you choose for a telephone-number field in a table?-----B.Number+
What does a single line with “1” on both of the ends represent in the relationship diagram in Access?One-to-one relationship+
What does a single line with “1” on one end and “¥” on the other represent in the relationship diagram in Access?One-to-many relationship+
What extension do files of Microsoft Access have?mdb;
What happens when you add the asterisk (*) from any Field List to a query?The query will include every field from the table+
What happens when you have entered the last field for a record and press the Enter key in Access? The record is savedThe record selector moves to the next record
What harm can NOT the virus make a computer?Damage disks physically. ++Infect write-protected disks.+Damage hardware+
What harm can the virus make a computer?Infect program files+Infect the information stored on disks+ Corrupt files and data+Wipe system BIOS settings+
What is 7-zip used for? to compress and decompress the files+
What is a macro virus?program written to infect files you create with applications that support macros+
What is a trojan horse?program that appear to be useful software, but instead compromising the security of a computer+
What is a virus hoax?e-mail message about non-existent viruses+
What is Anti-virus Scanner used for?to scan the computer for viruses+
What is Defrag used for?to optimize the disk space+
What is Scandisk used for?to check the disk for physical and logical defects+
|
|
|
What is the advantage of RAR format over ZIP for the archive? significantly better compression+practically unlimited archive size+
What is the advantage of ZIP format over RAR for the archive?its popularity+higher speed of compression/decompression+
What is the easiest way to create a form in Microsoft Access database:Form wizard;+
What is the function of the 
button in 7-zip?copy files to another place+
What is the function of the 
button in 7-zip?delete files+
What is the function of the 
button in 7-zip?get the information about an archive +
What is the function of the 
button in 7-zip?move files to another place+
What is the function of the 
button in 7-zip?test archived files for integrity+
What is the function of the 
button in 7-zip?add files to an archive +
What is the function of the 
button in 7-zip?extract files from an archive +
What is the Memo data type field in Access table used for?For long text entries of one or more sentences+
What is the purpose of Microsoft Access?Creation of databases;+
What is WinRAR used for?to compress and decompress the files+
What queries are used to calculate a sum, average, count, or other type of total for data that is grouped by two types of information - one down the left side of the datasheet and another across the top?Crosstab queries
What queries are used to display their own dialog box prompting you for information, such as criteria for retrieving records?Parameter queries+
What queries are used to make changes in the database, allowing to update, delete, append and make the tables?Action queries
What queries are used to perform all possible database operations using special Structured Query Language?SQL queries+
What queries are used to retrieve data from one or more tables and displays the results in a datasheet?Select queries+
What relationship in Access means one record from a table is related to one record in another table One-to-one
What relationship in Access means that each record in the first table can be related to more than one record in the second table?One-to-many+
What types of relation exist?one to one+ one to many+ many to many+
Whatis a worm?program which can send out copies of itself to everyone listed in your e-mail address book+
Which archive can be unpacked without using any other programs?sfx+
Which database data type corresponds to a unique sequential number or random number assigned by database management system?AutoNumber+
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?OLE Object+
Which database data type corresponds to combinations of text and numbers, as well as numbers that don't require calculations, such as phone numbers? C.Text+
Which database data type corresponds to data that contain only one of two values?Yes/No
Which database data type corresponds to date and time values?Date/Time+
Which database data type corresponds to large portion of text or combinations of text and numbers?Memo+
Which database data type corresponds to numeric data used in mathematical calculations?Number+
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?Hyperlink+
Which database data type corresponds to values containing the information dealing with money?Currency
Which of the following are a part of the table design window in Access: field namedescriptiondata type
Which of the following are methods for creating a table in a database?Create a table in Design View Create a table by entering data
Which of the following are objects in an Access database?Tables, forms, queries, reports, macros, and modules+
Which of the following are ways that you can create a form?
Which of the following are ways that you can create a query?Using the Query WizardUsing Design View+
Which of the following database objects asks a question of information in a database and then displays the results?Queries+
Which of the following helps prevent orphan records in a one-to-many relationship in Access?Enforce referential integrity+
Which of the following is a database object?Queries Form
Which of the following is a good example of a primary key in Access?Social Security NumberStudent ID numberAutomobile part numbersTicket number
Which of the following is NOT a data type in Access table?Picture/Graphic++
Which of the following is NOT a type of Microsoft Access database object?Workbooks+
Which of the following is true about primary keys in Access?They are automatically included in an index of primary keysThey are used to create relationships between tablesThey are used to uniquely identify each record in a table
Which program is used to check the disk for physical and logical defects?Scandisk+
Which program is used to compress and decompress the files?7-zip+WinRAR+
Which program is used to optimize the disk space?Defrag+
Which program is used to scan the computer for viruses?Anti-virus Scanner+
Which view do you use to modify an existing form in Access?Design View
Дата добавления: 2018-06-01; просмотров: 265; Мы поможем в написании вашей работы! |
Мы поможем в написании ваших работ!