Study sets, textbooks, questions
Upgrade to remove ads
info tech Access 1
Terms in this set (53)
A primary key is also known as the unique identifier T or F
in access, field names cannot contain digits T or F
in Access first creates a database it automatically creates a table T or F
A field with data type of --- can contain any character
When you assign a --- to a field, access will display the value you assgin rather then the name in the datasheet and form
the maximum number of characters allowed In a field whose data type is short test
database management system
An --- contains information about a given person, product, or event
An --- contains a specific peace of information about a record
the --- data type in access wil format information with a dollar sign
to move a field click the row selector and then drag the field to the desired position T or F
you can place an insertion point by tapping or clicking the fields or by pressing ---
--- are simple questions with the answers in the databases
to view the results of adding a criterion to a click the ---
Society encourages users to contribute to _____ computing, which involves reducing the environmental waste generated when using a computer.
If you forget to include a field, select that field that will follow the one you want to add by clicking the row selector, and press the insert key T or F
To view the results of saved query, press and hold or right click the query in the navigation pane or tap or click --- on the short cut menu
to delete a record, tap or click the record selection for the record, and then press the ---key(s)
to print a wide database table, a table whose contents do not fit on the screen, you will need to portrait orientation T or F
Landscape orientation means the printout is across the length (height) of the page. T or F
to remove empty space from the database you must --- the database
to delet a database object, press and hold or right-click the object in the navigation pane and then tap or click --- on the short cut menu
Standard properties are associated with all Microsoft Office documents and include author, title, and subject. T or F
automatically updated properties include system properties, such as the date created or changed file and statistics such as the file size. T or F
Redundancy means storing the same fact in more then one place. T or F
--- refers to the process to determining the tables and fields that up the database
Layout view shows a report on the screen and allows the user to make changes to the report. T or F
a relationship in a database is defined as an association between objects T or F
The first two guidelines in creating a database are ---
Identify tables and determine the primary key
Each customer has one book rep, but each book rep can have many custormers, this is an example of a one-to-many relationship T or F
A field with the (currency) data type can contain only monetary data. T or F
(Forms) are most commonly used for printing data. T or F
Names can be up to (32) characters in length. T or F
(Portrait) orientation means the text will print across the height of the page. T or F
Redundancy usually results from placing too many fields in a table. T or F
A database management system is software that allows you to use a computer to create a database; add, change, and delete data in the database; ask and answer questions; and create forms and reports. T or F
To view the results of a query, open it by clicking the name in the Navigation Pane and selecting View on the shortcut menu. T or F
Report view is usually the easiest way to make changes to a report. T or F
Fields contain information about a given person, product, or event. T or F
Which of the following is a character that can't be used in a file name?
What is the small box that, when clicked, selects the entire row?
Which of the following presents information about the database objects?
Which NUMBER field size is appropriate for integer values with the range of 0 to 255?
Which of the following includes information about the project author, title, or subject?
If a problem occurs as you back up a database, you correct the problem by copying this backup copy over the actual database, often referred to as the ______ database.
The columns in a table are called ____.
To place the insertion point after the last data record before you can enter additional data; use the _______ buttons near the lower-left corner to move within the table.
In ____ view, the table is represented as a collection of columns and rows.
_______ are simply questions, to the answers to which are in the database.
a field that cantons dates or times
a field can store only one of two values. the chooses are yes/no, true/false, and no/ off
a field can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255
field specified as a calculation based on other fields . the value is not actually stored.
Recommended textbook explanations
Java Methods: Object-Oriented Programming and Data Structures
Gary Litvin, Maria Litvin
C++ for Everyone
Cay S. Horstmann
C++ How to Program (Early Objects Version)
Harvey M. Deitel, Paul J. Deitel
C++ for Engineers and Scientists
Gary J Bronson
Sets with similar terms
Access Chpt 1
ACCESS chapter 1
Access Chapter 1
Access Test 1
Other sets by this creator
GEO chapter 11
Other Quizlet sets
Chapters 1: Early Civilizations
Muscle, Tendons & Ligaments
1.00 Biomedical Research- Study Guide