Lesson 1 & 2 Vocab Flashcards
• Backstage view
displays when you click the FILE tab and contains access to many of the commands that were on the File menu in versions prior to Microsoft Access 2010.
• Badges
small square labels
• Change Help Collection menu
in the lower-right corner of the Access Help heading lets you choose between the help topics that are available online and the help topics installed in your computer offline.
• Database
is a tool for collecting and organizing information
• Database management system (DBMS)
enables you to easily collect large volumes of data organized into categories of related information.
• Datasheet
is the visual representation of the data contained in a table or of the results returned by a query.
• Data type
controls the type of data a field will contain—whether it is text, number, date/time, or some other type of data
• Dialog box launcher
which is a small arrow in the lower-right corner of the group that you click to launch a dialog box or task pane that displays additional options or information.
• Field
Each column in a table
• FILE tab
a menu of options and commands that allows you to access various screens to perform common tasks with your database files—such as opening, saving, printing, closing, and changing user account settings and options.
• Form
control data entry and data views and provide visual cues that make data easier to work with
• Groups
common commands arranged by tabs
• KeyTips
press the ALT key, small letters and numbers
• Long text
data type can display up to 64,000 characters on the screen, but can store about one gigabyte of text
• Normal forms
Database design principles include standards and guidelines that can be used to determine if your database is structured correctly.
• Normalization
is the process of applying rules to your database design to ensure that you have divided your information items into the appropriate tables.
• Objects
tables, queries, forms, and reports in a database
• Primary key
is a column that uniquely identifies each row, such as Student ID Number.
• Query
allow you to search and retrieve the data you have stored
• Quick Access Toolbar
screen tool that helps you get your work done faster
• Record
Each row in a table
• Redundant data
wastes space and increases the likelihood of errors
• Relational database
stores information in separate tables and these tables are connected or linked by a defined relationship that ties the data together.
• Report
present your information in ways that are most useful to you.
• Ribbon
change context to match the tasks you will be performing in that view
• Short text
data type is used to store up to 255 characters of data in a field and is a good data type for a field that stores small amounts of text, such as names, cities, and states.
• Tab
things on the ribbon
• Table
the most basic database object that stores data in categories
• Application Parts
were introduced in Access 2010 and consist of predefined templates that you can add to an existing database to help extend its functionality.
• Quick Start
category of these templates contains a collection of predefined objects arranged by parts for tracking things such as comments, contacts, and issues.
• Template
ready-to-use databases that contain all of the tables, queries, forms, and reports needed for performing specific tasks
