Microsoft Access Exam Solved 100%

database management system (DBMS) - Answer a software program used to create a database and its structures, process the database, and assist in the administration of the database relational database - Answer structures data in the form of tables byte - Answer single character of data fields - Answer bytes are grouped into columns records - Answer fields are grouped into rows, collection of information about a certain thing table (a table is a relation in relational database) - Answer a group of similar rows or records primary key - Answer a field or group of fields that uniquely identifies a record foreign key - Answer a field in one table that is also stored in different table as a primary key primary key value - Answer makes each record in the table unique-no other record can have a duplicate primary key navigation pane - Answer are of the database window which lists all the tables, on the left side of the screen tables - Answer group of records, contains the information in the database datasheet view - Answer shows the content of your table, it's a grid-like view in which you can add, enter, edit, and delete records in a table design view - Answer shows only the structure to the table, it provides a grid that can be used to add, rearrange, or remove fields, but it cannot be used to add or edit records short text - Answer the most common, all-purpose data type, accepts numbers, letters, and symbols (names, addresses, zip codes, phone numbers) long text - Answer large amounts of text, (memos, notes, articles) number - Answer a wide variety of numbers, including those with decimal points, negatives, and percent's (any number except currency) date/time - Answer a calendar date, time of day, or both (birthdates, due dates, flight dates and times) currency - Answer similar to the number type but specially designed to represent money values (prices, payments)