Computer Business
(powerpoint) if you want to send your presentation to people who don't have microsoft powerpoint and you also dont want people to make changes to the presentation then save your file in this format
(Powerpoint) the new default slide layout aspect ratio is ________ which reflects the growing use of widescreen displays and HD formats
16:9
(Access) The maximum field size for a Short Text field is ___ characters.
255
(Powerpoint) A feature that allows the duplication of animation effects between objects
Animation painter
(powerpoint) if you want to save your presentation so it is backward compatible with versions 97 to 2003, then save your file in this format
PPT
(Powerpoint) by default, powerpoint 2013 saves your file in what format
PPTX
(access) which of the following is a special-purpose programming language used for manipulating database information
SQL
(powerpoint) which powerpoint tool could be used to quickly depict a series of steps or levels using a pyramid shape with the ability to add your own text to the diagram
SmartArt
(Powerpoint) Animations are always applied to objects, they are not applied to the actual slide itself. True or false?
True
(Powerpoint) the animation effects are numbered on the slide so you know the order in which they take effect. True or false?
True
(powerpoint) allows you to narrate your presentation for playback at a later time. True or false
True
(powerpoint) WordArt is:
a range of visually striking, decorative styles and effects including shadows, reflections, and bevelled edges applied to text in powerpoint presentations
(access) which of the following is a true statement in regards to quires in access
a single query can consist of fields from several tables
(powerpoint) A simulation of movement added to graphics or text on a slide is called:
animation
(access) an ____ is a type of template found on the create tab of the ribbon that lets you quickly add new objects to an access database
application part
(access) if i sort my report based on last name going form a to z that is know as
ascending order
(Access) the purpose of a query is to
ask questions and display specific data from a table.
(powerpoint) WMA, MP3, MP4 and WAV are examples of compatible _______________ files that may be inserted into powerpoint presentations
audio
(powerpoint) the outer edge or line around a table is referred to as its
border
(powerpoint)allows you to insert tables into your slides. Tables are organized by columns and rows. the intersection of which called a
cell
(Access) A graphical representation of numerical data is called a:
chart
(powerpoint) graphics that are pre-fabricated and shipped with microsoft office for use in its applications and presentations
clip art
(powerpoint) which command group from the review tab allows us to merge two copies of a presentation so that we may either accept or reject changes that have been to it by another person
compare
(powerpoint) when you click on an object on your slide such as a table or picture, you will be presented with one or more new tabs on the powerpoint ribbon, these tabs are called ________ because they are specific to the type of item or object that you have selected on the slide.
contextual
(access) each object such as a label or button that is placed in the report is typically referred to as an
control
(access) objects such as labels, text boxes, list boxes, and check boxes that are added to a form are called
controls
(access) the data type of an item price, such as $10.50 is:
currency
(access) each of the following is an access data type, EXCEPT
data
(Access) The ______ of a field tells Access what kind of data may be stored in the field.
data type
(Access) when designing a table, each field must have a defined _______which identifies the kind of data that may be stored in that field.
data type
(access) in order to restrict the data that is inputted into a field. Access can use
data validation rules
(access) which of the following views Microsoft access is used for entering actual data into records?
datasheet view
(access) with a "delete" query, you can
delete information from an existing table where the data matches a specified criteria
(Access) which of the following views in Microsoft Access is used for changing the design and structure of tables ?
design view
(access) an access view that provides a grid-like environment for precision placement of controls and allows a controlled and deliberate approach to creating forms
design view
(Access) A single field in a table can have more than one data type defined. true or false
false
(Powerpoint) Because of possible copyright infringements, Powerpoint does not allow song clips or music to be added to presentations. True or false?
false
(Powerpoint) requires that all inserted pictures come from the local computer, browsing internet resources for pictures is not allowed. true or false
false
(access) clicking the report wizard button found on the create tab of the ribbon will automatically add all of the fields of the selected table to report. true or false
false
(access) reports and tables are typically used for the same purposes
false
(access) when creating a report the user is limited to choosing from a single table, if you need fields from multiple tables, then you must use a query to accomplish this. true or false
false
(powerpoint) transitions and animations mean the same thing in powerpoint true or false?
false
(powerpoint) when a transition effect is chosen, it must be applied to all slides in the presentation. true or false
false
(powerpoint0 tables in powerpoint are limited to alphanumeric content and cannot contain media content such as images or video clips. true or false
false
(Access) Each individual chunk of data that collectively make up a record in a database is called a:
field
(Access) if relationship is established between two tables they will share a common:
field
(access) suppose you want to view only the records in a table that have a value of "Fl" in the state field, what can you do to quickly to display only those records that meet that criteria?
filter the table on the state field
(access) the 348 exchange has been moved to the 704 area code. to quickly update the telephone number field of all records in a table, use this feature in access
find and replace
(Access) a field in a table that contains identifiers for records in another table , to whose primary key it is joined is known as a
foreign key
(access) Mary wants to quickly create a form containing all the fields from a selected Employee information table. What button from the forms group of the ribbon will most quickly do this?
form
(access) which access database object is often used as a user interface to the underlying data source to enter and display data quickly and easily?
form
(access) which of the following is a form-creation tool that automatically creates a form based on table fields and other options selected by the user?
form wizard button
(access) if there is important calculated data being stored in a field that you do not want displayed to the user, then you may choose to
hide the field
(access) An ____ is a combination of literal and mask characters that specifies the format that access allows users to use when inputting data into a field in a table and is useful for inputting such things as telephone numbers and social security numbers
input mask
(access) a graphical, intuitive, and dynamic way of effecting most changes to a form which presents an active preview of data and allows for accurate control sizing and optimal functionality
layout view
(Powerpoint) to reduce the size of your powerpoint presentation, you should ________ video clips
link to
(Access) when referring to external sources of data, which Microsoft access method, importing or linking, will allow changes to data from another application to automatically be reflected in the access database tied to it?
linking
(access) with an "update" query you can
make changes to the existing table
(access) you've started creating a query, but you want to add a calculated value for new shipping fees to the first available column. these shipping fees are calculated by subtracting 20 from the shipping fee. assuming the label of the calculated field is new fees, which option is correct
new fees:[shipping fee]-20
(Powerpoint) which view is most commonly used to edit your presentation slide by slide
normal
(access) which type of query allows us to reuse the same query for multiple criteria for which the user will type in when they are prompted upon running the query?
parameter query
(powerpoint) a powerpoint compilation, editing, and organizing feature that allows the user to compile groups of pictures for use in presentations or on the web
photo album
(powerpoint) powerpoint is used to create
presentations
(Access) If you want to sort a table by the price field with the highest prices coming first, you should sort on the:
price field in descending order
(Access) The field that uniquely identifies each record in a table is called a:
primary key
(Access) since each social security number is unique per person, in the past many companies and organizations used it as a _________ field to uniquely identify their patients, employees, and so on
primary key
(access) to view what the report will look like when printed on your paper and access different print options, use the
print preview
(access) which access object can be used to update data and is designed to answer questions by retrieving filtering, assembling, and sorting data from a database
query
(Access) Which access feature provides a step-by-step guided process for creating simple queries?
query wizard
(access) which item in the access program window allows the user to most quickly save a report
quick access toolbar
(powerpoint) the very top left portion of the window contains icons representing commonly used commands such as save, undo, or start with the presentation beginning is know as the
quick access toolbar
(Access) each row in an Access table contains a(n) ____________ which consists of multiple fields of information
record
(access) each row in a table contains an
record
(Access) RDBMS is an acronym for:
relational database management system
(Access) a database object that summarizes the fields and records from a table in an attractive, easy-to-read format is an
report
(access) a _____ can be used to ass a custom error message for users when they enter an invalid entry for a data field
report
(access) a document within access that displays and summarizes data from one or more queries or tables for easy interpretation, printing, and sharing with others is known as a
report
(access) which button from the reports group would you use if you want a guided approach to creating a report with only the fields that you indicate in the report?
report wizard button
(powerpoint) which powerpoint ribbon tab gives you access to the comments and compare command groups which are helpful when collaborating with a group on a presentation
review
(access) in order to use the form button found in the forms group of the create ribbon tab, you must first
select a table or query to base it on
(Access) With a "Select" query, you can:
select and display records from the database
(access) with a "make table" query, you can
select records form the database and save them as a new table
(access) the data type for a telephone number field is
short text
(access) this data type is used to store up to 255 alphanumeric characters, spaces, and symbols
short text
(Powerpoint) each "page" of a powerpoint is referred to as a
slide
(powerpoint) which ribbon tab may be used to rehearse and adjust the settings for your presentation delivery?
slide show
(powerpoint) which view gives you an idea of how your presentation will look when you deliver it
slide show
(Powerpoint) which view makes it easy to see all the slides at once and to rearrange the order of all the slides in your presentation
slide sorter
(access) to quickly rearrange a table's records, you can do this to the table data
sort
(access) by indexing a field, access can
speed up searching and sorting records in the table
(access) when entering data into a form, instead of using the mouse to go from one text box to another, this key on the keyboard can be used to jump to the next text box in the preset order
tab key
(Access) information in a database is typically stored in this, which consists of vertical columns and horizontal rows
table
(powerpoint) automatically adds placeholders called ______ on your slides that enable you to insert text, pictures, tables, charts, or even videos anywhere in your presentation
text boxes
(Powerpoint) a slide design that contains matching complementary colors, major and minor fonts, as well as specific effects like shadows or reflections is referred to as a
theme
(access) one of the quick and easy ways to format the whole report at once is by utilizing a ______ which gives us some nice combinations of color and font altogether
theme
(powerpoint) to find a synonym for a word, use the following tool from the review tab
thesaurus
(access) you've created a query and you'd like to determine the total for each item in order for any duplicate values to be removed from the query results. Identify the command you use to do this
total
(powerpoint) a special effect that marks how one slide moves off and the next slide moves onto the screen is called an
transition
(Access) formatting the appearance of the table will not change the data, just the way you're looking at it? true or false
true
(access) editing a query by adding a new column or changing the order of the columns is done easily through design view true or false
true
(access) in order to create a report, you must first select an access object such as a table or query true or false
true
(access) when data is changed using a form, the corresponding data in the table it is based on is automatically updated. True or false
true
(powerpoint) after a picture has been inserted into a slide, powerpoint allows the user to format picture by changing its brightness, cropping it, or changing its contrast. True or false
true
(powerpoint) the ability to translate your presentation into several different languages is built into the powerpoint program. you do have to download any add-ons to the program to enable this feature. true or false
true
(powerpoint) transitions may also include clips, so that when a slide transition occurs, a sound clip will play. true or false?
true
(powerpoint) when an excel spreadsheet has been inserted into a slide from within powerpoint, you will access to some of the excel functions true or false
true
(access) suppose you want to use a field entitled "state" to list only those employees living in florida, but you do not want the column displayed in the results after you run the query. what can you do in the query design to achieve this
uncheck the "show" checkbox to hide the state column from displaying in the results
(powerpoint) identifies a possible misspelled word by:
underlining it with a red wavy line
(Access) the main purpose of a form is to:
view and enter data into tables
(powerpoint) suppose that you would like to include data in your presentation that comes from an existing Excel spreadsheet. you also want ability to change data in the powerpoint presentation table and have it also make the corresponding change in the excel spreadsheet file. how can you do this?
Choose "insert object" in powerpoint and "link" the spreadsheet to the slide
