Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
CA Cards
computer apops flash cards
| Question | Answer |
|---|---|
| What are Colums | They are vertical and are identified by letters at the top of the worksheet window |
| Title Silde | introduces your presentation to your audience |
| transition | refers to the way each silde appers on the screen |
| animation | an effect you can apply to text, objects, graphics, or pictures to make those objects move during a slide show. |
| How many sildes per page can be printed using the "handouts" option? | 2-9 sildes per page |
| What is the PowerPoint file extension | .pptx |
| placeholders | are boxeswith dotted borders that contain content and reside with a slide layout. All built-in silde layouts contain content placeholders |
| Slide Master View | a feature that gives your presentation a consistent, professional look. A slide master view is helpful if you want every slide in your show to be the same color, to have the same header or footer, or to carry a particular logo. |
| how dop you insert a table into a PP slide using the Content slide layout | Click the Insert Table icon. |
| Access | A database management system |
| Database | A collection of objects |
| Datasheet | the table displays its dats in rows and colums |
| How do you move from one field to the next in datssheet view | Tab |
| How do you move from one field to the previous field in Datasheet view | Shift+Tab |
| Best Fit | Automatically resizes the colum to the best width for the data contained in the colum |
| How are field rearranged in Datasheet View | by clicking and draggring them to a new location |
| What is the purpose of Print Preview | To check the print settings prior to painting |
| Field selector | A small bar or box that you press to select an entire colum in dadtsheet |
| show an example of a field name | address |
| show an example of a "field value" for the field identified above | 1255 Dogwood Road |
| define "primary key" and give an example | a unique identifier for each record in a table Example: Student Number |
| design grid | the top half of the table window |
| Field Properties Pane | the bottom half of the Table window |
| how do you "run" a query | by opening a query object |
| Simple Query Wizard | an easy way to create a query. It asks you what data you want to see by letting you select options in dialog boxes. |
| on to many relationships | one record in the first table can match many records ine the second table |
| primary table | the "one" side of two related tables in a one-to-many relationships. |
| related table | the table containing "many" rwecords. |
| referential integrity | a set of rules to ensure that there are matching values in the common field used to form the relationship. |
| Rows | appear horizontally and are identified by numbers on the left side of the worksheet window. |
| range reference-example | (A1:F1) |
| ###### | numbers extend beyond a cell's width |
| 3 ways to enter data in the cells | enter, tabe, enter button in formula bar |
| Wildcard(find/replace) | *(asterisk) |
| default magnification | 100% |
| print tab | enables you to select the number of copies to print, a printer, the part of the worksheet to print, and the way the printed worksheet will look |
| what happends if you try to close a worksheet that has not been saved? | you are prompted to save the file |
| Autofit | Determines the best width for a column or the best height for a row, based on its contents |
| Explain how to resize the width of several columns at once | select the columns you want to resize, then use the pointer to click and drag the right edge of one of the selected column headings |
| how are numbers displayed in a cell | right angled |
| merge & center | centers cell contents across several columns |
| theme | preset collection of design elements, including fonts, colors, and other effects |
| CTRL + U | Underline |
| CRTL + B | Italics |
| wrapped text | with wrapped text, the row height will automatically adjust to show all of the lines of text. text wraps within a cell like in word processing document, rather then spilling over into the next cell |
| CRTL + C | copy |
| CRTL + V | paste |
| how do you insert a row in an Excel spreadsheet? | click the row number to select the row where you want the new row to appear, then click the insert button |
| landscape orientation | wider than they are long |
| portrait orientation | longer than they are wider |
| header | text that prints in the top margin of each page |
| footer | text that prints in the bottom of each page |
| identify three ways to enter a formula into a cell | enter, tab, enter button on the formula bar |
| show an example of multiplication | A1 * 7 |
| show an example of division | A1/2 |
| show an example of exponentiation | A1^3 |
| order of evaluation | the sequence used to caculate the vaule of a formula |
| what is the order of operations when executing an Excel formula? | inner most parentheses are evaluated first, moving outward |
| contral + (grave accent) | used to switch between showing formulas and showing formula results in a worksheet |
| show an example of the SUM function | Sum(F1:F10) |
| database managment system | allows you to store, retrieve, analyze, and print information |
| nagavation plane | lists the objects in the database |
| record | complete set of the data |
| field | each record is made up of one or more fields |
| field names | identifies each field |
| field value | data entered in a field |
| datasheet view | the original view in a database |
| field selector | apperears at the top of each column and displays the field name |
| record selector | appears on the left of the first field for each record |
| datasheet selector | you can select all the record and fields |
| compacting | database rearranges how the database is storedon the idsk and optimizes the proformance of the database |
| templete | creat a database |
| blank database templete | creats a database with a empty table in it |
| autonumber | automatically adds a unique number to the primary key field for each record |
| primary key | field that contains a unique field value for each record |
| data type | determines the kind of data you can enter in the field |
| alphanurmeic data | a combination of numbers and text |
| design view | you can add, delete, and change the way that fields store data |
| description property | field property that you can use to describe what you enter in the field |
| field property | describes a field contents beyond the fields basic data type |
| field size property | sets the number of charaters you can store in a text, number, or autonumber field |
| default property vaule | eneters the same field value in a field every time a new recored is added to the table |
| required property | specifies whether you must enter a field value in the record |
| condition | a way of telling the query which type of dats you want to see |
| sort | when you view field values in assending or dessending order |
| filter | displays record in a datasheet base |
| filter by selection | you can use different types of filters to display the data you need. |
| filter by form | need to display records that contain more then one values based on the vaules stored in one or maore fields |
| autofilter | menu that opens when you click the arror on the right side of the field selector |
| relationship | data base managment system lets you connect the data in the table |
| common field | a field that appears in both tables |
| foreign key | the common field in the related table |
| referential integrity | protects the data in the tables |
| subdatasheet | contains the related tables in the Order table |
| multiple queries | queries that are based on more than one table |
| and operator | selectes the records that matches all of the two or more conditions in a query |
| or operator | selectes the recoreds that matches at least one of the two conditions in a query |
| total row | the number of vaules in a column |
| caculated field | the vaule that is caculated when using other fields |
| expression | the name of the caculation |
| form | database object that displays data from one or more queries in a format that has a similar appearance to paper |
| record source | the tables or queries that provide the data to be displayed in a form |
| form tool | creats a simple form that inclued all of the fields in a selected table or query |
| controls | when fields appear in a form |
| layout view | you can view the controls in the form |
| split form view | creats a form using all the fields in the selected table or query and splits the window into two panes |
| multiple item tool | creats a form that list all the fields in a datasheet format |
| datasheet tool | creats a form that looks just like a datasheet |
| form wizard | helps you create a form by letting you select options in the dialog boxes |
| form view | when you create a form using form wizard the form opens in form view |
| find | a option for finding data in the database quickly |
| contorl layout | groups together the controls in a form so that you can change the theme as a group |
| detail selection | contains one sections when you create a form in layout view |
| form header selection | displays information at the top of each form |
| form footer selection | displays information at the bottom of each form |
| bound control | connecting a field in the record source and is used to display, enter, and update data |
| unbound control | not connected to a record source and is used to disply information, lines, rectangles, and pictures |
Created by:
Caitlynthomas
Popular Business sets