0
Access is a ____.
Student ResponseCorrect Answer1.file management system2.workbook management system3.word processing software tool4.database management system
2.In Access, a(n) ____ consists of a collection of tables, each of which contains information on a specific subject.
Student ResponseCorrect Answer1.database2.tuple3.object4.relation
3.____ words are words that have a special meaning to Access and cannot be used for the names of fields or tables.
Student ResponseCorrect Answer1.Significant2.Special3.Reserved4.Restricted
4.In Access, table and field names can be up to ____ characters in length.
Student ResponseCorrect Answer1.642.323.2554.128
5.A field whose data type is ____ can contain any characters.
Student ResponseCorrect Answer1.Alpha2.Normal3.Lookup4.Text
6.A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.
Student ResponseCorrect Answer1.Unlimited2.Memo3.Variable4.Character
7.A saved database is referred to as a ____.
Student ResponseCorrect Answer1.DBMS2.databook3.file4.template
8.In addition to the top-level tabs, Access displays other tabs called ____ tabs that display when you perform certain tasks or work with certain objects such as datasheets.
Student ResponseCorrect Answer1.tiered2.sublevel3.contextual4.subtype
9.One way to create a table, is to click ____ on the Ribbon and then click the Table button.
Student ResponseCorrect Answer1.Add2.Create3.New4.Insert Table
10.You only can delete a primary key in ____ view.
Student ResponseCorrect Answer1.Print Preview2.Design3.Datasheet4.Layout
11.To undo the most recent change to a table structure, click the ____ button on the Quick Access Toolbar.
Student ResponseCorrect Answer1.Undo2.Cancel3.Back4.Escape
12.To change the name of a field, right-click the column heading for the field, click ____ on the shortcut menu, and then type the desired field name.
Student ResponseCorrect Answer1.Rename Field2.Change Field3.Rename Column4.Change Column
13.To insert a field between existing fields, right-click the column heading for the field that will follow the new field, and then click ____ on the shortcut menu.
Student ResponseCorrect Answer1.Add Field2.Insert Column3.Add column4.Insert Field
14.In the accompanying figure, the small box or bar to left of each field is called the ____.
Student ResponseCorrect Answer1.field bar2.field selector3.current field bar4.row selector
15.Figure 1-2
In the accompanying figure, the key symbol that appears in the row selector for the Client Number field indicates that Client Number is the ____ for the table.
Student ResponseCorrect Answer1.primary key2.foreign key3.principal key4.main key
16.Figure 1-2
In the accompanying figure, you would save the changes to the structure of the table by clicking the Save button on the ____.
Student ResponseCorrect Answer1.Home tab2.status bar3.Quick Access Toolbar4.title bar
17.To open a table in Design view, right-click the table in the Navigation Pane and then click ____ on the shortcut menu
Student ResponseCorrect Answer1.Table Design2.Design View3.Structure View4.Layout View
18.To add a record to a table, click the ____ record button.
Student ResponseCorrect Answer1.Insert2.New (blank)3.Add New4.Last
19.To quit Access, click the ____ button on the right side of the Access title bar.
Student ResponseCorrect Answer1.End2.Close3.Quit Access4.Quit
20.To hide the Navigation Pane, click the ____ Button.
Student ResponseCorrect Answer1.Navigation Bar Show/Hide2.Hide Navigation Pane3.Shutter Bar Open/Close4.Close Pane
21.To preview and then print a table, select the table, click the Office Button, point to the Print command arrow to display the Print submenu, and then click ____ on the Print submenu.
Student ResponseCorrect Answer1.Report View2.Print Preview3.Preview/Print4.Preview View
22.To change the print orientation from portrait to landscape, click the ____ button on the Print Preview tab.
Student ResponseCorrect Answer1.Orientation2.Landscape3.Switch Orientation4.Portrait/Landscape
23.If a field has a Number data type, you can change the ____ property to Fixed to set a fixed number of decimal places.
Student ResponseCorrect Answer1.Field Size2.Format3.Caption4.Decimal
24.To create a report using the Report Wizard, click ____ on the Ribbon and then click the Report Wizard button.
Student ResponseCorrect Answer1.Create2.Report3.New Object4.Insert
25.A(n) ___ combines both a datasheet and a form.
Student ResponseCorrect Answer1.AutoForm2.split form3.simple form4.DataForm
26.To back up a database, use the ____ command on the Office Button menu.
Student ResponseCorrect Answer1.Backup2.Options3.Manage4.Data Tools
27.If a Security Warning appears when you open a database, click the ____ button to display the Microsoft Office Security Options dialog box.
Student ResponseCorrect Answer1.Warning2.Customize3.Security4.Options
28.To view the results of a query, open it by right-clicking the query in the Navigation Pane and clicking ____ on the shortcut menu.
Student ResponseCorrect Answer1.Open2.Run3.Design View4.Datasheet View
29.To print a query without first opening it, select the query in the Navigation Pane and then click the Office Button, point to Print on the Office Button menu, and then click ____ on the Print submenu
Student ResponseCorrect Answer1.Quick Print2.Preview Query3.Run and Print4.Print Query
30.You can click either the View button or the ____ button on the Ribbon to execute a query.
Student ResponseCorrect Answer1.Select2.Results3.Run4.Execute
31.To create a new query in Design view, click Create on the Ribbon to display the Create tab and then click the ____ button to create a new query.
Student ResponseCorrect Answer1.Select Query2.Query Design3.Design View4.Query
32.Figure 2-1
In the accompanying figure, the lower pane in the window where you enter criteria is called the ____.
Student ResponseCorrect Answer1.query grid2.show grid3.criteria grid4.design grid
33.Figure 2-1
In the accompanying figure, you can enter FD89 in the ____ row of the Client Number field to find all clients whose client number is FD89.
Student ResponseCorrect Answer1.or2.Sort3.Show4.Criteria
34.Figure 2-1
In the accompanying figure, you can find all clients whose names begin with Be, by entering _____ in the Criteria row of the Client Name field.
Student ResponseCorrect Answer1.Be?2.Be&3.Be..4.Be*
35.To find all individuals whose name is Tom or Tim, enter ____ in the Criteria row of the appropriate column.
Student ResponseCorrect Answer1.T$m2.T?m3.T#m4.T&m
36.To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in _____.
Student ResponseCorrect Answer1.square brackets [ ]2.parentheses ( )3.single quotes ''4.curly braces { }
37.To save a query, click the Save button on the ____.
Student ResponseCorrect Answer1.Create tab on the Ribbon2.status bar3.Home tab on the Ribbon4.Quick Access Toolbar
38.Figure 2-2
In the accompanying figure, the criterion for Current Due is 0. To find all clients whose current due amount is greater than $10,000.00, erase the 0 and enter _____ in the Criteria row of the Current Due column.
Student ResponseCorrect Answer1.> 10,0002.> 100003.> $100004.> $10,000
39.Figure 2-2
In the accompanying figure, the criterion for Current Due is 0. To find all clients whose current due amount is $20,000.00, erase the 0 in the Current Due column and enter _____ in the Criteria row of the Amount Paid column.
Student ResponseCorrect Answer1.=$20,0002.20,0003.=20,0004.20000
40.To sort records in a query, specify the sort order in the _____ row of the design grid below the field that is the sort key.
Student ResponseCorrect Answer1.Show2.Order3.Criteria4.Sort
41.To omit duplicates from a query, use the property sheet and change the Unique Values property to _____.
Student ResponseCorrect Answer1.Off2.No3.Yes4.On
42.Use a query to _____ tables; that is, to find records in two tables that have identical values in matching fields.
Student ResponseCorrect Answer1.join2.concatenate3.merge4.combine
43.To include calculated fields in queries, enter a name for the calculated field, a(n) _____, and then the expression in one of the columns in the Field row.
Student ResponseCorrect Answer1.semi-colon (:)2.exclamation point (!)3.equal sign (=)4.colon (:)
44.To display the entire entry for a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.
Student ResponseCorrect Answer1.Resize2.Enlarge3.Magnify4.Zoom
45.To change the caption for a field in a query, click the field in the design grid, click the _____ button on the Design tab, click the Caption box, and enter the new caption.
Student ResponseCorrect Answer1.Format2.Caption3.Property Sheet4.Query
46.To include the Total row in the design grid, click the _____ button on the Design tab.
Student ResponseCorrect Answer1.Aggregate2.Totals3.Statistics4.Calculations
47.To find the average amount paid amount for a client, select _____ as the entry in the Total row for the Amount Paid column.
Student ResponseCorrect Answer1.Median2.AVG3.Average4.VAR
48.To indicate grouping in Access, select _____ as the entry in the Total row for the field to be used for grouping.
Student ResponseCorrect Answer1.Group By2.Same3.Where4.Like
49.To show the Navigation Pane if it is hidden, click the ____ Button.
Student ResponseCorrect Answer1.Show2.Shutter Bar Open/Close3.Show/Hide4.Restore
50.To quit Access, click the ____ button on the right side of the Access title bar.
Student ResponseCorrect Answer1.Exit2.Close3.Quit4.Stop
Add your answer:
Earn +20 pts
What type of memory is mostly closely connected to the CPU?
In this instance, you likely mean cache memory, though you could mean RAM, particularly DRAM. Cache memory, like the L1, L2, and L3 processor cache, helps to speed up operations between the CPU and RAM.
What is any part of the computer system that can be used by a computer program called?
Well the question is a bit vague, but I will attempt an answer. If you mean the part of the computer that does the "thinking" for a program, it's the processor. But all of the basic parts of the computer will be used in the process of running most programs. The processor does the "thinking," as I said before, the RAM (memory) gives the processor space to "think," the video card runs the monitor or screen so you can see what is going on, and the hard drive stores everything that isn't being used, like your other programs, all your documents, pictures, etc. Of course, there are many other components to a computer, but these are the basic ones that are pretty much required for almost all computers.
What is a computer chips that store information while a PC is in use?
a hard drive stores the computers information, while the RAM (random access memory) can store temporary things like your history etc that get deleted when you turn off your computer
What is a processor card and what does it do?
At the heart of every computer is one or more processors. While some hand held devices like mobile phones have the processor fixed to the main circuit board there are computers that allow you to change the number and speed of the processors in the computer. This versatility is done by fixing the processor to a business card sized card. This card is called a processor card
Elements of computing process?
Basic Computer Elements: In generally used computers one can find that there are four basic computer elements following are the elements.(1) ALU (Arithmetic Logic Unit): The ALU is the digital circuit that is able to perform different types of functions, such as Addition, Subtraction, and Multiplication etc.(2) Control Unit: The control unit is the part of CPU (central processing unit) or other devices that performs the duty to direct its operations, the control unit is just like a finite state machine that has some finite states and the transaction from one state to the other state is called action.(3) Memory: The memory is another very important element of the computer without memory the computer can't operate in today's modern age it is called the RAM (Random Access Memory) when ever we give some instruction to the computer it passes through RAM to the Processor and the processor processes it and send it back. The main reason behind memory is that it is faster in communication with the processor then the other memory devices such as hard disk etc.(4) Input/output devices: The input and output devices is another important element for example the processor is the input device and it gives its output to the monitor etc for output.There is another very important point the basic elements are considered as CPU (central Processing Unit), I/O devices, and Memory actually the CPU is the composition of different other elements such as ALU, Control Unit, Registers which is another type of memory.
Which is more desirable i3 processor and 6GB memory or i5 processor and 4GB memory?
Memory is more important than the type of processor. Unless you are about to run programs like photoshop or premier pro or in Apple's case, Final Cut Pro, then you probably want the Core i5. A memory upgrade is easy and it is cheap. Do it yourself instead of letting the factory install it for you. It will save you a good amount of money. But for most people, Core i3 with 6 GB of memory is better. For more answers like this, go to jamesrealtech.com
What are the four main parts of a computer four stage model?
Input device (like a keyboard), output device (like a monitor), memory (like a hard drive), and processor (Intel is a designer of these).
What is the recommended size of cache memory in a processor?
The maximum size of a cache memory is theoretically equal to the amount of primary memory(RAM).Like Cache only memory architecture where the whole memory space is filled up with the cache only.
What is the purrpose of a control unit in a processor?
Control unit generates all the control signals like memory read signal,i/o read signal,memory write signal etc
Ram stands for what kind of memory?
RAM stands for Random Access Memory. This memory is not like a Flash Drive or Hard Drive, as it is volatile; this means it only temporarily stores data, while it is powered. It is used so that while a computer is running, data which the processor requires rapid access to (e.g. a running program) can be stored and accessed much faster.
How is RAM different from hard disk?
RAM is like a computers short term memory, it stores temporary things like web pages you view or programs that are running. A Hard Disk is like long term memory, it stores photos and the programs you actually install.
The processor memory and storage devices are housed in a box like case called?
System Unit. http://books.google.com/books?id=OKI7Ya32sZ8C&pg=PT27&lpg=PT27&dq=the+processor+memory+and+storage+devices+are+housed+in+a+box-like+case+called+the&source=bl&ots=HiP6XHNugU&sig=OnzwG6UFeo55zq2Mzv1nji42B9o&hl=en&ei=DXOgSoTLKoiz8Qap8PD0Dw&sa=X&oi=book_result&ct=result&resnum=5#v=onepage&q=the%20processor%20memory%20and%20storage%20devices%20are%20housed%20in%20a%20box-like%20case%20called%20the&f=false
What factors determine CPU perfomance?
It actually depends up on many factors like which processor u r using , size of RAM(Random Access Memory) , and many more factor but they are depends on the processor like registers in it, size of bus and ALU and so on....
Four parts of a complete computer system?
Motherboard, processor, memory, storage media (Optical disc, Hard disk, or Solid state drive)
Where to get microSD memory for R4i?
you can buy it from stores like target,best buy,and walmart Good Luck!
How does a computer store pictures in computer memory?
As coded numbers, just like it stores anything else.
Where can one purchase a Sony memory stick pro?
A Sony memory stick pro can be purchased from a number of retailers. Such retailers include office supply stores like Staples or technology and electronics stores like Best Buy. They can also be purchased online from Amazon or directly from Sony.
