Module#1: Getting Started With Sage 300 Flashcards
What is ERP?
A: Enterprise Resource Planning
B: Enter Recycling Plan
C: Engineered Resource Plan
A: Enterprise Resource Planning
What kind of Business does Sage 300 use?
A: Small to Medium
B: Medium to Large
C: Large to Massive
A: Small to Medium
What business operations are there?
A: Accounting B: Inventory and Warehouse Management C: Order Entry and Purchasing D: All of the Above E: A and B F: C and D
D: All of the Above
What are some of the different modules?
A: General Ledger B: Accounts Payable C: Accounts Receivable D: Inventory Control E: Order Entry F: All of the Above G: A and B H: C and E
F: All of the Above
What is the System Manager?
A: It controls Sage 300 and all that is involved
B: It controls access to all modules and provides tools to manage the company
C: It’s how you create Admin and Common Services
B: It controls access to all modules and provides tools to manage the company
What is the main component for System manager
A: Administrative Services
B: Common Services
C: Both
C: Both
What are the Administrative Services used for?
A: Activating Data B: Checking Data Integrity C: Maintaining user info D: Dumping and Loading Databases E: All of the Above F: None of the Above
E: All of the Above
What are the Common Services used for?
A: Maintaining company information B: Scheduling recurring transactions C: Maintaining the fiscal calendar D: Maintaining tax and bank info E: All of the Above F: None of the Above
E: All of the Above
Who uses the System Manager?
A: The One who opens Sage 300
B: The System Administrator
C: The G/L Manager
B: The System Administrator
What is the System Administrator responsible for?
A: Creating Different Ledgers and Accounts
B: Making Sure there are no Errors
C: Managing a Company’s Accounting System
C: Managing a Company’s Accounting System
What does the System Administrator use the system manager for?
A: To Create Databases B: To set user groups C: To specify what groups is authorized to do D: All of the Above E: None of the Above
D: All of the Above
What is a Database
A: Collection of info related to a subject or purpose
B: A way to monitor all information
C: A filing System like a telephone book
A: Collection of info related to a subject or purpose
What Structure does databases follow?
A: Columns and Rows B: Fields and Records C: Boxes and Checkmarks D: All E: A and B
E: A and B
How can a database be stored?
A: Paper Form B: Files C: Cards D: Digital E: Electronic form on computer accessible media F: All of the Above
F: All of the Above
What are some examples of Databases?
A: Telephone book B: Filing Cabinet C: Cookbook D: Store Catalog E: All of the Above
E: All of the Above
There are 2 types of Databases, what are they?
A: System and Company
B: A/P and A/R
C: Administrative and Common
A: System and Company
What does the System databases store?
A: User information B: Security Settings C: Passwords D: Currency Information E: All of the Above
E: All of the Above
What is Created First:
A: System Database
B: Company Database?
A: System Database
Why must a System Database be created first?
A: Because it’s how Sage 300 Works
B: The Company Database connects to it
C: It’s Random and Doesn’t Matter
B: The Company Database connects to it
A Company Database is always connected to a system database?
A: True
B: False
A: True
What is Microsoft SQL Server?
A: Software that must be installed to run Sage modules
B: A different form of Sage 300 that you can
C: A way to manage all your ledgers and accounts
A: Software that must be installed to run Sage modules
What Editions of Microsoft SQL server can you use with Sage 300
A: Enterprise B: Standard C: Express D: All E: A and B
D: All
What Does database management systems such as Microsoft SQL Server enable users to do?
A: Create B: View C: Update D: Delete Data E: All
E: All
What does SQL stand for?
A: Standard Query Language
B: Structured Query Language
C: Stupid Query Language
B: Structured Query Language
True or False: You need to know how to use SQL in order to use Sage 300?
A: True
B: False
B: False, however it helps to understand that when you use sage it passes your commands to Microsoft SQL Server
In order to manage system and company databases you need to set them up twice, where do you set them up?
A: First in SQL then in Sage
B: First in Sage then SQL
C: it’s Automatic
A: First in SQL then in Sage
in what order do you set up databases in Microsoft SQL?
A: Connect to the Server B: Open Microsoft SSMS (SQL Server Management Studio) C: Create a New Company D: Create a New System Database E: Close Microsoft SSMS
1: Open Microsoft SSMS (SQL Server Management Studio)
2: Connect to the Server
3: Create a New System Database
4: Create a New Company
5: Close Microsoft SSMS
What are Authentication modes?
A: Windows
B: SQL Server
C: Both
C: Both
What does Windows Authentication mode do?
A: Connects to Sage 300 Live Chat
B: Connects through a windows user account
C: Makes you System Administrator
B: Connects through a windows user account
What does SQL Server Authentication mode do?
A: Allows SQL Server to Perform Authentication
B: Runs Diagnostic on Sage 300
C: Starts the General Ledger
A: Allows SQL Server to Perform Authentication
How do you create a new SQL Database?
A: Right Click Database folder and select new Database
B: Click the New Database Icon
C: You can’t create a new SQL Database
A: Right Click Database folder and select new Database
How many characters can a database name be?
A: 3 B: 4 C: 5 D: 6 E: 7
D: 6
Define Collation
A: It’s rules that determine how data is sorted and compared
B: It’s when files and folders get merged together in one big folder
C: A collection of files and folders
A: It’s rules that determine how data is sorted and compared
What is A Recovery Model?
A: It’s when Sage 300 crashes and restart in the same place where you left
B: it defines about the database is logged and backed up
C: It’s a way to start Sage 300 in a recovery mode
B: it defines about the database is logged and backed up