• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 2 out of 13 pages
Exam (elaborations)

Microsoft Access Exam Review Solved 100%

Document preview thumbnail
Preview 2 out of 13 pages

Access - Answer A database program you use to enter, organize, display, and retrieve related information. Access window - Answer The program window that appears when you start the Access program to create a new database or open an existing database. Add & Delete group - Answer A group on the Fields tab in Table Datasheet view that contains options for adding different types of fields to a table. All Access Objects - Answer The default category in the Navigation Pane; it lists all the objects in the database grouped by type (tables, queries, forms, reports, and so on). AutoNumber - Answer An Access data type that automatically assigns a unique number to a record. backing up - Answer Making a copy of a database file to protect your database against loss or damage. Click to Add column - Answer In Datasheet view for a table, the datasheet column you can use to create a new field in the table. column selector - Answer In a datasheet, the column heading (also called the field selector) that you click to select the entire column. common field - Answer A field that appears in more than one table, allowing you to connect the records in the separate tables compacting - Answer A process that rearranges the data and objects in a database to decrease its file size, thereby making more space available on your disk and letting you open and close the database more quickly. Create tab - Answer A tab on the Ribbon that provides options for creating various database objects, including tables, forms, and reports. Current Record box - Answer The box that appears at the bottom of a datasheet or form and that indicates the current record and total number of records displayed. data type - Answer The field property that determines what field values you can enter for the field and what other properties the field will have. database - Answer A collection of related tables stored in the same file. database management system (DBMS) - Answer A software program that lets you create databases and then manipulate data in them. datasheet - Answer The display of a table's contents in rows and columns, similar to a table or spreadsheet; each row is a separate record in the table, and each column contains the field values for one field in the table. datasheet selector - Answer A box in the upper-left corner of a datasheet that lets you select the entire datasheet. Datasheet view (for a table) - Answer The Access view that shows a table's contents as a datasheet in rows and columns. field - Answer A single characteristic or attribute of a person, place, object, event, or idea. field selector - Answer In a datasheet, the column heading (also called the column selector)that you click to select the entire column. field value - Answer The specific value, or content, of a field in a record. (AC 4) Fields tab - Answer tab on the Ribbon that provides options for adding, removing, and formatting the fields in a table. (AC 2) foreign key - Answer A primary key field from one table that you include as a field in a second table to form a relationship between the two tables. (AC 5) form - Answer A database object you can create and customize to maintain, view, and print records in a database in different and useful ways. (AC 22) Form tool - Answer An Access tool that creates a form containing all the fields in the table or query on which the form is based. (AC 22) Form Wizard - Answer An Access tool that asks you a series of questions, and then creates a form based on your answers. (AC 22) ID column - Answer The default field Access creates to serve as the primary key field for all new tables. (AC 2) Layout view - Answer The Access view in which you can make design changes to a form or report while it is displaying data so that you can immediately see the effects of changing the design. (AC 31) Microsoft Access 2010 - Answer A database program you use to enter, organize, display, and retrieve related information. (AC 1) navigation buttons - Answer A set of buttons found at the bottom of a table datasheet or form that you use to move through the records in the table. (AC 26) Navigation Pane - Answer The area on the left of the Access program window that lists all the objects in the database and is the main control center for opening and working with database objects. (AC 2) pencil symbol - Answer The symbol that appears in a row selector to indicate that the record is being edited. (AC 15) primary key - Answer A field, or a collection of fields, whose values uniquely identify each record in a database table. (AC 5) Print Preview - Answer The view of a report, form, or datasheet that shows you what the object will look like when printed. (AC 35) query - Answer A question you ask about the data stored in a database. In response, Access displays the specific records and fields that answer your question. (AC 22) Query Wizard - Answer An Access tool that asks you a series of questions, and then creates a query based on your answers. (AC 22) record - Answer A complete set of field values for a specific person, place, object, event, or idea. (AC 4) record selector - Answer In a datasheet, the small square at the beginning of a row (also called the row selector) that you click to select the entire row. (AC 14) relational database - Answer A collection of related tables stored in the same file. (AC 4) relational database management system - Answer A software program in which data is organized as a collection of tables, and relationships between tables are formed through a common field. (AC 6) report - Answer A formatted printout (or screen display) of the contents of one or more tables or queries in a database. (AC 23) Report tool - Answer An Access tool that places all the fields from a table or query on a report. (AC 23) Report Wizard - Answer An Access tool that asks you a series of questions, and then creates a report based on your answers. (AC 23) row selector - Answer In a datasheet, the small square at the beginning of a row (also called the record selector) that you click to select the entire row. (AC 14)


Document information

Uploaded on
April 22, 2023
Number of pages
13
Written in
2022/2023
Type
Exam (elaborations)
Contains
Questions & answers
$11.99

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
Exampool
3.9
(32)
Sold
225
Followers
148
Items
3570
Last sold
3 months ago




Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions

Whoops! We can’t load your doc right now. Try again or contact support.