Tables
A Table is
What is an object that is used to define and store data?
One of the types of queries in Access
What is Select, Action, Parameter, Crosstab, SQL?
True or False - A form can only display fields from ONE table at a time
What is False?
One of the parts of a Report in Access
What is Report Header, Page Header, Group Header, Detail, Group Footer, Page Footer, Report Footer?
The four basic elements of Database in Access
What is Tables, Queries, Forms, and Reports
Where do you find table properties
What is the Design view?
The number of different types of queries in Access
What is 5?
One of the different types of forms
What is Detail, Multiple Item, Split, or Navigation?
The part of the report where you place the controls that make up the main body of the report
What is Detail?
How to identify certain people in access
Primary Key
The number of different types of table relationships in Access
What is 3?
What is the most common type of query?
What is Select Queries?
One of the type of views for form
What is Design, Form, or Layout?
True or False - Record Sources must contain ALL the rows but NOT columns of data you want to display on the report
What is False?
A source of data combined with the connection information that is required to access that data
What is data Source?
Another name for records and fields
What is Rows and Columns?
The place you modify queries
What is Design view?
A form that simultaneously displays the data in the Form view and Datasheet view.
What is a Split Form?
The number of different types of tools used for reports
What is 5?
Gives answers to simple question, perform calculations, add, change, or delete data from a database
Queries
Tables in Datasheet view allow you to
What is enter information into your database?
How the Create a Query
What is in create tab click Query Wizard?
A method of creating a form which allows you to be more selective about which fields appear on the form
What is Form Wizard?
A tool which opens a blank report in Layout view, and displays the Field List from where you can add fields to the report
What is Blank Report?
Software to create, store, manage, manipulate, retrieves and update any kind of information
Database Management System